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
