Archive for Thursday, March 13th, 2008
How To: Assign a Macro to an ActiveX Control
by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2008. All rights reserved.
In the latest post, I showed how to assign a macro to a Forms menu control or other shape on a sheet. Macros can also be run from the ActiveX controls on the Control Toolbox.
We'll use this simple macro for this example.
PLAIN TEXT
Visual Basic:
Sub HelloWorld()
MsgBox "Hello, World! ", vbExclamation
End Sub
When it is run, [...]
Posted: Thursday, March 13th, 2008 under VBA.
Comments: none
