User Form

  • Thread starter Thread starter SP
  • Start date Start date
S

SP

I have created a UserForm with Option Buttons. There are a total of 34. I
have enclosed these in a Frame to allow the User to select more than one.
Once they have selected the items, I would like Excel to place them in the
appropriate cells once they click on OK. The information would appear D3:K3
on a worksheet titled Short Form. Can any assist me with the code? I was
happy that I was able to at least complete the form.

Sheri
 
Hi Sheri

I'd use a "Combobox" for this -it's a dropdown list kind of thing, pretty standard,
intuitive and available in the controls toolbox.
 
Harald, the toolbox through Visual Basic?


Harald Staff said:
Hi Sheri

I'd use a "Combobox" for this -it's a dropdown list kind of thing, pretty standard,
intuitive and available in the controls toolbox.

--
HTH. Best wishes Harald
Excel MVP

Followup to newsgroup only please.
 
Back
Top