Form label not showing

Discussion in 'Microsoft Excel Programming' started by Les Stout, Oct 17, 2006.

  1. Les Stout

    Les Stout Guest

    Hi all, i have a form that i am using as ainformation bar so to say to
    inform the user that the document is being processed. I am using it as
    below.... The problem i have is that the form shows fine but the label
    does not change with the command, is it the code that is wrong, If i run
    through the code with F8 it works but with F5 it does not ??


    Sub UserForm_Open()

    UserForm2.Show
    End Sub

    **** On form2 opening it calls format rows ******

    '************ Format the header row *****************
    Sub FormatRows()
    '
    Application.Cursor = xlWait
    UserForm2.Label1 = "PLEASE BE PATIENT THIS DOCUMENT IS BEING
    PROCESSED..."
    ' Application.ScreenUpdating = False
    Rows("1:19").Delete Shift:=xlUp
    With Rows("1:1")
    .Font.Bold = True
    .HorizontalAlignment = xlCenter
    .VerticalAlignment = xlCenter
    End With
    Columns("A:O").EntireColumn.AutoFit
    Range("A1").Select
    DeleteRowsIfNoUpg
    End Sub

    Les Stout

    *** Sent via Developersdex http://www.developersdex.com ***
     
    Les Stout, Oct 17, 2006
    #1
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. John Tjia

    Refresh label on user form with RefEdit

    John Tjia, Jan 6, 2004, in forum: Microsoft Excel Programming
    Replies:
    2
    Views:
    591
    John Tjia
    Jan 6, 2004
  2. TomCee

    Label, Text and Form controls in Excel 97

    TomCee, Apr 20, 2004, in forum: Microsoft Excel Programming
    Replies:
    1
    Views:
    260
    Bernie Deitrick
    Apr 20, 2004
  3. Stuart

    Disable Label in a Form

    Stuart, Mar 13, 2005, in forum: Microsoft Excel Programming
    Replies:
    4
    Views:
    199
    Stuart
    Mar 13, 2005
  4. Pulling Info From Cell To Form Label

    , Apr 17, 2006, in forum: Microsoft Excel Programming
    Replies:
    2
    Views:
    134
  5. Gimp

    Label on User Form visible

    Gimp, Feb 14, 2007, in forum: Microsoft Excel Programming
    Replies:
    3
    Views:
    190
  6. Anthony Berglas

    Multiple fonts in a VBA UserForm label (to make XL 95 form non-modal)

    Anthony Berglas, Aug 12, 2007, in forum: Microsoft Excel Programming
    Replies:
    2
    Views:
    657
    Anthony Berglas
    Aug 13, 2007
  7. noord453

    dynamic size of label, and depending on size label position of tex

    noord453, May 12, 2009, in forum: Microsoft Excel Programming
    Replies:
    3
    Views:
    528
    Jacob Skaria
    May 12, 2009
  8. Robert Crandal

    Set Userform label text if form is not loaded???

    Robert Crandal, Dec 19, 2009, in forum: Microsoft Excel Programming
    Replies:
    3
    Views:
    240
    Ryan H
    Dec 21, 2009
Loading...