| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
If then else
I'd like to writer a macro to execute certain activities dependent on the
value of a cell. Thx. cg |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
If then else
hccatmo wrote:
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 ------------------- On x gosub routine1, routine2, ... ---------------------------------- y = Application.Run("file.xls!Macro", x) ---------------------------------------- ()---cucchiaino |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
If then else
Thx. Great help.
cg "cucchiaino" wrote: hccatmo wrote: 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 ------------------- On x gosub routine1, routine2, ... ---------------------------------- y = Application.Run("file.xls!Macro", x) ---------------------------------------- ()---cucchiaino |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
If then else
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 http://www.vonixx.com "hccatmo" wrote: I'd like to writer a macro to execute certain activities dependent on the value of a cell. Thx. cg |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
