View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Khanjohn Khanjohn is offline
external usenet poster
 
Posts: 39
Default Control box/Command buttons

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!