Forum Discussion

mtlbooks's avatar
mtlbooks
Copper Contributor
Mar 06, 2023

conditionel goto command in vba

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...
Macros and VBA
mtlbooks's avatar
mtlbooks
Copper Contributor
Mar 09, 2023

  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 

mtlbooks's avatar
mtlbooks
Copper Contributor
Mar 09, 2023

​  Hi , no need i figured the commend my self. 

here is it:

 

Sub variables()

    If IsEmpty(Range("i10")) Then
    
        Application.Goto Reference:=Worksheets("name").Range("i10"), _
 scroll:=True
        
    ElseIf IsEmpty(Range("i14")) Then
    
        Application.Goto Reference:=Worksheets("name").Range("i14"), _
 scroll:=True
 
 Else
    
       Application.Goto Reference:=Worksheets("details").Range("A3"), _
 scroll:=True
    
    End If
    
End Sub

mtlbooks 

Resources