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

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

--

Vasant


"Nigel Bennett" wrote in message
...
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

if it just a worksheet i use the cell link reference and
in cell b2=choose(cell link,city one,city two,city
three,.....)
-----Original Message-----
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

--

Vasant


"Nigel Bennett" wrote in message
...
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


.

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!

What is "Brand"?

--

Vasant

"Nigel Bennett" wrote in message
...
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!

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!