Add RowSource to Userform ComboBox based on value on Another ComboBox

**Baziwan** · 10-10-2012, 10:48 AM

Hi,

Exactly as it says in the title. Can I add the RowSource of a ComboBox based on the Value of another ComboBox.

Example

Please Login or Register  to view this content.

This doesn't work but does anyone have any idea what might.

Thanks in Advance

**DBY** · 10-10-2012, 12:14 PM

Hello
Not sure why your code isn't working. How are you initializing it? The following code works for me on the CombBox1 Change Event:

Please Login or Register  to view this content.

Hope this helps.
DBY

**Baziwan** · 10-10-2012, 01:05 PM

Hi,

I just realised why my code wasn't working. The values I had in ComboBox1 contained spaces and of course the RowSource can't have spaces to work as they're named ranges. Doh!!
I Do have a related query tho. I'm unable to enter text in ComboBox2. ComboBox1 I can enter a few letters and it autofills to the nearest match in the RowSource but with the above code I'm unable to enter text in ComboBox2. Any ideas why?

**Baziwan** · 10-10-2012, 01:17 PM

Never mind that query. I'd shifted the code into combobox2 when I was playing with it. As soon as I placed it back into combobox1 change event it solved the not being able to type issue.