ComboBox selected item

B

ballabali

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
 
D

Dave Peterson

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.
 
Top