Hi,
I am new to the forum here and a beginner to VBA as well. I ran into some difficulties with combining VBA and Combobox:
Basically I am trying to make a Combobox(2) dependent on the result of another Combobox (1).
My logic is:
1) using combobox 1 value to look up a range name
2) set the range name as RowSource for Combobox 2
Code is:
Excel keeps giving me "Type Mismatch Error 13". I try to Dim nameSubCategory as both "String" and "Variant" but neither works.Please Login or Register to view this content.
Could anyone help?
Thank you very much.
AC
Bookmarks