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
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