LinkBack URL
About LinkBacks
Ok what im after is once ive named ranges in my table i want them in a certain order in my range drop down box is this possible.
Ok what im after is once ive named ranges in my table i want them in a certain order in my range drop down box is this possible.
Pretty sure it will always sort alphanumerically and you can't change that.
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
Hi,
By 'range drop down' I assume you mean that you have a Data Validation which uses the range name.
You'll need to first sort them in the order you want if you want the drop down reflect your order.
HTH
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.
I think he's talking about the "name box" which as Domski stated is set to alphabetical. If you are talking about a data validation box, VBA can be used to rearraign them when new ranges are added to the list.
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Yes its the name box i wanted sort, as it references months i wanted the months in order.
You could name then 1_January, 2_February etc?
Dom
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks