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

[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

 

[Jason Morin]

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

 

[Debra Dalgleish]

There's a sample file here that automatically adds new items to the
source list:

http://www.contextures.com/excelfiles.html

under Data Validation, look for 'Update Validation List'

 

[denmatic]

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..

 

[Debra Dalgleish]

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?

 

[denmatic]

lol... its always the small things that get in the way... thanks debra