willow1985
Well-known Member
- Joined
- Jul 24, 2019
- Messages
- 886
- Office Version
- 365
- Platform
- Windows
I need another Macro to be called based on a cell value in a particular workbook (yes the workbook will be open)
What I need is as follows:
IF in workbook: Manager Review Meeting Dashboard, Sheet: Dashboard, Cell: W8
= “Second”
Call Macro “Second”
IF in workbook: Manager Review Meeting Dashboard, Sheet: Dashboard, Cell: W8
= “Third”
Call Macro “Third”
IF in workbook: Manager Review Meeting Dashboard, Sheet: Dashboard, Cell: W8
= “First” OR BLANK
Call Macro “First”
Below is an idea of how the code runs before I need it to take a break and call another macro to run:
Any help would be greatly appreciated
Thank you!
What I need is as follows:
IF in workbook: Manager Review Meeting Dashboard, Sheet: Dashboard, Cell: W8
= “Second”
Call Macro “Second”
IF in workbook: Manager Review Meeting Dashboard, Sheet: Dashboard, Cell: W8
= “Third”
Call Macro “Third”
IF in workbook: Manager Review Meeting Dashboard, Sheet: Dashboard, Cell: W8
= “First” OR BLANK
Call Macro “First”
Below is an idea of how the code runs before I need it to take a break and call another macro to run:
VBA Code:
‘Macro code etc etc
Range("Y1").Select
ActiveCell.FormulaR1C1 = "Falls between prev yr selected range"
Range("Y2").Select
‘REQUIRE RUNNING ANOTHER MACRO BASED ON CONDITIONS (AS PER ABOVE)
‘Continue running remaining macro
Sheets("Data").Select
Workbooks.Open etc etc
Any help would be greatly appreciated
Thank you!