What if you use a data validation list instead of creating comboboxes on the fly:
see attached.
the list is compiled from a named range "MyList"
What if you use a data validation list instead of creating comboboxes on the fly:
see attached.
the list is compiled from a named range "MyList"
Steve
"Nearly all men can stand adversity, but if you want to test a man's character, give him power."
-Abraham Lincoln
Posting Permissions
Reply With Quote