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?