View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
BJ BJ is offline
external usenet poster
 
Posts: 51
Default 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