Archive of Mr Excel Message Board

Back to Controls in Excel archive index
Back to archive home

Combo boxes

Posted by Jay on July 17, 2001 6:55 AM

Anyone know the property of a combo box for the cell link field when using VBA? I have found the DropDownLines, but cannot find the Cell Link

[Drop Down 292].DropDownLines

Re: Combo boxes

Posted by Cory on July 17, 2001 9:09 AM

The RowSource property links cells to a combobox. Is that what you're looking for?

You can also add items to a combobox like this:

Private Sub UserForm1_Initialize()
Combobox1.AddItem "your data"
Combobox1.AddItem "2nd item"

etc...

Any Help?

Cory

Re: Combo boxes

Posted by Jay on July 18, 2001 12:03 AM

No, not much help.

What I want to do is change the Cell link from VBA code. I know the name of the combo box so I can refer to it, but I don't know the property name for the Cell Link field. I tried all the obvious ones but no luck.

Jay

Re: Combo boxes

Posted by Jay on July 18, 2001 1:51 AM

Found it.

[Drop Down 292].LinkedCell
also useful is
[Drop Down 292].ListFillRange

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.