Creating labels

[newbie_ex]

Hi everyone,
I am trying write VBA code in excel 2007. I am not able to define my problem. I am illustrating it as,
I am trying to create a different set of codes to be executed when i give reference of it, like

Dim Alpha as long
Alpha = Range("A1").value
'now here i want to give the reference that'
if alpha > 2 then
'something like goto code 1'
else: goto code 2
end if
'where'
Code1:
<<<>>>>>
and
Code2:
<<<<>>>>
end sub

Hope that you got my question

 

[Momentman]

if code1 is a macro then you could use the call statement like

call code1[\code] and same for code2

 

[newbie_ex]

thank you. But it would be easier for me if you illustrate it.

 

[Momentman]

thank you. But it would be easier for me if you illustrate it.

Dim Alpha As Long
Alpha = Range("A1").Value
'now here i want to give the reference that'
If Alpha > 2 Then
    Call code1
Else
    Call code2
End If

 

[newbie_ex]

Thank you very much