Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 =--- |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 =--- |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 =--- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
record update VBA form | Excel Discussion (Misc queries) | |||
Form Lookup & Update Records | Excel Discussion (Misc queries) | |||
create update form | Excel Discussion (Misc queries) | |||
User Form: Cannot Update Text Box | Excel Discussion (Misc queries) | |||
using vba to update vba form | Excel Programming |