Has anyone created forms in Excel with drop down boxes?
 

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

"mcdanik" wrote:

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

--

HTH

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


"mcdanik" wrote in message
...
This is the orginal question, Has anyone created forms in Excel with drop
down boxes?

"mcdanik" wrote:

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

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

--

HTH

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


"mcdanik" wrote in message
...
This is the orginal question, Has anyone created forms in Excel with drop
down boxes?

"mcdanik" wrote:

Go to the VBE (Alt-F11)
Insert a userform (InsertUserform)
Make Sure the toolbox is viewable (ViewToolbox)
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)


"LisaN" wrote in message
...
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" wrote:

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

--

HTH

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


"mcdanik" wrote in message
...
This is the orginal question, Has anyone created forms in Excel with
drop
down boxes?

"mcdanik" wrote:

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

LisaN wrote:

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

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

--

HTH

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


"mcdanik" wrote in message
...
This is the orginal question, Has anyone created forms in Excel with drop
down boxes?

"mcdanik" wrote:






--

Dave Peterson