Question Related To Listbox

[Anil2007]

Hi

I need help that is that possible if i select the any value in list box on one sheet tab the same will be auto select in list box on all sheet tab i have attach the sample file like if i select the 1 in listbox on sheet tab " sheet2" the same value will auto select in the list box on sheet2

[PetrH]

Hi,
why don't you use simple formula?
Write to cell C1 on Sheet3 following:

=Sheet2!C1

I think you have some reason not to use it, but...
Regards
Petr

[Anil2007]

Hi,
why don't you use simple formula?
Write to cell C1 on Sheet3 following:

=Sheet2!C1

I think you have some reason not to use it, but...
Regards
Petr

Yes you are correct but this not possible in list box , wat i mean is that if we have a 3 sheet tab all having the list box having " 1 ,2 ,3 " option for user to select. wat i want is that if a user select the '" 1 " in listbox on one sheet tab , thn automaticaly all other listbox on other sheet tab will set to "1" from the option which whic are in the list box

[Anil2007]

Yes you are correct but this not possible in list box , wat i mean is that if we have a 3 sheet tab all having the list box having " 1 ,2 ,3 " option for user to select. wat i want is that if a user select the '" 1 " in listbox on one sheet tab , thn automaticaly all other listbox on other sheet tab will set to "1" from the option which whic are in the list box

[Andy Pope]

You can use event code to set the other sheets

code added to the Sheet object, (right click sheet tab and press view code)

Please Login or Register  to view this content.