| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Form/Label Won't Show
Ran into an odd thing just now. I set up a simple form in Excel that is
shown when a VBA procedure is running, then hidden when it ends (just tells the user something is going on so he doesn't get bored or frustrated and start pushing buttons). The form opens and closes like it's supposed to, but the label containing the text of my message is blank, just a white square. I've looked through all the properties and can't see anything that would explain it. Anybody have an idea? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel Form/Label Won't Show
Can you post the code in question? It might help shed some light "LarryP" wrote: Ran into an odd thing just now. I set up a simple form in Excel that is shown when a VBA procedure is running, then hidden when it ends (just tells the user something is going on so he doesn't get bored or frustrated and start pushing buttons). The form opens and closes like it's supposed to, but the label containing the text of my message is blank, just a white square. I've looked through all the properties and can't see anything that would explain it. Anybody have an idea? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel Form/Label Won't Show
The code is simply ...
PricingMessage.Show 'Do some stuff 'PricingMessage.Hide 'PricingMessage' is of course the name of the form, and the 'do some stuff' is a called procedure that runs for about a minute +/- . As I said, the form opens just fine, and closes just fine, the only problem is that the label looks like it doesn't have any text in it. The form still serves the purpose because its caption also tells the user to stand by, but my label, if it would show, tells them a little more about what's going on. I can see it just fine in design view, but not when the form actually opens. "Sam Wilson" wrote: Can you post the code in question? It might help shed some light "LarryP" wrote: Ran into an odd thing just now. I set up a simple form in Excel that is shown when a VBA procedure is running, then hidden when it ends (just tells the user something is going on so he doesn't get bored or frustrated and start pushing buttons). The form opens and closes like it's supposed to, but the label containing the text of my message is blank, just a white square. I've looked through all the properties and can't see anything that would explain it. Anybody have an idea? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel Form/Label Won't Show
With your model form I'm surprised you are able to run 'Do some stuff' until
after dismissing the form, perhaps you are showing vbModeless or there's more to it. Anyway, you may need to do either PricingMessage.Repaint or drop in a DoEvents. The latter would allow user to press any buttons with possible unwanted consequences. OTH if fully catered for and handled that might also give the user a potential way to abort. Regards, Peter T I'm surprised "LarryP" wrote in message ... The code is simply ... PricingMessage.Show 'Do some stuff 'PricingMessage.Hide 'PricingMessage' is of course the name of the form, and the 'do some stuff' is a called procedure that runs for about a minute +/- . As I said, the form opens just fine, and closes just fine, the only problem is that the label looks like it doesn't have any text in it. The form still serves the purpose because its caption also tells the user to stand by, but my label, if it would show, tells them a little more about what's going on. I can see it just fine in design view, but not when the form actually opens. "Sam Wilson" wrote: Can you post the code in question? It might help shed some light "LarryP" wrote: Ran into an odd thing just now. I set up a simple form in Excel that is shown when a VBA procedure is running, then hidden when it ends (just tells the user something is going on so he doesn't get bored or frustrated and start pushing buttons). The form opens and closes like it's supposed to, but the label containing the text of my message is blank, just a white square. I've looked through all the properties and can't see anything that would explain it. Anybody have an idea? |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel Form/Label Won't Show
You need to make sure the form is opened as modeless.
eg pricingmethod.show vbmodless "LarryP" wrote: The code is simply ... PricingMessage.Show 'Do some stuff 'PricingMessage.Hide 'PricingMessage' is of course the name of the form, and the 'do some stuff' is a called procedure that runs for about a minute +/- . As I said, the form opens just fine, and closes just fine, the only problem is that the label looks like it doesn't have any text in it. The form still serves the purpose because its caption also tells the user to stand by, but my label, if it would show, tells them a little more about what's going on. I can see it just fine in design view, but not when the form actually opens. "Sam Wilson" wrote: Can you post the code in question? It might help shed some light "LarryP" wrote: Ran into an odd thing just now. I set up a simple form in Excel that is shown when a VBA procedure is running, then hidden when it ends (just tells the user something is going on so he doesn't get bored or frustrated and start pushing buttons). The form opens and closes like it's supposed to, but the label containing the text of my message is blank, just a white square. I've looked through all the properties and can't see anything that would explain it. Anybody have an idea? |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel Form/Label Won't Show
try this:
UserForm1.Label1.Caption = "Summarizing Data" DoEvents -- Gary "LarryP" wrote in message ... Ran into an odd thing just now. I set up a simple form in Excel that is shown when a VBA procedure is running, then hidden when it ends (just tells the user something is going on so he doesn't get bored or frustrated and start pushing buttons). The form opens and closes like it's supposed to, but the label containing the text of my message is blank, just a white square. I've looked through all the properties and can't see anything that would explain it. Anybody have an idea? |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel Form/Label Won't Show
I had set my form to modeless, but I added a .Repaint after the .Open and a
DoEvents after both the .Repaint and the 'Do some stuff. Fixed the problem; thanks to all. "Peter T" wrote: With your model form I'm surprised you are able to run 'Do some stuff' until after dismissing the form, perhaps you are showing vbModeless or there's more to it. Anyway, you may need to do either PricingMessage.Repaint or drop in a DoEvents. The latter would allow user to press any buttons with possible unwanted consequences. OTH if fully catered for and handled that might also give the user a potential way to abort. Regards, Peter T I'm surprised "LarryP" wrote in message ... The code is simply ... PricingMessage.Show 'Do some stuff 'PricingMessage.Hide 'PricingMessage' is of course the name of the form, and the 'do some stuff' is a called procedure that runs for about a minute +/- . As I said, the form opens just fine, and closes just fine, the only problem is that the label looks like it doesn't have any text in it. The form still serves the purpose because its caption also tells the user to stand by, but my label, if it would show, tells them a little more about what's going on. I can see it just fine in design view, but not when the form actually opens. "Sam Wilson" wrote: Can you post the code in question? It might help shed some light "LarryP" wrote: Ran into an odd thing just now. I set up a simple form in Excel that is shown when a VBA procedure is running, then hidden when it ends (just tells the user something is going on so he doesn't get bored or frustrated and start pushing buttons). The form opens and closes like it's supposed to, but the label containing the text of my message is blank, just a white square. I've looked through all the properties and can't see anything that would explain it. Anybody have an idea? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do i make the whole y axis label show up it wont show the end | Charts and Charting in Excel | |||
| Can I re-number Excel Form Label Controls for orderly tabbing. | Excel Worksheet Functions | |||
| COPY LABEL FORM FROM EXCEL TO A LABEL | New Users to Excel | |||
| How do I take excel data and convert to label/envelope form? | Excel Worksheet Functions | |||
| Label, Text and Form controls in Excel 97 | Excel Programming | |||
Linear Mode
