Forum Discussion

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

JKPieterse

Silver Contributor

Mar 07, 2023

Why not use that HYPERLINK function?

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

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