Re: Macro that generates a prompt box(?) that once selected insert



Hi Doug - I have worked my way through
http://word.mvps.org/FAQs/Userforms/CreateAUserForm.htm
and the steps all made a lot of sense (thanks).

When I tested it, however, I got the following prompt error: "Compile error:
Method or data member not found" and when I cick 'ok' Private Sub
CommandButton1_Click() is highlighted in yellow and the cursor is at the word
'Range' .Bookmarks("Text1").Range_

What have I done wrong?


"Doug Robbins - Word MVP" wrote:

You have a little bit of learning to do.

See the article "How to create a Userform" at:

http://word.mvps.org/FAQs/Userforms/CreateAUserForm.htm

and then the following page of fellow MVP Greg Maxey's website

http://gregmaxey.mvps.org/Populate_UserForm_ListBox.htm


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"MIrving" <MIrving@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:58A2A986-9A7A-45CF-8A1E-D803F5DD1D98@xxxxxxxxxxxxxxxx
I would be sincerely grateful for any assistance with the following. I have
limited macro recording experience and no experience with Visual Basic,
but
would like to know if (with my lack of experience) the following is
something
I could achieve. I am extremely keen to try and learn.

I would like to set up a macro that runs when a toolbar button is clicked
that achieves the following:
1. A prompt box (?) comes up in the style of a form.
2. The form has a pull-down list of four cities.
3. Depending on which city is selected, a list of companies appears
underneath.
4. Next to each company is a button or box that can be selected.
5. Once the user selects the companies they want, the user clicks on a
button at the end of the prompt box that says 'Insert'.
6. The selected companies are then inserted into a table in the Word
document.

I know it is a big ask, but if anyone would be kind enough to step me
through how I could go about this, I would be extremely grateful.



.