ComboBox selected item

Hy everybody!

I have a question. I created a ComboBox(list) on sheet 1, for example with 3 elements. If I selected one element I would like to appear this selected element in sheet 2.
How can I do this?

Regards Balázs

If it's a combobox from the control toolbox toolbar, you could just assign the
linked cell to that cell on the second sheet.

Show that control toolbox toolbar
click the design mode icon
rightclick on the combobox
select properties
scroll down until you see Linkedcell
type:
'sheet 2'!a1
(or whatever you need)

Click on the design mode icon and test it out.

ballabali wrote:
>
> Hy everybody!
>
> I have a question. I created a ComboBox(list) on sheet 1, for example
> with 3 elements. If I selected one element I would like to appear this
> selected element in sheet 2.
> How can I do this?
>
> Regards Balázs
>
> --
> ballabali
> ------------------------------------------------------------------------
> ballabali's Profile: http://www.excelforum.com/member.php...o&userid=29663
> View this thread: http://www.excelforum.com/showthread...hreadid=493815

--

Dave Peterson