maabadi
Well-known Member
- Joined
- Oct 22, 2012
- Messages
- 2,681
- Office Version
- 2019
- 2016
- Platform
- Windows
Dear friends
I have two combobox in one userforms. I want to show data in combobox2 based data on combobox1 and inversely(Vice versa) if it is possible.
I have data on sheet1. I can linked this comboboxes to cells (B2 for Combobox1 and C2 for Combobox2), but I don't know how to show list of data on reference column for them.
this is formulasin cell C2:
Please Help me, If it is possible for both or only for combobox2.
thanks
I have two combobox in one userforms. I want to show data in combobox2 based data on combobox1 and inversely(Vice versa) if it is possible.
I have data on sheet1. I can linked this comboboxes to cells (B2 for Combobox1 and C2 for Combobox2), but I don't know how to show list of data on reference column for them.
this is formulasin cell C2:
Code:
=IFERROR(VLOOKUP(B2,'D:\[Seed Bank (5).xlsm]SeedNames'!A:Y,2,FALSE),"")Please Help me, If it is possible for both or only for combobox2.
thanks
Last edited:
