Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do you run a Macro from an IF statement in Excel 2000?
I have recorded a Macro that runs correctly, but need it to run from an If
function after user has entered a particular word. Any help were be appreciated. Thanks Rosey |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do you run a Macro from an IF statement in Excel 2000?
right click sheet tabview codeinsert this
Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address < "$B$2" Then Exit Sub If UCase(Target) = "JOE" Then Call bill End Sub Sub bill() MsgBox "Hi there Joe" End Sub -- Don Guillett SalesAid Software "Rosey" wrote in message ... I have recorded a Macro that runs correctly, but need it to run from an If function after user has entered a particular word. Any help were be appreciated. Thanks Rosey |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro error after switching from Excel 2000 to Excel 2003 | Excel Discussion (Misc queries) | |||
Search, Copy, Paste Macro in Excel | Excel Worksheet Functions | |||
Activate method of Worksheet class fails in Excel 2000 | Excel Discussion (Misc queries) | |||
Excel 2003 crashes loading excel files created Excel 2000 | Excel Discussion (Misc queries) | |||
Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) |