Archive of Mr Excel Message Board

Back to Forms in Excel VBA archive index
Back to archive home

Combo Boxs

Posted by Dan on October 11, 2001 2:49 AM

When i copy a combo box
How do i change the cell index
thanks dan

Re: Combo Boxs

Posted by Dan on October 12, 2001 6:54 AM

Do you mean changing the choices in the drop down menu? Right click on the box, click on Format Control and click on the Input Range field and select or type in the range of cells.

Hope that's what you were looking for.

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.