Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
populating a validation list
Hi,
I have some code that populates a data validation list automatically. The list has approxiately 20 entries and the VB code will not allow me to have that many - it throws up an error message when trying to run the line. To get round this, I have simply pointed the code at a range of cells way off from where the user will be working. The problem with this is that if rows are deleted, the references become invalid, as the list of valid entries effectively "moves up" the page. Can anyone suggest another way around the limit VB is placing on the number of items in my list? TIA Dave |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
populating a validation list
Hi.
It's a bit too complex to explain here. Have a look at the file at : http://www.filedropper.com/dino_2 -- Regards. Daniel "Risky Dave" a écrit dans le message de news: ... Hi, I have some code that populates a data validation list automatically. The list has approxiately 20 entries and the VB code will not allow me to have that many - it throws up an error message when trying to run the line. To get round this, I have simply pointed the code at a range of cells way off from where the user will be working. The problem with this is that if rows are deleted, the references become invalid, as the list of valid entries effectively "moves up" the page. Can anyone suggest another way around the limit VB is placing on the number of items in my list? TIA Dave |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
populating a validation list
Sorry for wrong posting
Daniel "Risky Dave" a écrit dans le message de news: ... Hi, I have some code that populates a data validation list automatically. The list has approxiately 20 entries and the VB code will not allow me to have that many - it throws up an error message when trying to run the line. To get round this, I have simply pointed the code at a range of cells way off from where the user will be working. The problem with this is that if rows are deleted, the references become invalid, as the list of valid entries effectively "moves up" the page. Can anyone suggest another way around the limit VB is placing on the number of items in my list? TIA Dave |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
populating a validation list
If the list shouldn't change (the user is deleting the row for a different
purpose), why not just put the range on a separate sheet--and hide the sheet. If you do this, then you'll have to name that range. Debra Dalgleish explains he http://contextures.com/xlDataVal01.html#Name And if that list can grow/contract, you may be able to use a dynamic range name: http://contextures.com/xlNames01.html#Dynamic (also from Debra's site.) Risky Dave wrote: Hi, I have some code that populates a data validation list automatically. The list has approxiately 20 entries and the VB code will not allow me to have that many - it throws up an error message when trying to run the line. To get round this, I have simply pointed the code at a range of cells way off from where the user will be working. The problem with this is that if rows are deleted, the references become invalid, as the list of valid entries effectively "moves up" the page. Can anyone suggest another way around the limit VB is placing on the number of items in my list? TIA Dave -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Populating a data validation list based on criteria | Excel Discussion (Misc queries) | |||
Validation list populating multiple cells | Excel Discussion (Misc queries) | |||
Populating a Data Validation List | Excel Discussion (Misc queries) | |||
Populating a combo box from a Validation | Excel Programming | |||
Populating a Validation List with SQL | Excel Programming |