Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
OK I admit that I can not make a Command Button work
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
OK I admit that I can not make a Command Button work
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 "Khanjohn" wrote in message ... 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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
OK I admit that I can not make a Command Button work
Thanks Mile a biga DUH for me lol
"Khanjohn" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
code for command button not work | Excel Programming | |||
Worksheet Command Button will not work | Excel Worksheet Functions | |||
Spin button in a work sheet - how do I make it work? | Excel Worksheet Functions | |||
How do I make a command button invisible or visible? | Excel Programming | |||
Make Command Button visible only in .xlt? | Excel Programming |