M
mcdanik
This is the orginal question, Has anyone created forms in Excel with drop
down boxes?
down boxes?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Bob Phillips
Yes, have you tried, if so what is the problem?
--
HTH
RP
(remove nothere from the email address if mailing direct)
--
HTH
RP
(remove nothere from the email address if mailing direct)
L
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,
I'm looking to create a form in Excel with drop down boxes. How do I go
about doing that?
Tks in advance,
B
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)
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)
D
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
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