TWISTEDWHISPER From Sweden, joined Aug 2003, 711 posts, RR: 2 Posted (8 years 9 months 3 weeks 20 hours ago) and read 1665 times:
Here's one for those of you that consider yourselves to be advanced Word users.
I have a form that I need to fill out like 10-15 times per day. In this form there are 6 different fields that I need to put following information in (example text within the brackets:
Master AWB# (117-40503033)
Exit Gateway (CPH)
Special Instructions (KEEP COLD ON ARRIVAL)
Today I use a function where you press F11 to move the marker to the next field, but what I want is a dialogue box with a brief explanation of what needs to be filled in and in what format, i.e. "Please enter the estimated time of arrival in following format: HHMM/DD" and a text box where you enter the data requested and press OK. The text is then transferred to the appropriate box and the next dialogue box comes up, i.e. "Enter flight and date in following format: XX000/DD where XX is carrier code, 000 is flight No and DD is the flight date"
Is there a way to do this without using macros? Does anyone have a ready code example to send me? You can send it to email@example.com, put airliners.net in the subject....
SpinalTap From New Zealand, joined Mar 2005, 440 posts, RR: 0
Reply 5, posted (8 years 9 months 3 weeks 7 hours ago) and read 1528 times:
A simple but not particularly elegant way would be to use Excel and Insert comments in the cells where data is to be entered. Comments can be entered by right clicking on a cell then selecting "Insert comment" from the menu. The comments will then appear when you run the mouse cursor over the cell.
Otherwise its VBA I'm afraid. It can be done very easily if you have a basic knowledge of VBA or another modern programming language but if you are completely unfamiliar with any programming language it may seem difficult.
"I get what they call a stipend, a stipend is like money but its such as small amount they don't really call it money"