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" wrote:

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)



"Khanjohn" wrote in message
...
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!