Excel 2000 - Data Validation/Dynamic range drop down menu problem

  • Thread starter Thread starter denmatic
  • Start date Start date
D

denmatic

Hi!

*First off:* I have created a spreadsheet that has a dynamic range an
data validation.

*Next:* i know i can add options to the 'dynamic range' and my dro
down menu will add the option to its list.

*Problem:* How can I make it so the user can add data into th
validated data list/drop down menu rather than having the user addin
it into the dynamic range?

*Example:*this drop down menu indicates how often a system is updated
weekly, monthly, etc. etc... i don't want to restrict it, so i want t
make it so they can indicate their own time on how often those update
occur.

TIA

- Denni
 
I'd suggest giving the user an option to click a command
button that creates an input box. The user adds data to
this input box, and this data will be appended to the
bottom of the current source list for the validation. For
more info on using Input Boxes:

XL2000: How to Use Input Boxes with Visual Basic for
Applications

http://support.microsoft.com/default.aspx?scid=kb;en-
us;213614

HTH
Jason
Atlanta, GA
 
thanks debra for the example file...

im not really a VB guru... a few questions:

If Target.Column = 3 And Target.Row > 1 Then

does the above mean *column C* and any row greater than 1?

because i tried the code and its still restricting..
 
Yes,

Target.Column = 3 And Target.Row > 1

means column C, any row greater than 1.

What restrictions are you seeing? Have you removed the check mark from
the box on the Error Alert tab in the Data Validation dialog box?
 
Back
Top