Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting up data validation lists
I need to set up two lists in one column.
When the user gets the file it contains data, he will add data to it. I want one list for the original data and another for 200 additional rows. I use the following to add the first list but have not been able to modify it so that list 2 can be added. Sub enterDV() Range("F2:F" & Range("F" & Rows.Count).End(xlUp).Row).Validation.Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:= Formula1:="mylist1" End Sub I have tried offset but really haven't a clue how to go about it. Thanks in advance Gareth |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Setting up data validation and lookup tables...? | Excel Discussion (Misc queries) | |||
Setting Data Validation | Excel Discussion (Misc queries) | |||
Data validation lists help? | Excel Worksheet Functions | |||
Data validation with validation lists and combo boxs | Excel Discussion (Misc queries) | |||
Data Validation Lists | Excel Worksheet Functions |