Combo box

[mayur_m3]

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]

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]

Thks & rgds,
mayur