autoclick "ok" msgbox
Good luck.
jason wrote:
On Aug 14, 12:54 pm, Dave Peterson wrote:
You could design your own userform and show it while the process is running.
But lots easier is to use:
application.statusbar = "Gathering Data..." & now
...do more stuff
application.statusbar = "Processing data..." & now
...do more stuff
application.statusbar = false 'give it back to excel
Make sure that the statusbar is visible and that the user knows where to look.
jasonwrote:
On Aug 13, 5:37 pm, Dave Peterson wrote:
Are you writing code that displays a prompt?
Lots of those verification prompts can be avoided by:
application.displayalerts = false
'your code here
application.displayalerts = true
If this doesn't help, you may want to describe your situation in greater detail.
jasonwrote:
is this possible?
thanks!
--
Dave Peterson
Hey Dave,
I get what you're saying. Basically, i am using vba to speak with some
proprietary data gathering software.
this data takes a little while to populate, and with this, i have
realized that a msgbox dialog looped with a strcomp (if match flag=0
else flag =1) that hits a flag (ie if flag=1 exit loop) and the match
occurs when data is still being gathered.
cells(1,1)=data gather reference
do while strcomp(cells(1,1),"Gathering Data...",vbtextcompare)=0
msgbox("Gathering data please wait...")
if strcomp(cells(1,1),"Gathering Data...",vbtextcompare)<0
sendkeys "~"
end if
loop
basically, sendkeys isn't working. its more like a status msg. if i
can use a different kind of msg that is better, please let me know.
i just basically want the msgbox to come up and be a type of status
msg.
thanks!
--
Dave Peterson
hey dave,
i am using the msgbox functionality for a reason (it offers a tpye of
"break").
so with this, i just need what i asked, not a different solution.
thanks!
--
Dave Peterson
|