Form Update before ProcRuns
 

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 =---

Form Update before ProcRuns
 

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
=---

Thanks Tom
 

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

"Tom Ogilvy" wrote in message
...
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
=---






----== 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 =---