If then else

G

Guest

I'd like to writer a macro to execute certain activities dependent on the
value of a cell.
Thx.
cg
 
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
 
C

cucchiaino

hccatmo said:
I'd like to writer a macro to execute certain activities dependent on the
value of a cell.
Click to expand...


x=Range("A1").value

-------------------

Select case x
Case 1 to 3
...

Case ...

end select
 
G

Guest

Thx. Great help.
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
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

vba to append to a text file 5
Uncheck \View\Toolbars\... 2
Workbook open to the same sheet 4
set font color depending on value Range 4
debuggin help 14
COPY/PASTE to body of email the format of Excell cell 2
Ad a calendar so that user can choose the date rather than type it 2
change text in string 2

Top