macro list box

[Alan UK]

I have a macro that picks up data from Word, puts it into
an Excel spreadsheet and imports back some calculated
fields.
As part of this data transfer I want to have the macro
offer about 4 or 5 choices at the start of the process in
a list format of some kind, and include this in the data.
I don't mind whether this is a pick list or check boxes
etc, but I would prefer that they press an "OK" somewhere
along the process so that the selection is clear.
Although I can do some macro coding I am a complete
novice with the more exotic parts of Word and this might
be something to do with User Forms(?), but I can't find
enough information to decide and have NO working
knowledge of them.
We use Office 2000, by the way.
Any help would be greatly appreciated.

 

[Jay Freedman]

Hi Alan

You're correct that the thing you want is a UserForm. Here are a couple of
tutorials on how to create one:

http://www.dragondrop.com/wordcoding/word011a.asp
http://word.mvps.org/FAQs/Userforms/CreateAUserForm.htm