Apparently Empty Cell--with formula inside
 

Hi,
I am trying to make a command button become visible if a certain
'reference cell' has a value in it. But, the problem is there's a
formula in the cell
being referenced.

i can't get these to work. that is, to not appear if there is no
value from
the formula in the cell.

If Range("A1").Value 0 Then Sheets(1).cmdHIDE.Visible = True
or
If Range("A1").Value = "" Then Sheets(1).cmdHIDE.Visible = false

Thanks for any help,

SF

Apparently Empty Cell--with formula inside
 

Hi
can you post your formula. It may return the result " " (a space). If
this is true change the return to "" ('empty' cell)

--
Regards
Frank Kabel
Frankfurt, Germany

foamfollower wrote:
Hi,
I am trying to make a command button become visible if a certain
'reference cell' has a value in it. But, the problem is there's a
formula in the cell
being referenced.

i can't get these to work. that is, to not appear if there is no
value from
the formula in the cell.

If Range("A1").Value 0 Then Sheets(1).cmdHIDE.Visible = True
or
If Range("A1").Value = "" Then Sheets(1).cmdHIDE.Visible = false

Thanks for any help,

SF