Dependent three level Dropdowns in excel UserForm

[fotodj]

I am having a hard time to code three level dropdown in the excel test file I am working on:

Service Test Excel File

The goal is to use data from that Sheet "Lookup" (shown above) and have userform working properly adding the data to sheet "Staff"....

 

[Skyybot]

Use the ComboBox (I'm assuming they are ComboBoxes) "Enter" event to populate the dropdown based on value of the previous ComboBox.

 

[Peter_SSs]

Reminder: Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Dependent dropbox on excel userform
There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[fotodj]

Reminder: Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Dependent dropbox on excel userform
There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

Understood...

 

[dmt32]

Hi
You were going in right direction using tables (listobjects).
Suggest that you convert the two ranges to tables and name them appropriately which will allow you to:

- populate Service & Details comboboxes using listobject.listcolumns(column name) property to return selected columns databodyrange value.
- Populate Department combobox from service table using ListObject.HeaderowRange.value negating need for separate table.

Plumbing	Carpentry	Painting		item 1	item 2	item 3	item 4	item 5	item 6	item 7	item 8	item 9
item 1	item 4	item 7		x	a	d	g	j	m	p	s	f
item 2	item 5	item 8		y	b	e	h	k	n	q	t	g
item 3	item 6	item 9		z	c	f	j	l	o	r	u	h

Dave