how do I add data validation dropdown lists to a Form

[SteveD.IFlora]

I have created validation rules for columns in excel with drop down lists to
select from.I have then created a form using the tool bar and the headings
above my validation rules. The rules work within the form but I am unable to
see the drop down list in the form and therefore cannot select from the LOVs.
Microsoft Office xp version 10

 

[Bob Phillips]

I think you will need to build your own custom userform for this type of
functionality.

--

HTH

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

 

[SteveD.IFlora]

Thanks Bob - at least I won't spend any more time on the toolbar form - now I
just need to look up how to create my own form!

 

[Bob Phillips]

Steve,

Here are some starters

http://www.microsoft.com/ExcelDev/Articles/sxs11pt1.htm
Lesson 11: Creating a Custom Form
Excerpted from Microsoft® Excel 97 Visual Basic® Step by Step.

http://support.microsoft.com/default.aspx?kbid=161514
XL97: How to Use a UserForm for Entering Data

http://support.microsoft.com/default.aspx?kbid=213749
XL2000: How to Use a UserForm for Entering Data

http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q168067
File Title: Microsoft(R) Visual Basic(R) for Applications Examples for
Controlling UserForms in Microsoft Excel 97

Peter Aiken Articles:
Part I
http://msdn.microsoft.com/library/en-us/dnoffpro01/html/IntroductiontoUserFormsPartI.asp

Part II
http://msdn.microsoft.com/library/en-us/dnoffsol02/html/IntroductiontoUserFormsPartII.asp


--

HTH

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