G
Guest
I'd like to writer a macro to execute certain activities dependent on the
value of a cell.
Thx.
cg
value of a cell.
Thx.
cg
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Guest
Your question is about a whole programming topic.
To begin, you may go to Visual Basic Editor, call the Help, and type "IF
statement" in the search box. Then choose "Using If...Then...Else Statements".
The on-line help is a very useful source of technical information.
Regards,
Edwin Tam
(e-mail address removed)
http://www.vonixx.com
To begin, you may go to Visual Basic Editor, call the Help, and type "IF
statement" in the search box. Then choose "Using If...Then...Else Statements".
The on-line help is a very useful source of technical information.
Regards,
Edwin Tam
(e-mail address removed)
http://www.vonixx.com
C
cucchiaino
hccatmo said:I'd like to writer a macro to execute certain activities dependent on the
value of a cell.
x=Range("A1").value
-------------------
Select case x
Case 1 to 3
...
Case ...
end select
G
Guest
Thx. Great help.
cg
cg
cucchiaino said:x=Range("A1").value
-------------------
Select case x
Case 1 to 3
...
Case ...
end select
-------------------
On x gosub routine1, routine2, ...
----------------------------------
y = Application.Run("file.xls!Macro", x)
----------------------------------------
()---cucchiaino