Create drop down list within an already created macro through VBA

Tutorials Win: Microsoft Windows Forum

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!
--
Thanks in advance for your help!
Amy
Top

Re: Create drop down list within an already created macro through VBA by Greg

Greg
Wed Mar 21 13:03:08 CDT 2007

Amy,

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

On Mar 21, 1:55 pm, Amy <A...@discussions.microsoft.com> wrote:
> 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!
> --
> Thanks in advance for your help!
> Amy


Top

Re: Create drop down list within an already created macro through by Amy

Amy
Wed Mar 21 13:32:26 CDT 2007

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


"Greg Maxey" wrote:

> Amy,
>
> You are going to have to provide a bit more explaination here. Macros
> don't have dropdown formfields.
>
> On Mar 21, 1:55 pm, Amy <A...@discussions.microsoft.com> wrote:
> > 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!
> > --
> > Thanks in advance for your help!
> > Amy
>
>
>
Top

Re: Create drop down list within an already created macro through by Amy

Amy
Wed Mar 21 13:37:00 CDT 2007

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


"Greg Maxey" wrote:

> Amy,
>
> You are going to have to provide a bit more explaination here. Macros
> don't have dropdown formfields.
>
> On Mar 21, 1:55 pm, Amy <A...@discussions.microsoft.com> wrote:
> > 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!
> > --
> > Thanks in advance for your help!
> > Amy
>
>
>
Top

Re: Create drop down list within an already created macro through by Greg

Greg
Wed Mar 21 14:20:04 CDT 2007

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.



On Mar 21, 2:32 pm, Amy <A...@discussions.microsoft.com> wrote:
> 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
>
>
>
> "Greg Maxey" wrote:
> > Amy,
>
> > You are going to have to provide a bit more explaination here. Macros
> > don't have dropdown formfields.
>
> > On Mar 21, 1:55 pm, Amy <A...@discussions.microsoft.com> wrote:
> > > 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!
> > > --
> > > Thanks in advance for your help!
> > > Amy- Hide quoted text -
>
> - Show quoted text -


Top

Re: Create drop down list within an already created macro through by Amy

Amy
Wed Mar 21 14:47:03 CDT 2007

Thanks for the response! I think I was making it harder than I had to.
--
Thanks in advance for your help!
Amy


"Greg Maxey" wrote:

> 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.
>
>
>
> On Mar 21, 2:32 pm, Amy <A...@discussions.microsoft.com> wrote:
> > 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
> >
> >
> >
> > "Greg Maxey" wrote:
> > > Amy,
> >
> > > You are going to have to provide a bit more explaination here. Macros
> > > don't have dropdown formfields.
> >
> > > On Mar 21, 1:55 pm, Amy <A...@discussions.microsoft.com> wrote:
> > > > 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!
> > > > --
> > > > Thanks in advance for your help!
> > > > Amy- Hide quoted text -
> >
> > - Show quoted text -
>
>
>
Top