List for for same dropdown
Hi,
I have 1 combo box and 1 list box, the list box should populate the values for only those for which the selection done in combo box one, kindly suggest how do i do this please via VBA code in VBA form (.i.e. If i select Hyundai in combo box only Hyundai brands should appear in list box.)
welcome to the forum
Cannot multiselect in a combobox, but this is the way to transfer selected items from a multi-select listbox to another listbox
try in attached workbook
Please Login or Register to view this content.
Click *Add Reputation to thank those who helped you. Ask if anything is not clear
you could add items one at a time
open form2 in the attached workbook
Please Login or Register to view this content.
Is it possible in oher way if we use both as combo or some other box to show. th requirement is may be like a drop down that we use in excel general use. if the column C is sub brand of column B and column B is again sub brand of Column A.
Hi Kev,
If this is not possible can you write one code for me this is a user access basically based on the login multipage windows should be accessible.
if login successful then the Multipage(page 1 and page 2) in user form window should be enable else the file should be closed.
Try this by clicking on show Form3 in attached workbook
This works because Named Ranges have been set up to match the dropdown values in the previous box
Works like =INDIRECT formula with cell dependant dropdowns
Late EDITPlease Login or Register to view this content.
you could use comboboxes instead of listboxes - just amend the code to match their names
Last edited by kev_; 02-21-2017 at 08:37 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks