Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Print from Command Button Range | Excel Discussion (Misc queries) | |||
Print range & Command Button | Excel Programming | |||
Multi select dependent on cell in range | Excel Programming | |||
command button that puts specific numbers in a range of cells | Excel Programming |