Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 109
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Setting up data validation and lookup tables...? Birmangirl Excel Discussion (Misc queries) 3 November 12th 08 12:06 AM
Setting Data Validation Techtrainer Excel Discussion (Misc queries) 2 June 19th 08 08:11 PM
Data validation lists help? RMcA Excel Worksheet Functions 6 January 29th 08 07:11 PM
Data validation with validation lists and combo boxs Keith Excel Discussion (Misc queries) 1 October 12th 06 11:08 AM
Data Validation Lists dzierzekr Excel Worksheet Functions 1 September 15th 06 08:43 PM


All times are GMT +1. The time now is 02:38 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"