Hello everyone
I'm trying to create a data validation list .. I have two sheets (Data) and (Result)
My data is in Sheets("Data") in range("A1:D50") .. I selected that range and put the cursor in name box and named it (MyData)
Then went to sheets("Result") and selected a cell to create a validation list in it but I encountered an error
(The list source must be delimited list ,or a reference to a single row or column)
Thanks advanced
Hi,
As the message said, the list must be a single row or column. Your list is 4 columns.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Hi, Yassir,
you got the answer with the error: restrict the list to one column or row only if you are working with a named range (you may concatenate the contents in one column or add all values one under the other).
Ciao,
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
I just followed your steps and it worked fine.
1. highlight a range
2. give it a range name
3. on a 2nd sheet, DV/List/=MyData
edit: thanks guys, I missed the multiple columns
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
thanks everybody
Is there a way to concatenate the values in the range and stored it in an array rather than a helper column and use this array to create the validation list
As mentioned, DV takes a single-column range. Can you put the other columns of data (B:D) underneath what you have in A?
Hi, Yassir,
do you mind to elaborate why you think the Range for DV should be a matrix instead of a single column/row? Maybe you would need a different control but thatīs hard to judge without further information or a workbook.
Ciao,
Holger
Hi everyone
As a matter of fact the data is not in one column. they are in different columns and I want to concatenate all the data (note I can use one helper column to do that) but I don't like using helper columns .. So I want to store my data in memory using matrix and by running a macro to set my data validation list with my data.
I hope it is clear now
If you use anything other than a range, you are limited to about 255 characters for the list - will that be enough? If so, you'll have to create the list string in code and assign it at the relevant point (eg when the cell or worksheet is activated). Using a helper column will be much easier.
Remember what the dormouse said
Feed your head
So I have to surrender till that point.Originally Posted by romperstomper
May be a nother idea is to create a helper column by code and use it then delete the column .. Is that a good idea or my list will be restricted to 255 characters too?
If you delete the column your list will stop working.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks