Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Simple conditional macro
Sub CallOneOrTheOther()
if Range("A1").Value 100 then macro1 else macro2 End if End Sub Sub Macro1() msgbox "Value is greater than 100" End Sub Sub Macro2() msgbox "Values is less than or equal to 100" End Sub -- Regards, Tom Ogilvy "Boz.theale" wrote in message ... As a novice user, can anyone please supply me with VB code to enable me to construct a macro that calls one of two other macros dependent on the value of a particular worksheet cell Many thanks ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
A very simple conditional formatting question | Excel Discussion (Misc queries) | |||
SIMPLE VBA MACRO FOR CONDITIONAL FORMATTING | Excel Discussion (Misc queries) | |||
simple conditional formatting | Excel Discussion (Misc queries) | |||
Conditional formatting, simple question... | Excel Worksheet Functions | |||
Simple conditional formula | Excel Programming |