Whats up everyone I have a simple question. I created a userform (button) that will copy some cells and paste them somewhere. I want the button to be on the sheet rather than having to go to VBA to run or using a macro to bring up the userform. Is there a way to just have the button show on the sheet. If so how can I do this.

Thank you all for your help.

Mike

Hi

Im not sure what you mean by you want the button to show on the sheet but if you added the button on the sheet (From Control Toolbox Toolbar) you need to add the code or call the macro/Sub from the onclick event. To enable the button to test the code use the "Exit Design Mode" Button on your Control Toolbox.

If this is not what you looking for you could send me some more detail...

Marnus

Ok I will try to give you as much detail as possible. I would like the button to be embedded in the sheet (in a cell)

The way I have it set up right now. I have to run a macro called Show it:

Sub ShowIt()
    Randomizer.Show
End Sub

Once the macro is ran the userform pops up in the excel sheet. Instead of running this macro I would like the userform directly on the sheet.

I can email you a screenshot if that would help. Thank you

It is as acdsky said,

from the "Control Toolbox" toobar select Command button.

The cursor changes to a small cross, move to area of sheet you wish the buttoon to be, click and hold left mouse button to draw commandbutton.

double click left mouse on command button to bring up code

eg
Private Sub CommandButton1_Click()

End Sub

then type into event what you want the button to do
Private Sub CommandButton1_Click()
Randomizer.Show
End Sub

Finally Select the "Exit Design Mode" button on the control toolbox to enable the command button.

Hope this helps

Martin