Archive of Mr Excel Message Board
Back to Controls in Excel archive index
Back to archive home
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
Re: Combo Boxes
Posted by Jerid on October 23, 2001 4:45 AM
Re: Combo Boxes
Posted by DTUFFERY on October 23, 2001 7:22 AM
Re: Combo Boxes
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
Re: Combo Boxes
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
This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our
online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.