Control box/Command buttons

[Guest]

I understand how to make one but what i do not usderstand is where to put the
code to make other stuff happen. Here is example. I made a Command Box and
named it Random. I put it in F3 and it is set for a single click. Now what I
want to do is get it to put a random number that is generated when I push the
button in F4. I know hwo to make the random code just not where to put in the
box.

Also I want to put a check box in say H3 and if checked then a drop down
menu ( I know valaditation list) appers for selection. How is this
accomplished. I'm such a noob!

 

[Bob Phillips]

Control box buttons are event driven. If you go to design mode, then
double-click the button, Excel will create a skeleton button click event
procedure that you can fill in.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Guest]

I understand that part but if I put in =INT(RAND()*(100-1)+1) nothing
happens, i have tried every combo I know and i do not knwo VBA at all so i
am very stumped. IF i get this figured out i am sure I can do rest on own.

 

[Bob Phillips]

You put that in VBA? Where? How? Give us a clue, we cannot min-read what you
did.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Guest]

I said I do not know VBA so I do not understyand your sarcasm. All I have
asked for is help on gettnig the button to do that formula and do it in a
different cell, not sure why you can not understand that part, and possible
an example and you have not offered anythign but sarcasm this time. Your
first post was I responded that I knew how to do that. So thanks for the
help.. Maybe some one who understands control box and the macro function for
them can help me.

 

[Bob Phillips]

That wasn't sarcasm, just a request to help us .., but you take it however
you want.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Guest]

I hae no clue how to make it clearer than what i have said. I wnt the
command button to execute that command and have the result in another
cell,,IE command button in F3 and result in F4. Is thsi possible or
impossible?