LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 270
Default Range Name in Data Validation

What is the proper way to refer to a range name on another worksheet (same
workbook), that you want to use as a drop-down list for data validation?
I've tried everything to no avail. Here's what I have, that doesn't work
(the range name I want to use is "StartTime"). Can someone advise what I'm
doing wrong here?

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
With Range("$E$13:$E$36").Validation
.Delete
.Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:= _
xlBetween, Formula1:=Worksheets("Range Names").Range("StartTime")
.IgnoreBlank = True
.InCellDropdown = True
.InputTitle = ""
.ErrorTitle = ""
.InputMessage = ""
.ErrorMessage = "Invalid entry; please use the drop-down menu to select
a response."
.ShowInput = True
.ShowError = True
End With
End Sub
 
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
Validation Data using Validation Table cell range..... Dermot Excel Discussion (Misc queries) 16 January 5th 10 09:35 PM
Data Validation to range names for Chart Source Data Candyman Charts and Charting in Excel 1 September 3rd 09 07:27 PM
Data Validation and Name Range Harry Stevens Excel Worksheet Functions 2 May 21st 07 06:59 PM
Data Validation range Nigel Excel Discussion (Misc queries) 2 December 15th 05 10:33 AM
Dynamic Range for Data Validation Revolvr Excel Programming 2 July 8th 05 07:25 PM


All times are GMT +1. The time now is 12:58 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"