Command Button Dependent on Cell/Range Value
 

Hello

I'm trying to make invisible a command button based on the result of a cell
- in this case it is also a range.

I've taken a few runs at it but I'm not having any success getting it to
work. No error messages, but nothing happens either.

Basically have CommandButton1 and CommandButton2. If the value of Range
"Answer" is 'Item A' then I'd like CommandButton1 to appear visible and
function while CommandButton2 is invisible and/or not functional. If the
value of Range "Answer" is 'Item B' then I'd like CommandButton2 to appear
visible and function while CommandButton1 is invisible and/or not functional.

Thanks.

BJ

Command Button Dependent on Cell/Range Value
 

It would help if you identified the source of your command buttons (i.e.
Forms toolbar or Control Toolbox) and if you would post the code you are
attempting that does not work.

"BJ" wrote:

Hello

I'm trying to make invisible a command button based on the result of a cell
- in this case it is also a range.

I've taken a few runs at it but I'm not having any success getting it to
work. No error messages, but nothing happens either.

Basically have CommandButton1 and CommandButton2. If the value of Range
"Answer" is 'Item A' then I'd like CommandButton1 to appear visible and
function while CommandButton2 is invisible and/or not functional. If the
value of Range "Answer" is 'Item B' then I'd like CommandButton2 to appear
visible and function while CommandButton1 is invisible and/or not functional.

Thanks.

BJ