Command Button Control

Microsoft Excel 2003 (full product)
September 30, 2009 at 12:09:37
Specs: Windows XP
I thought I saw this somewhere, but can't find it, so I came here.

I want to assign a macro to a comand button so that when a user clicks the button, it will prompt a message to clear all contents.

I don't want to do this on a userform. I would like to place the button on a spreadsheet and have the macro work there.

Is that possible?

See More: Command Button Control

Report •

September 30, 2009 at 12:18:17
Yes, it's possible.

You can assign a macro to any shape or picture that you place on a worksheet just by right-clicking the object and selecting Assign Macro.

You can also add a button or menu item by using the Tools...Customize...Commands Tab.

Scroll down to Macros and click on it. Drag the button or menu item to wherever you want it and, with the Customize window still open, right-click it and select Assign Macro.

You can also edit the button image or text as long as you have the Customize window open.

Report •
Related Solutions

Ask Question