Hi
I have a combo box in the excel sheet filled in with some data
How do I find the source behind this?
Regards,
mayur
Hi
I have a combo box in the excel sheet filled in with some data
How do I find the source behind this?
Regards,
mayur
Hi Mayur,
It depends what sort of combo box it is!!
If it came from the Control Toolbox, then you will need to enter Design Mode (click on the triangle icon on the Control Toolbox toolbar), then right click on the combo and select Properties. In the properties box, look at the ListFillRange property.
If it came from the Forms Toolbar, just right click on the combo and select Format Control. Look at the Input Range on the Control tab.
Enjoy,
Tony
---------------------------------------------------------------
Give a man a fish and he'll eat for a day.
Teach him how to fish and he'll sit in a boat and drink beer all day.
I'm (slowly) building my own site: www.WordArticles.com
Thks & rgds,
mayur