List box properties

[alec1982]

Hi guys,

I have a list box where I needed to give the user the ability to  select only one value which is an option available on the general tab--> "Always One Slected value"

How can I make the list box to be cleard off when the user moves to other tabs.

Note that I have a clear all trigger on the sheets but because of the One Selected Value that list box is not getting cleared off.

Anybody has an idea?

Thxs for your help

Alec,

[alec1982]

It didn't help.

Thxs,

Alec

[MayilVahanan]

hi

can you post a sample file?

[CELAMBARASAN]

Hi,

By using macro for only one selected value or none selected you can achieve this

Check the attached.

Use clear all and check it

[alec1982]

Hi, Thanks for the sample.

It is the same sample that I've got before where I am having the issues.

Best,

Badr

[CELAMBARASAN]

You can do this using alternate states if your using QV11.

Check the attached