Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA - Form Text box value
I have a workbook with one form, at the bottom of the form
is a text box (txtStatus) which I would like to display a status message. I show the form and the user selects some options and clicks a button to process. In the click event of the button, I set the txtStatus.value = "Processing...". But, it doesn't immediately update the form, the next time I show the form it is there. I need to have the form that is currently being displayed have this text box updated immediately, is this possible? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA - Form Text box value
The command - DoEvents - may be what your looking for it updates userforms such as progress bars from within macros.
Just place the DoEvents statement after your statement setting the txt box's value hope this helps |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
text in a PDF form | Excel Discussion (Misc queries) | |||
2 criteria lookup of text. Return text form column 3. SUMPRODUCT t | Excel Worksheet Functions | |||
Inserting text into a PDF form? | Excel Discussion (Misc queries) | |||
DATE IN TEXT FORM - NEED TO CHANGE IT DATE FORM | New Users to Excel | |||
text box on a form | Excel Programming |