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. Rob Bovey

    Re: add text to label (label from forms toolbar)

    Rob Bovey, Sep 5, 2003, in forum: Microsoft Excel Programming
    Replies:
    0
    Views:
    427
    Rob Bovey
    Sep 5, 2003
  2. John Tjia

    Refresh label on user form with RefEdit

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

    Label, Text and Form controls in Excel 97

    TomCee, Apr 20, 2004, in forum: Microsoft Excel Programming
    Replies:
    1
    Views:
    247
    Bernie Deitrick
    Apr 20, 2004
  4. 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:
    441
    Jacob Skaria
    May 12, 2009
  5. Robert Crandal

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

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

Share This Page