| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how can I insert a macro into a boolean statement
now can I call a macro from a boolean statement i.e. "=if(c4<c5,call
macro,c4)"? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how can I insert a macro into a boolean statement
right click sheet tabview codeinsert this and enter =now() somewhere on
the sheet but be aware it will fire each time anything is calculated on the sheet. You might prefer a worsheet_change event restricted to only cell c4 Private Sub Worksheet_Calculate() Application.EnableEvents = False If Range("c4") < Range("c5") Then MsgBox "HI" Application.EnableEvents = True End Sub -- Don Guillett SalesAid Software "Garrett" wrote in message ... now can I call a macro from a boolean statement i.e. "=if(c4<c5,call macro,c4)"? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to create automatic macro with if statement or similar | Excel Discussion (Misc queries) | |||
| Closing File Error | Excel Discussion (Misc queries) | |||
| Run Macro From If Statement | Excel Discussion (Misc queries) | |||
| How do I insert the date using a macro | Excel Discussion (Misc queries) | |||
| Macro and If Statement | Excel Discussion (Misc queries) | |||
Linear Mode
