Combo box

if i set up a combo box in worksheet 2 can i have the name a select in this
combo box put into a cell in worksheet on.

thanks for your help

Yes you can.

Worksheets("Sheet1").Range("A1") = Worksheets("Sheet2").ComboBox1.Value

should do the trick.

Mangesh




"Monty" <[email protected]> wrote in message
news:[email protected]...
> if i set up a combo box in worksheet 2 can i have the name a select in
this
> combo box put into a cell in worksheet on.
>
> thanks for your help

Thanks

this worked . however i have decided to use cell validition and transpose.

"Mangesh Yadav" wrote:

> Yes you can.
>
> Worksheets("Sheet1").Range("A1") = Worksheets("Sheet2").ComboBox1.Value
>
> should do the trick.
>
> Mangesh
>
>
>
>
> "Monty" <[email protected]> wrote in message
> news:[email protected]...
> > if i set up a combo box in worksheet 2 can i have the name a select in
> this
> > combo box put into a cell in worksheet on.
> >
> > thanks for your help
>
>
>

Thanks

this worked . however i have decided to use cell validition and transpose.

"Mangesh Yadav" wrote:

> Yes you can.
>
> Worksheets("Sheet1").Range("A1") = Worksheets("Sheet2").ComboBox1.Value
>
> should do the trick.
>
> Mangesh
>
>
>
>
> "Monty" <[email protected]> wrote in message
> news:[email protected]...
> > if i set up a combo box in worksheet 2 can i have the name a select in
> this
> > combo box put into a cell in worksheet on.
> >
> > thanks for your help
>
>
>