ufMessage.Caption = "Loading Data, please wait......."
Doevents
Call LoadData

--
Regards,
Tom Ogilvy

"Nigel" wrote in message
...
I have a userform with a ''Load' ControlButton and a 'Message Panel'
LabelText

The load button does a lot of work to open .csv files copy data and
organise
this in the workbook. Which takes some time to complete. I have added the
'Message Panel' to give the user notice of what is happening and to wait!,
the load process is a Private procedure in the form which works fine.
But.... the message panel only gets updated After the procedure has run.
I
suspect it is something to do with form events .... but I am sure someone
knows the answer.

Secondly when the 'Load' button is pressed to excute the code, using the
click event the button stays in the depressed state (much like me at the
moment with this problem!). Can this be fixed as well?

Something like this......

ufMessage.Caption = "Loading Data, please wait......."
Call LoadData


Cheers
Nigel




----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet
News==----
http://www.newsfeed.com The #1 Newsgroup Service in the World! 100,000
Newsgroups
---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption
=---