Greetings,
I have been struggling trying to figure out why the following code is not working. The code is inside the UserForm_Initialize.
"fr_Chg_Mnth_2" is the Frame I am wanting to show/hide based on the following code. If cell DC4 on sheet8 contains text I want the Frame to show. If cell DC4 on sheet8 is empty I want the Frame to hide.
Private Sub UserForm_Initialize()
If Sheet8.Range("DC4").Value <> "" Then
   Me.fr_Chg_Mnth_2.Visible = True 'this is a Frame hiding a Command Button.
Else 
   Me.fr_Chg_Mnth_2.Visible = False 'the cell contains text yet the Frame is still hiding.
End If