hi, everyone!
I'm new to excel vba and I just need help.
2 combobox are in a userform1
possible rowsource:
sheet1 for food lets say all is in row A
Sheet2 for drinks
Combobox1 as 2 choices e.g. food, drinks
IF food is selected then rowsource from sheet1 will auto populate
IF drinks is selected then rowsource from sheet2 will auto populate
I'm not really sure on how to do this.
I don't even have a sample code or something.
I really hope someone can help me out. I would really appreciate it.
Tiem to start learning
Maybe this link will help you on the way
http://www.excel-easy.com/vba/exampl...mbo-boxes.html
---
Hans
"IT" Always crosses your path!
May the (vba) code be with you... if it isn't; start debugging!
If you like my answer, Click the * below to say thank-you
If you can provide an example file with your food & drink lists in it, it will make things a lot easier to explain.
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.
You can checkout the solution here:
https://www.excelforum.com/excel-pro...ml#post4588867
HTH,
Maud
Perhaps this - untested
Please Login or Register to view this content.
Good Luck
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the star to left of post [Add Reputation]
Also....add a comment if you like!!!!
And remember...Mark Thread as Solved.
Excel Forum Rocks!!!
... and if all this doesn't help, then it's time to attach a a sample file with what you have and what you require
Perhaps this will be more suitable:
Please Login or Register to view this content.
Hi, Everyone! I'm sorry for the very late reply. I really appreciate everyone's help!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks