Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
"Application.DisplayStatusBar = True" = ERROR
Your code ran fine for me in XL2000. If you are using Excel 97, one
possibility is to Change the TakeFocusOnClick property of the CommandButton to false. -- Regards, Tom Ogilvy "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
Yes, yes, yes, that's right!!!
Tom, thank's for your time! Regards, Milos "Tom Ogilvy" wrote in message ... Your code ran fine for me in XL2000. If you are using Excel 97, one possibility is to Change the TakeFocusOnClick property of the CommandButton to false. -- Regards, Tom Ogilvy "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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
"Application.DisplayStatusBar = True" = ERROR
I had forgotten about that little command button focus issue as I ran into
that with one of my XL97 projects, so I selected a cell within the command button. -- Ronald R. Dodge, Jr. Production Statistician Master MOUS 2000 "Tom Ogilvy" wrote in message ... Your code ran fine for me in XL2000. If you are using Excel 97, one possibility is to Change the TakeFocusOnClick property of the CommandButton to false. -- Regards, Tom Ogilvy "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 | |||
"Application.DisplayStatusBar = True" = ERROR | Excel Programming |