How to handle read only properties

[#1]

Hi all,

I have three objects in a sheet.

1.List Box

2. MultiBox

3. Cureent Selection Box

My requirement is:

1. When i select any value from list box my multi Box and Current Selection should be Read only means i will not be able to do any selection in multi box or remove the selection from current selection box.

2. There should be another way to click on multi box values so that it will make the List Box value to be read only after i select Multi Box value.

its like one by one clicking on each object and making other objets as read only.

I am confused is it possible to do it.

Please provide a solution or any method in which i can handle this scenario. It will be helpful

Regards,

Pranav

[#2]

Hi all,

Waiting for some solution.

Regards,

Pranav

[Gysbert_Wassenaar]

See attached example. I've used semi-transparant text boxes that show/hide if you click on one of them. This way only either the listbox or the multibox can be used to make selections. The text box over currentselections box is always shown so the currentselections box can't be used to change selections.

[#4]

Hi Gysbert,

Thanks for your reply.

Your suggestion is ver helpful for me to get some logic for above scenario

Regards,

Pranav