Hi experts, i want to create a button on my sheet, which will take me conditionally to the next step.
if the first is not complete it will take me back to the first step (i don't want to use the hyperlink formula)
so, I want to do something like a conditional gotocell macro, and assign it on a shape.
(in the picture, just if first and last names are entered i want it should take me back to the next sheet, if not it shold take me back to the empty fields)
As a hyperlink I would write something like this: =HYPERLINK(\"#\"&IF(I10=\"\",\"Name!I10\",IF(I14=\"\",\"Name!I14\",\"details!a1\")),\"Next>\")
Hi experts, i want to create a button on my sheet, which will take me conditionally to the next step.
if the first is not complete it will take me back to the first step (i don't want to use the hyperlink formula)
so, I want to do something like a conditional gotocell macro, and assign it on a shape.
(in the picture, just if first and last names are entered i want it should take me back to the next sheet, if not it shold take me back to the empty fields)
As a hyperlink I would write something like this: =HYPERLINK(\"#\"&IF(I10=\"\",\"Name!I10\",IF(I14=\"\",\"Name!I14\",\"details!a1\")),\"Next>\")
​ Hi , no need i figured the commend my self.
here is it:
Sub variables()\n\n If IsEmpty(Range(\"i10\")) Then\n \n Application.Goto Reference:=Worksheets(\"name\").Range(\"i10\"), _\n scroll:=True\n \n ElseIf IsEmpty(Range(\"i14\")) Then\n \n Application.Goto Reference:=Worksheets(\"name\").Range(\"i14\"), _\n scroll:=True\n \n Else\n \n Application.Goto Reference:=Worksheets(\"details\").Range(\"A3\"), _\n scroll:=True\n \n End If\n \nEnd Sub
","body@stringLength":"780","rawBody":"​ Hi , no need i figured the commend my self.
here is it:
I want it to be non-editable. I don't want to lock the cell because I wanna set the locked cells to be non-selectable!.JKPieterse
","body@stringLength":"357","rawBody":" I want it to be non-editable. I don't want to lock the cell because I wanna set the locked cells to be non-selectable!.
Sort by table chronologically in MS Excel when some date are DD/MM/YY and some are YYYY only | Microsoft Community Hub