Macro option to open the Assign Macro dialog box to choose the macro you want to assign
to the textbox. Thus, the main difference between assigning a macro to a button from
the Form toolbar and to a drawing object is that the Assign Macro dialog box comes up
automatically in the first case while you need to right-click on the object to bring it up
in the latter case. Irrespective of how you place a button or a drawing, the running of
a macro via a graphic object is simple and provides more interactivity in many situa-
tions.
Visual Basic Editor
The method of creating macros through macro recording is of limited ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month, and much more.