OK I admit that I can not make a Command Button work

G

Guest

I open the Control tool Box, selcet the one to click. I cna edit name etc
but I can never get it to not allow me to resize it or edit it. what am I
doing wrong? I wnt to add a formula in the VBA part which I have tso that
when it is clicked it will random a number. Would liekth enumber in cell
below the button so as nto to have to sue F9. I have 2 cells in worksheet
that used randon numbers but if I click anything, type anything they
randomize. Kind of anoying. Only want them to work when I hit F9 or thsi
button. Would rather have the button.

How do I accomplish this?
 
M

Mike Fogleman

Sounds like you are still in DESIGN MODE. The first icon in the toolbox is a
triangle. When you click it, Design Mode is toggled On/Off for the object
you were building. Design Mode ON to edit the object, Design Mode Off to use
the object.
Your randomize code sounds like it is WorkSheet_SelectionChange event
code. Move this code to your CommandButton_Click code.

Mike F
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Command button does not run code 2
Random generator question 3
URGENT help needed for a macro to place and size command button 7
send/receive button does not work 7
Command Button or Macro that will email a spreasheet 13
How do I make a command button invisible or visible? 3
How do I insert a button in Excel 2007 1
Assign Macro to Command Button doesn't work 2

Top