Data Validation
Hi,
Excel 2002.
I like the Data Validation with the list option but I have come across
two problems with the way I want to use it.
1. The source reference cells must be on the same sheet as the data
entry cell(shame!).
2. After creating the validation rules, if I add an extra entry to my
array, I need to go back to the Data / Validation option and update
the value to include the new entry.
I can get round 1 by copying the table from Sheet2 to Sheet1 (not
ideal solution though).
I cannot see how to update the validation rules in VBA. I've looked at
the object model but cannot see what I need to update - if I can at
all.
Basically, I have Sheet2 where there is a list of companies. Users can
update this list at will.
On sheet1 I want them to enter data and only enter valid company names
(hence Data / Validation). However, when new companies are added they
need to be copied to Sheet1 then, somehow, I need to update the Data /
Validation programatically. How can I do this?
Is there are better way to do this than use the Data / Validation
route?
|