Cobobox fill data on active worksheet

A

asyamonique

Well-known Member
Joined
Jan 29, 2008
Messages
1,280
Office Version
  1. 2013
Platform
  1. Windows
Good Day,
I have two worksheets.
Worksheet1 has 4 comboboxes
Worksheet2 has ColumnA=Departments and ColumnB=Names

How can I fill that 3 comboboxes(2-3-4) if the Combobox1 selected by department?
Thanks



Cmbobox1COLUMN-A-COLUMN-B-
Department1Department1Name1
Department2Department1Name2
Department3Department1Name3
Department1Name4
Department1Name5
Department2Name6
Department2Name7
Department2Name8
Department2Name9
Department3Name10
Department3Name11
Department3Name12
Department3Name13
Department3Name14

<tbody>
</tbody>

Note: Combobox1-2-3 will be filled with same names if combobox1 selected as department1 other comboxes will load with same names names1 to names5
 
Last edited:

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying
Sort by date Sort by votes
Hello Again,
Actually two combobox function much enough for me..
I set the combobox1 with named row source
So I need to fill combobox2 with related datas by column A and B
Many Thanks
 
Last edited:
Upvote 0
You must log in or register to reply here.

Similar threads

F
  • Solved
XLOOKUP and ignoring blanks
Replies
8
Views
525
SanjayGMusafir
SanjayGMusafir
ExcelNewbie2020
  • Solved
sort function
Replies
3
Views
310
Fluff
Fluff
ExcelNewbie2020
  • Question
filter values to a merge cells
Replies
1
Views
185
arthurbr
arthurbr
ExcelNewbie2020
  • Solved
multiple column for lookup array
Replies
6
Views
403
shinigamilight
S
Y
  • Question
How can I get 1 table's info mirrored/queried (?) onto other tables? Other tables' info columns need correlation with the first 4 columns.
Replies
0
Views
234
Yertion
Y

Forum statistics

Threads
1,216,099
Messages
6,128,823
Members
449,470
Latest member
Subhash Chand

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top