Dependent Dropdown UserForm

GeneBF

New Member
Joined
Jun 28, 2022
Messages
31
Office Version
  1. 365
Platform
  1. Windows
Hi this forum helped me greatly with some VBA as Im starting to learn VBA recently, needing some help again

I need a code for a button that will have a Pop-up userform with Dependent dropdownlist little hard to explain i have a sample spreadsheet but i dont know if its allowed to be linked.
but here's the concept

User Form - Part A = Main Header of Drop downs, Part B = Dependent dropdown based on A
the dropdown on A is dynamic - and a choice can only be used once, once its used its not included in the list anymore

Part C needs to be on a separate box with the same drop down choice as A , means all the selected choices in A will not appear in List C

1657899161284.png


Selected choices is reflected then to a newly generated sheet, that'll look like this
1st row of table reflects selection based on userform part A
2nd row of table reflects selection based on userform part B

and below reflects the selection on part C, beside it is the transposed list of the that range

1657899026218.png
 

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

Forum statistics

Threads
1,176,123
Messages
5,901,515
Members
434,899
Latest member
powerappsjoker99

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
Top