Combo Boxes

N

Nigel Bennett

I have a combo box called city populated with a list of
cities, when I select a city I want to populate cell B2 on
sheet 2 with the value in the combo boxes, I presume it
would go in the after update of the combo box but what is
the syntax
 
V

Vasant Nanavati

You don't say whether the combo box is on a userform or a worksheet or, if
the latter, it is from the Forms toolbar or the Control Toolbox.

Assuming a Control Toolbox control on a worksheet (Sheet1):

Sheet2.Range("B2") = Sheet1.ComboBox1
 
G

Guest

if it just a worksheet i use the cell link reference and
in cell b2=choose(cell link,city one,city two,city
three,.....)
 
N

Nigel Bennett

Using the syntax Brand.Range("B1") = Brand.colist

I get an error message as follows

Run Time Error 424
Object Required

Thanks

Nigel



*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!
 
N

Nigel Bennett

It is the name of the sheet but I solved the issue, you can enter the
linked cell on the combo box properties

Thanks
Nigel Bennett

*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!
 
Top