If then else
 

I'd like to writer a macro to execute certain activities dependent on the
value of a cell.
Thx.
cg

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

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

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