Excel - VBA - 2 Joined macros not working - MsgBox issue - Please help!

**kcc2009** · 02-15-2016, 10:38 AM

Hi,

Relatively new to VBA and I'm looking for some help. This will probably be simple but I cant seem to get this to work.

Looking to join 2 macros together (I've checked them on separate spreadsheets and they work separately but not together).
First macro deletes rows depending on criteria selected from a drop down list.
Second macro shows an error message box depending on criteria within a separate cell. I would like this to be cell C19 however C19 already has a formula in it. I would like the result of the formula within C19 (HIGH/MEDIUM/LOW) to trigger the error message box - is this possible?
If not, then I can use cells C29, C32 and C35. My sheet is called "REPORT".

My code so far:

Please Login or Register  to view this content.

Any help would be greatly appreciated!
thanks

**Kaper** · 02-15-2016, 10:59 AM

1) it is wise not to use ambiguous names for your procedures MsbBox is already standard proc, so better name it MyMsgBox or whatever.

2) you can call one procedure within another. for instance:

Please Login or Register  to view this content.

Moreover - it seems that all your code sits in a worksheet module. I'd probably move second procedure to standard module (of course without Me. in such case).

**kcc2009** · 02-15-2016, 12:07 PM

Thanks for your reply.
I've kept it in a worksheet module to avoid having all separate macros .. whats the difference between the standard module?
I've added the code above with the MyMsgBox but it still isn't working, any ideas? Can you also help in telling me whether I can use cell C19 for this message box even though it already has a formula in it?

Thanks