Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
"Application.DisplayStatusBar = True" = ERROR
Yes, i was declered:
Private Sub CommandButton1_Click() ' Dim i As Long Dim oldStatusBar As String oldStatusBar = Application.DisplayStatusBar Application.DisplayStatusBar = True 'here program execution stoped!!! Application.StatusBar = "Please be patient..." For i = 1 To 10000 ' Next i Application.StatusBar = False Application.DisplayStatusBar = oldStatusBar End Sub "Ronald Dodge" wrote in message ... Did you declare your variable as a String variable? The StatusBar property on the Application is in String Data Type. If the Statusbar is = "FALSE" then Excel has control of the statusbar. -- Ronald R. Dodge, Jr. Production Statistician Master MOUS 2000 "M." wrote in message ... I was put command button on sheet and wrote following code: Private Sub CommandButton1_Click() ' Dim i As Long Application.StatusBar = False oldStatusBar = Application.DisplayStatusBar Application.DisplayStatusBar = True '*** my program stoped her For i = 1 To 10000 ' Application.StatusBar = CStr(i) & "of" & "10000" Next i Application.StatusBar = False Application.DisplayStatusBar = oldStatusBar End Sub Where did i make mistake? I was copied code from online help about displaying status bar msg! Regards Milos |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
"Application.DisplayStatusBar = True" = ERROR
I'm using Excel 97!
Regards, Milos "M." wrote in message ... Yes, i was declered: Private Sub CommandButton1_Click() ' Dim i As Long Dim oldStatusBar As String oldStatusBar = Application.DisplayStatusBar Application.DisplayStatusBar = True 'here program execution stoped!!! Application.StatusBar = "Please be patient..." For i = 1 To 10000 ' Next i Application.StatusBar = False Application.DisplayStatusBar = oldStatusBar End Sub "Ronald Dodge" wrote in message ... Did you declare your variable as a String variable? The StatusBar property on the Application is in String Data Type. If the Statusbar is = "FALSE" then Excel has control of the statusbar. -- Ronald R. Dodge, Jr. Production Statistician Master MOUS 2000 "M." wrote in message ... I was put command button on sheet and wrote following code: Private Sub CommandButton1_Click() ' Dim i As Long Application.StatusBar = False oldStatusBar = Application.DisplayStatusBar Application.DisplayStatusBar = True '*** my program stoped her For i = 1 To 10000 ' Application.StatusBar = CStr(i) & "of" & "10000" Next i Application.StatusBar = False Application.DisplayStatusBar = oldStatusBar End Sub Where did i make mistake? I was copied code from online help about displaying status bar msg! Regards Milos |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
Typing "true" excel 2007 change it to "TRUE" | Excel Discussion (Misc queries) | |||
Error when create chartobject on line ".HasTitle = True" | Charts and Charting in Excel | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
error with setting "Items.Visible = True" | Excel Programming |