Running a macro through a command button

Question

Running a macro through a command button

farnye (Civil/Environmental)

(OP)

27 May 03 11:03

I'm having problems getting this to work. Do you just use a simple run command in the command button code?

I basically want to click a given button and the macro will start.

jproj (Chemical) · Answer 1 · 2003-05-27 13:04:43

The easiest way I know how to do it is write your macro first.  Next, insert your control button and then double click on it (that should open the VBA editor window).  Next, copy the macro you wrote (excluding the "Sub" and "end" lines) and paste it in the command button sub proceedure.  Then just exit the design mode (in excel) and you should be able to execute the macro by clicking you button.  Alternately (as long as you know the name of your cammand button), you can just re-name your sub proceedure from:

Sub MyMarco()   to   Sub CommandButton1_Click()

but this will only work if the command button is named "CommandButton1".  If you get stuck, search the help.

Good Luck!

jproj

plawrence (Mechanical) · Answer 2 · 2003-05-27 15:33:08

When I create a button, a box pops up asking if I want to assign a macro. Or right-click an existing button and select 'assign macro.' Then assign existing code or create new code with the name suggested.

Patrick

farnye (Civil/Environmental) · Answer 3 · 2003-05-30 09:25:58

Thanks, that solved my problem. (i had to many "End"s)

Come Join Us!

Posting Guidelines

Running a macro through a command button