Combo Box enable and disable

[Vinod]

Hi all,

I wanted to enable or disable a Form combo box in my worksheet with the help
of a boolean value (0 or 1). So, is it possible to do like this with excel
functions (without VBA Macro).

Please give me solution if anybody knows.

Regards
Vinod

 

[T. Valko]

Assume the source for the combo box is a named range called MyList.

Cell A1 will contain either a 1 or 0. This can be generated by a formula.

Create this named formula:

Goto the menu Insert>Name>Define
Name: List
Refers to: =IF(Sheet1!$A$1,MyList)
OK

As the source for the combo box enter List.

 

[Vinod]

Its fine, But my requirement is not to allow the user to click on combo box.
I mean to say disalbe is, like how we are unable to select past option
without selecting copy option prior to it, this case past option is in
disabled state.

Once again my requirement is Combo box should be in disabled state based on
a boolean value (0 or 1)

 

[Peo Sjoblom]

Not possible

--


Regards,


Peo Sjoblom

Its fine, But my requirement is not to allow the user to click on combo
box.
I mean to say disalbe is, like how we are unable to select past option
without selecting copy option prior to it, this case past option is in
disabled state.

Once again my requirement is Combo box should be in disabled state based
on
a boolean value (0 or 1)