Hi, Click the "Go" button on a user form and this is the beginning of the code. The label will not become visible - what am I doing wrong? Label is set to visible=false when form is launched. (I have quadruple checked spelling, etc.) I tried putting label in frame and show/hide frame - frame does show/hide, but label will not show/hide in frame or out of frame. Is it not possible to do this?
Private Sub cmdbtnGo_Click()
If obOpen.Value = False And obFinal.Value = False Then
MsgBox "You must select either Open or Finalized Project Type"
Exit Sub
End If
If ob_Office.Value = False And ob_Ptnr.Value = False And ob_Mgr.Value = False And _
ob_Region.Value = False And ob_AllRegions.Value = False Then
MsgBox "You must select a viewing method"
Exit Sub
End If
'PROBLEM LABEL
lblGatheringData.Visible = True
Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual
Bookmarks