Hello i have some code to validate a combobox in excel. But instead of listing all the options, could i point it to a named range and check if it matches any of those. Then if i update the Named range i wouldn't need to update the code?
The named range is called PaymentMethodTable that lists all those methods.
Please Login or Register to view this content.
thank you for any help given
Hi Ultimateneo,
Yep, you can do that. See my example where I've created a Dynamic Named Range of cells in column A. Then the userform's ComboBox's RowSource property uses that DNR. See the attached to see it all work. Add a few names and then click on the Button 2 again.
I hope my example is close to what you want..
ComboBox on Userform from DNR range.xlsm
To get to your full answer you might need to read:
https://stackoverflow.com/questions/...-does-not-work
Last edited by MarvinP; 06-15-2019 at 01:12 AM.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Maybe something like this.
Please Login or Register to view this content.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
Thank you I will try the solutions out on Monday
Hello i tried your code but it just seems to bypass it. i have attached the full code for validation. How to get your code to run in the elseif ?
Please Login or Register to view this content.
Try this.
Please Login or Register to view this content.
Thanks will try, sadly the computers haven't been working so very limited time on them. Hopefully fixed tomorrow. Bad weather
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks