Has anyone created forms in Excel with drop down boxes?

[mcdanik]

This is the orginal question, Has anyone created forms in Excel with drop
down boxes?

 

[Bob Phillips]

Yes, have you tried, if so what is the problem?

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[LisaN]

Hi Bob,

I'm looking to create a form in Excel with drop down boxes. How do I go
about doing that?

Tks in advance,

 

[Bob Phillips]

Go to the VBE (Alt-F11)
Insert a userform (Insert>Userform)
Make Sure the toolbox is viewable (View>Toolbox)
Drag a combobox control off of the toolbox onto the form

Populate the DD in code with something Like

Private Sub Userform_Activate()

With Me.ComboBox1
.AddItem "Text1"
.AddItem "Text2"
'.. etc
End With

End Sub

and that's just the start


RP
(remove nothere from the email address if mailing direct)

 

[Dave Peterson]

What do you mean by a form?

Do you mean setup a worksheet to use as a form?
If yes, look at Debra Dalgleish's site for Data|Validation
http://www.contextures.com/xlDataVal01.html
(easy to create and use)

If you mean a userform, you can look at some getstarted notes also on Deb's
site:
http://www.contextures.com/xlUserForm01.html
and it includes a link to Microsoft:
http://www.microsoft.com/ExcelDev/Articles/sxs11pt1.htm