InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
Is It Possible To Call A Macro From The Condition True Or False Side Of A Worksheet Formula? I.e. If(a2="ok",run Macro1,run Macro2)? |
|
Answer» Basically, the answer is No. You can write functions in VBA that you can call from worksheet cells, but these functions can only RETURN a value. They can't modify other cells or ALTER any part of the Excel ENVIRONMENT. (You MAY be ABLE to use a worksheet change event to call the macro.) Basically, the answer is No. You can write functions in VBA that you can call from worksheet cells, but these functions can only return a value. They can't modify other cells or alter any part of the Excel environment. (You may be able to use a worksheet change event to call the macro.) |
|