A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Word » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Creating message boxes



 
 
Thread Tools Display Modes
  #1  
Old June 17th, 2004, 03:57 PM
WrightAM
external usenet poster
 
Posts: n/a
Default Creating message boxes

I've just created a set of documents that will eventually be used by a company as their default templates. Ideally I want to create some 'pop-up' message boxes to instruct the users on what text to insert in certain cells of tables when they click on the cell. It would be perfect if the message could appear automatically when they select a cell and after they click 'ok' they can continue.

I remember creating a similar message alert in my ICT A Level but it was in Access and I can't find anything similar in any of the Office programs.

Is there any way this is possible in Word 2003?
Cheers, Anne.
  #2  
Old June 17th, 2004, 05:44 PM
Greg
external usenet poster
 
Posts: n/a
Default Creating message boxes

If you are using proteced documents as a form, you could
run on entry macros for each text field.

E.g.,

Sub Inst1()
MsgBox "Put your name in this field"
End Sub

If you don't want to use a protected form, I suppose that
you could use the same macros and fire it with a
macrobutton field in the cell. Users would have to know
to doubleclick the prompt to fire the macro


E.g.,


{MACROBUTTON Inst1 * }

If the instruction was short you could just use the a
shallow Macrobutton field as a place marker for the prompt.

e.g., {MacroButton NoMacro "Type name here" }
-----Original Message-----
I've just created a set of documents that will eventually

be used by a company as their default templates. Ideally
I want to create some 'pop-up' message boxes to instruct
the users on what text to insert in certain cells of
tables when they click on the cell. It would be perfect
if the message could appear automatically when they select
a cell and after they click 'ok' they can continue.

I remember creating a similar message alert in my ICT A

Level but it was in Access and I can't find anything
similar in any of the Office programs.

Is there any way this is possible in Word 2003?
Cheers, Anne.
.

  #3  
Old June 17th, 2004, 09:25 PM
Charles Kenyon
external usenet poster
 
Posts: n/a
Default Creating message boxes

What Greg is talking about is what Word calls an "online form." Check this
in help. For more about online forms, follow the links at
http://addbalance.com/word/wordwebresources.htm#Forms or
http://word.mvps.org/FAQs/Customizat...nTheBlanks.htm especially Dian
Chapman's series of articles.

Otherwise, consider using a custom dialog box to gather your information.
This is called a userform and there is a great FAQ on them at the MVP FAQ
site.

Hope this helps,
--

Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide

See also the MVP FAQ: http://www.mvps.org/word which is awesome!
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.
"Greg" wrote in message
...
If you are using proteced documents as a form, you could
run on entry macros for each text field.

E.g.,

Sub Inst1()
MsgBox "Put your name in this field"
End Sub

If you don't want to use a protected form, I suppose that
you could use the same macros and fire it with a
macrobutton field in the cell. Users would have to know
to doubleclick the prompt to fire the macro


E.g.,


{MACROBUTTON Inst1 * }

If the instruction was short you could just use the a
shallow Macrobutton field as a place marker for the prompt.

e.g., {MacroButton NoMacro "Type name here" }
-----Original Message-----
I've just created a set of documents that will eventually

be used by a company as their default templates. Ideally
I want to create some 'pop-up' message boxes to instruct
the users on what text to insert in certain cells of
tables when they click on the cell. It would be perfect
if the message could appear automatically when they select
a cell and after they click 'ok' they can continue.

I remember creating a similar message alert in my ICT A

Level but it was in Access and I can't find anything
similar in any of the Office programs.

Is there any way this is possible in Word 2003?
Cheers, Anne.
.



  #4  
Old June 24th, 2004, 01:53 PM
external usenet poster
 
Posts: n/a
Default Creating message boxes

Thanks for the tip, I've downloaded all of Dian's
articles to get me through! My boss doesn't want me to
use any macros whatsoever, due to bad experiences in the
past, so it looks like I'm restricted to using hidden
text in a protected form!
-----Original Message-----
What Greg is talking about is what Word calls an "online

form." Check this
in help. For more about online forms, follow the links at
http://addbalance.com/word/wordwebresources.htm#Forms or
http://word.mvps.org/FAQs/Customizat...linTheBlanks.h

tm especially Dian
Chapman's series of articles.

Otherwise, consider using a custom dialog box to gather

your information.
This is called a userform and there is a great FAQ on

them at the MVP FAQ
site.

Hope this helps,
--

Charles Kenyon

Word New User FAQ & Web Directory:

http://addbalance.com/word

Intermediate User's Guide to Microsoft Word

(supplemented version of
Microsoft's Legal Users' Guide)

http://addbalance.com/usersguide

See also the MVP FAQ: http://www.mvps.org/word which is

awesome!
--------- --------- --------- --------- --------- ------

---
This message is posted to a newsgroup. Please post

replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.
"Greg" wrote in

message
...
If you are using proteced documents as a form, you

could
run on entry macros for each text field.

E.g.,

Sub Inst1()
MsgBox "Put your name in this field"
End Sub

If you don't want to use a protected form, I suppose

that
you could use the same macros and fire it with a
macrobutton field in the cell. Users would have to

know
to doubleclick the prompt to fire the macro


E.g.,


{MACROBUTTON Inst1 * }

If the instruction was short you could just use the a
shallow Macrobutton field as a place marker for the

prompt.

e.g., {MacroButton NoMacro "Type name here" }
-----Original Message-----
I've just created a set of documents that will

eventually
be used by a company as their default templates.

Ideally
I want to create some 'pop-up' message boxes to

instruct
the users on what text to insert in certain cells of
tables when they click on the cell. It would be

perfect
if the message could appear automatically when they

select
a cell and after they click 'ok' they can continue.

I remember creating a similar message alert in my ICT

A
Level but it was in Access and I can't find anything
similar in any of the Office programs.

Is there any way this is possible in Word 2003?
Cheers, Anne.
.



.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 01:59 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.