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

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 InsertNameDefine
Name: List
Refers to: =IF(Sheet1!$A$1,MyList)
OK

As the source for the combo box enter List.

--
Biff
Microsoft Excel MVP


"Vinod" wrote in message
...
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

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)


"T. Valko" wrote:

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 InsertNameDefine
Name: List
Refers to: =IF(Sheet1!$A$1,MyList)
OK

As the source for the combo box enter List.

--
Biff
Microsoft Excel MVP


"Vinod" wrote in message
...
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

Not possible

--


Regards,


Peo Sjoblom


"Vinod" wrote in message
...
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)


"T. Valko" wrote:

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 InsertNameDefine
Name: List
Refers to: =IF(Sheet1!$A$1,MyList)
OK

As the source for the combo box enter List.

--
Biff
Microsoft Excel MVP


"Vinod" wrote in message
...
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