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

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