List box problem

[sofiavba]

Hi Everyone,

I have a excel spreadsheet that has a list box. If a user has already selected a value from the list the cell then should NOT be updateable but if the user has not selected any value then he/she should be able to update the cell. I just have no idea how to get it done.


Any help will be great....

 

[SkipVought]

What have you done so far?

Please explain the functionality in detail, that you are developing.

Skip,

_{[red]Be Advised![/red] A chicken, who would drag a wagon across the road for 2 cents, is…
POULTRY in motion to PULLET for a PALTRY amount!}

 

[sofiavba]

I have currently working on a excel sheet that has 10 fields and 2 of them are list values. For example there is a list of different types of houses, condo,single-family, multifamily etc. If the user has selected "condo" from the list then the list box should not be updatable. But if the users has not selected a value the list box should allow the user to select a value. Any ideas, as this is my first time programming in VBA, I really dont have an idea how to go about it. And I need to get it done ASAP..

 

[SkipVought]

The reason for a List is to control the range of values that a user can enter.

Native Excel ALREADY HAS similar functionality that you describe for entering values in a table.

Skip,

_{[red]Be Advised![/red] A chicken, who would drag a wagon across the road for 2 cents, is…
POULTRY in motion to PULLET for a PALTRY amount!}