Enabling a button based on Cell entry
Generically:
If v="" then
button1.hide
button2.show
else
button1.show
button2.hide
endif
--
Gary''s Student
gsnu200705
"rowlo-efc" wrote:
Hi,
I have the following code:
If (Worksheets("Reach Enterprise Representative").Range("A4").Value =
"") Then FrmPriv.Show
This is allocated to a button that opens a userform when cell A4 is
blank.
However, I have a second button that I want to disable UNLESS cell A4
contains data.
How can I do this?
Cheers
J
|