VBA Code For ComboBox With Indirect Options
Hi,
I just want to ask if anyone can help me solve this problem, I have 3 Boxes (ComboBox 1,2 & 3). I want to use the VBA code in the userform to perform an indirect options but I'm not sure if this is possible.
I've also attached a copy of the spreadsheet as an example.
Can some of you excel guru help me out?
Thanks
Hi
i dont know how to do it with form controls but achieved the same thing with ActiveX
the syntax for form controls is different
in VBA there is no need to indirect
ComboBox5.ListFillRange = ComboBox4.Text
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Hi humdingaling,
I've updated the spreadsheet, do you know how to put this in a Userform???
see attachment.
syntax is different but idea behind code is the same
instead of listfillrange
use rowsource
the thing that is not in the code is the combobox1 rowsource is set outside of code
see it in properties in VBAproject
Last edited by humdingaling; 07-30-2013 at 07:45 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks