show Some values in list box

[Anonymous]

hi

    I need selected values in list box

Take Example If i Take Empid it contains values like (12.13.14.15,16,17,23,34,45,65,38.32,20,76,54,22) Here in if select sheet object as

list box for Empid then it display all values but i need only have to display in when i create list box then it shows only these values like(23,54,65,38,16) but Don't change in script I need this through expression only in list box

[amit_saini]

Hi Rajesh,

Please see the attachment , hope this will help you.

Thanks,

AS

[arulsettu]

hi try this

if(match(Empid,'23','54','65','38','16'),Empid)

hope ti helps

[Anonymous]

tnx Arul it is working and one more i need how can i place these in inputbox can you please tell me how??

[arulsettu]

if you are ok with the answer plz mark it as answer it would be help full for others

create a input box then  IN title =if(match(Empid,'23','54','65','38','16'),Empid)

do like this