Select available value in a list box

[#1]

Hi, I have a list box with the values (a1,a2,a3...a50). In a moment only the values (a1, a3, a5, a22, a32, a41, a49) are available. In other moment the values are (a5, a6, a34, a35, a36), etc.

I have 5 buttons with the labels: A1 - A2 - A3 - A4  and A5

If you clic in A1 button, the value 'a1' must select in the list box, BUT only if the value is available in that moment, if you clic in A4 button the value 'a4' must select in the list box, BUT only if the value is available in that moment.

I think that a macro must be used.

Thanks.

[mdmukramali]

Dear,

Find the attachment of the sample application of your requirement.

Thanks,

Mukram.

[#3]

Please look the attachchment.

If I clic in the button 'Mon', I want to select a1 in the List Box, but only if the value a1 is available in that moment, if the value a1 isn't available then don't do nothing.

If I clic in button 'Sun', I want to select in the List Box the value a7, but only if the value a7 is available in that moment, if the value a7 isn't available then don't do nothing.

Thanks.

[CELAMBARASAN]

Hi,

Try this as search string

     =if(WildMatch(Concat(FieldName,','),'*a1*')=1,'a1',Concat(FieldName,',')) for a1 selection button replace a1 as some other values as your need.

Celambarasan

[mdmukramali]

Dear,

find the attchment..

if you click on Mon Button it will select Mon from list box Day and Select a the Related Values from Id to the Mon.

Thanks,

Mukram

[#6 · Accepted solution]

Here it's the solution. I used macros. Please view the attachment.