MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Combo Boxes


Posted by Ian Mac on October 23, 2001 1:43 AM

All,

Does anyone know how to set a default value to a combobox that is on a worksheet. I'm using the properties ListFillRange for the range and was hoping not to use code but if I need to then so be it!

Regards

Ian Mac


Posted by Jerid on October 23, 2001 4:45 AM

Use the Value property.

Posted by DTUFFERY on October 23, 2001 7:22 AM

Posted by DTUFFERY on October 23, 2001 7:23 AM

use data validation, and select list from options, highlighting range on sheet.this will give youa dropdown with out code.

regards

daniel

Posted by Ian Mac on October 23, 2001 3:03 PM

I'll answer the answer above this at the same time,
I would like to use a combo box and link it to a cell because you can format it nicely on the page (mines blue) and it's better that the user can see the arror down...!

Jerid, if I set the VALUE to something the next time someone uses the form it will be that value (it changes with each save)

any further suggestions?

Ian Mac