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