Help on Macro

Ai_no_Bakayarou
07-22-2001, 09:39 PM
How do u call a macro programmacticaly??? Is it possible to make the msgbox text to be red in color?? Is it possible to make a 'beep' sound without using macro???

KesleyK
07-23-2001, 08:40 AM
In Excel VBA, if the macro is in a Module, you just call the name of the macro:

Macro1

if the macro is in a Worksheet, you need to use the Worksheet name also:

Sheet1.Macro1

You need to design a form to act like MsgBox to make the text red.

Without making an error, I don't think so.

______
Cheers!

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum