Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Populate Data Validation List
Hi. Is it possible to populate a data validation list with the sheet
names in a workbook? And as a sheet is added or sheet name changed, the list automatically updates? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Populate Data Validation List
First enter this UDF:
Function sheetname(i As Integer) As String sheetname = "" If i Sheets.Count Then Exit Function sheetname = Sheets(i).Name End Function Then, in an unused column, enter: =sheetname(ROW()) and copy down -- Gary''s Student - gsnu2007g "Steve" wrote: Hi. Is it possible to populate a data validation list with the sheet names in a workbook? And as a sheet is added or sheet name changed, the list automatically updates? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto Populate Date when specific entry is chosen from data validation | Excel Worksheet Functions | |||
How can I populate a drop down list from Data Validation? | Excel Discussion (Misc queries) | |||
Populate a Validation List | Excel Discussion (Misc queries) | |||
using selected data within a dropdown list to populate new list | Excel Programming | |||
populate a validation List? | Excel Programming |