Results 1 to 4 of 4

VBA User Form Label won't show

Threaded View

  1. #1
    Forum Contributor
    Join Date
    06-16-2010
    Location
    Tampa, FL
    MS-Off Ver
    Excel 2010
    Posts
    278

    VBA User Form Label won't show

    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
    Last edited by ker9; 11-29-2011 at 09:57 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1