Create drop down list within an already created macro through VBA

[Amy]

Hi there -
I have some VBA experience, but am not an expert. I need to create a drop
down form field within an alreay created macro. I'm assuming the only way to
do this, if possible, would be through VBA. Any suggestions would be much
appreciated!

 

[Greg Maxey]

Amy,

You are going to have to provide a bit more explaination here. Macros
don't have dropdown formfields.

 

[Amy]

I am able to include the drop down form field when creating the macro. I
just can't access the drop down form field option box while creating the
macro. We have one proposal template created with 8 different macros within
it depending on the type of work we are performing. Within some of the
sentences within the macros we want to include drop down options so we can
make each proposal more versatile versus setting up several more options.
Below is an example of a sentence that runs with the macro. The underlined
portion is where we would like to have a drop down selection if possible.
Pave a -course compacted average depth asphalt pavement consisting of
" of upper course on approximately sy. in the ___ area.

Thx!
--
Thanks in advance for your help!
Amy

Amy,

You are going to have to provide a bit more explaination here. Macros
don't have dropdown formfields.

 

[Amy]

I am able to setup the drop down form field when creating the macro. I just
am not able to access the drop down form field option box to make it useful.
We have 1 proposal template with 8 different macros within it setup depending
on the type of work we're performing. We want to create a drop down list
with a variety of options to make these 8 option as versatile as possible.
Below is an example of a sentence that is ran with the macro. The underlined
section is where we like the drop down list to appear.
Pave a -course compacted average depth asphalt pavement consisting of
" of upper course on approximately sy. in the _____ area.

Thx!
--
Thanks in advance for your help!
Amy

Amy,

You are going to have to provide a bit more explaination here. Macros
don't have dropdown formfields.

 

[Greg Maxey]

Amy,

I think we have a misunderstanding of terms. This is a simple macro
procedure:

Sub Test()
MsgBox "Hello Amy"
End Sub

It sounds like you are talking about AutoText. I believe WordPerfect
users might think of AutoText as macros.

You simply type your sentence inserting the dropdowns where
appropriate. Select the whole thing and save it with an AutoText name
using ALT+F3. The dropdown dialog boxes can be accessed by double
clicking on the fields when the form is unprotected.

 

[Amy]

Thanks for the response! I think I was making it harder than I had to.