PC Review


Reply
Thread Tools Rate Thread

Form label not showing

 
 
Les Stout
Guest
Posts: n/a
 
      17th Oct 2006
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 ***
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Re: Form label showing extra character at end of label Tom van Stiphout Microsoft Access Forms 0 28th Apr 2010 03:29 PM
COPY LABEL FORM FROM EXCEL TO A LABEL =?Utf-8?B?eHJheUFuZGk=?= Microsoft Excel New Users 1 5th Mar 2006 03:21 PM
Dim lbl( ) As Label = New Label( ){...} vs Dim lbl( ) As Label = {...} Ron Microsoft VB .NET 2 12th Nov 2004 11:35 PM
Repost: label not showing up in form when calling form from other form using .Show() Steve Sargent Microsoft Dot NET Framework Forms 4 5th Mar 2004 02:46 PM
Label not showing up on gui form called from within load handler of other form gs_sarge@yahoo.com Microsoft Dot NET Framework Forms 1 11th Feb 2004 08:01 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 04:49 PM.