PDA

View Full Version : Solved: Combo box



mayur_m3
03-21-2005, 01:38 AM
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

TonyJollans
03-21-2005, 02:30 AM
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.

mayur_m3
03-21-2005, 03:22 AM
Thks & rgds,
mayur