Attach VBA to a Button

**nickhunt** · 11-07-2013, 03:46 PM

hi folks,

I have the following code that I want to attach to a button, but am at a loss of how to?

Sub sbClearCellsOnlyData()
Range("A1:D5").ClearContents
End Sub

Nick

**judgeh59** · 11-07-2013, 03:50 PM

you could do it with a shape....insert a shape (Box, Oval). then right click on the shape and "Assign Macro". A list of macros will come up and choose your macro...This is for 2010....not sure in 2003....

**nickhunt** · 11-07-2013, 04:00 PM

Thanks, that's sorted it

**judgeh59** · 11-07-2013, 04:01 PM

glad I could help....

**martindwilson** · 11-07-2013, 04:04 PM

you just create a button from the forms tool bar
right click it assign macro

Attach VBA to a Button

LinkBack

Thread Tools

Rate This Thread

Display

Attach VBA to a Button

Re: Attach VBA to a Button

Re: Attach VBA to a Button

Re: Attach VBA to a Button

Re: Attach VBA to a Button

Thread Information

Users Browsing this Thread

Similar Threads

Attach Hyperlink to textbox or control button?

trying to attach a macro to a button

how to attach a up and down arrow to a spin button

I cannot find the [Browse] button to attach a post?

[SOLVED] in this version I can not attach a Macro to a Button

Bookmarks

Bookmarks

Posting Permissions