Display message without OK button

S

Sheila D

Hi

I have a macro which carries out several actions and would like a way to
advise the user what is going on. Tried Msgbox command but this requires user
to click OK. Is there a way to use this so it stays on screen while macro is
running or displays say for 1 second then disappears?

Tx for any help

Sheila
 
N

Nikos Yannacopoulos

Sheila,

Instead of using a messagebox, you can use a form to display your messages
on. I usuallydo it through VB code, but it can be done with a macro. Make a
new form, called, say, frmMessage, with a single label on it, called, say,
Label0. make the label's caption whatever the first message you want to
show, and in the appropriate place in your macro use an OpenForm action to
display it. When you want the next message, use an action SetValue, with
arguments: Item: Forms![frmMessage]![Label0].[Caption], Expression: "Message
to display". Repeat as many times as required, changing the label caption.
At the end of the macro usa an action Close, object type Form, object name
frmMessage, to close the form.

HTH,
Nikos
 
S

Sheila D

Thanks very much guys, should have thought of that myself.

Sheila

Nikos Yannacopoulos said:
Sheila,

Instead of using a messagebox, you can use a form to display your messages
on. I usuallydo it through VB code, but it can be done with a macro. Make a
new form, called, say, frmMessage, with a single label on it, called, say,
Label0. make the label's caption whatever the first message you want to
show, and in the appropriate place in your macro use an OpenForm action to
display it. When you want the next message, use an action SetValue, with
arguments: Item: Forms![frmMessage]![Label0].[Caption], Expression: "Message
to display". Repeat as many times as required, changing the label caption.
At the end of the macro usa an action Close, object type Form, object name
frmMessage, to close the form.

HTH,
Nikos

Sheila D said:
Hi

I have a macro which carries out several actions and would like a way to
advise the user what is going on. Tried Msgbox command but this requires user
to click OK. Is there a way to use this so it stays on screen while macro is
running or displays say for 1 second then disappears?

Tx for any help

Sheila
Click to expand...
Click to expand...
 
Top