Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a cell that has data validation (=list), populated by a named range
In my VBA, I need to be able to reset that list to the first value in the list. I had the code working, but I must have tweaked something without knowing it, and now it doesn't work anymore. If Target.Address = "$B$2" Then 'just reset the date back to earliest date in the list S = Sheet12.Range("E2").Validation.Formula1 Sheet12.Activate Sheet12.Range("E2").Value = Range(S)(1) '<- this is the line that doesn't work Set Target = Sheet12.Range("E2") End If Thanks for any advice, Keith |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Data Validation List from a Dynamic Named Range on Another Workshe | Excel Worksheet Functions | |||
Finding first value in named range referred to in data validation list | Excel Programming | |||
Remove empty cells from named list / validation list | Excel Worksheet Functions | |||
Dynamic Named Range inside a Data Validation list ? | Excel Programming | |||
Using a data validation list to look up a defined named range in another worksheet | Charts and Charting in Excel |