LinkBack URL
About LinkBacks
I'd like to create a picklist that auto updates the available items. Want to be able to just have the next number in a sequence be available to select. Could someone help me with some code for this.
I'd like to create a picklist that auto updates the available items. Want to be able to just have the next number in a sequence be available to select. Could someone help me with some code for this.
If you've created a named range (in this case Dropdown) and the dropdown that refers to that named range
the following code (a bit inelegant) will do it. You'd have to adjust the location of the drop down.
irows = Sheets("Sheet1").UsedRange.Rows.Count ActiveWorkbook.Names.Add Name:="Dropdown", RefersToR1C1:="=Sheet1!R1C1:R" & Trim(CStr(irows)) & "5C1"
If this helped, please click (*) Add Reputation
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks