Form VBA
correct me if i am wrong but you have OpenPS001F to be Visible = FALSE if
Mycell < 50???
"Mark J" wrote in message
...
cell value is less than 50, so why does the code not fire?
"William Horton" wrote:
I assume you have double checked that MyCell contains a value that is
greater
than 50...
"Mark J" wrote:
I have the following code:
Private Sub UserForm_Activate()
Me.OpenPS001.Visible = False
Me.OpenPS001F.Visible = False
MyCell = Worksheets("PS001").Range("d9")
If MyCell 50 Then
Me.OpenPS001.Visible = False
Me.OpenPS001F.Visible = True
Else
If MyCell < 50 Then
Me.OpenPS001F.Visible = False <=========== Change to True
Me.OpenPS001.Visible = True
End If
End If
End Sub
on open, OpenPS001F should appear , but does not, any ideas?
|