Dynamic Combobox List Won't show Any List (Adapt from Contextures) Help!

Linkback : http://www.mrexcel.com/forum/excel-q...ures-help.html

Hi All,

I have encounter an error (result in blank combobox list), while using dynamic data validation list, and adapt it to combobox list. it only works for only common data validation list.

the list placed on different sheet :
FORUM2.JPG

for the dynamic data validation list, I'm using formula :

Formula:

Please Login or Register  to view this content.

the combobox result an empty
FORUM3.JPG

My excel file is here :


My code is :

Please Login or Register  to view this content.

the link source for
combo box list :
http://www.contextures.com/xlDataVal...Combo#AddCombo

dynamic data validation list :
http://www.contextures.com/xlDataVal02.html

thanks a lot for the help,
Warm regards

Adrian

Hi whitfield,

in my excel, the combobox result empty list. how come?

Solved... Just need a simple modification on the code, no additional code at all.

whoops...

here's the code

Please Login or Register  to view this content.