Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Form label not showing
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
showing start of each month as tick mark & label on X-Y chart | Charts and Charting in Excel | |||
Concatenate to form a label | Excel Discussion (Misc queries) | |||
Showing Percentage Value Data Label in a 100% Stacked Column Chart | Charts and Charting in Excel | |||
X Axis only showing label from a range | Charts and Charting in Excel | |||
COPY LABEL FORM FROM EXCEL TO A LABEL | New Users to Excel |