Add Text to Combo box
How do you enter the text or "options" into the combo box list? I was trying
to use the Control Toolbox for this but after reading some other posts wasn't sure if I should be using the Forms Toolbar. |
Add Text to Combo box
For Control Toolbox:
Right click on the combo box, select Properties and then put a range in the "ListFillRange" option. If your options are in Sheet2 A1 to A10, then ListFillRange=Sheet2!A1:A10 HTH "Newby07" wrote: How do you enter the text or "options" into the combo box list? I was trying to use the Control Toolbox for this but after reading some other posts wasn't sure if I should be using the Forms Toolbar. |
All times are GMT +1. The time now is 08:02 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com