Form Update before ProcRuns

  • Thread starter Thread starter Nigel
  • Start date Start date
N

Nigel

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
 
ufMessage.Caption = "Loading Data, please wait......."
Doevents
Call LoadData

--
Regards,
Tom Ogilvy

Nigel said:
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
Click to expand...
=---
 
Tom

If only every problem was as easy to fix!!!

Thanks for the tip, I suspect there are others out there who will find this
useful

Cheers
Nigel
 
Back
Top