Macros using drop downs

F

Fly Fisher

Hi, this may be an elementary question, but I don't have much experience
creating macos.

I have created a form with a combination of text fields, check boxes and
drop downs. To make it easier for the user, I want to create a macro so that
if they choose a location name, it automatically fills in the location
address, and phone numbers that are in different drop downs. But when I try
to record a macro, it won't let me pick from a drop down. Am I missing a set
here? I have read some previous entries on this site and it looks like I may
have to use programming language. If so, how do I do that and what is it?
Thanks in advance for the help.
 
N

NoodNutt

G'day Fly

Rather than using a macro, and or for that matter dropdowns on the
supplimental information you want to automate, I would use a LookUp.

Assumed New Lookup Sheet Name: MyLookups



A B
C D
1 Location Address
Phone Contact

2 Australia Capital City Dr, Canberra
61 2 Blah Blah Kevin Rudd (PM)
3 USA Washington Blvd, DC
Uncle Sam Bush Pig

And So On...............



On your Main User Sheet:


A B C
D
1 Location Address Phone
Contact
Dropdown B2
=IF($A1="","",(LOOKUP($A1,MyLookUps!$A$2:$D$63635,MyLookUps!$B$2:$B$63635)))
lists C2
=IF($A1="","",(LOOKUP($A1,MyLookUps!$A$2:$D$63635,MyLookUps!$C$2:$C$63635)))

D2
=IF($A1="","",(LOOKUP($A1,MyLookUps!$A$2:$D$63635,MyLookUps!$D$2:$D$63635)))

Copy down as required

HTH
Mark.
 
N

NoodNutt

Ooooops!

Sorry Fly

should be

B2
=IF($A2="","",(LOOKUP($A2,MyLookUps!$A$2:$D$63635,MyLookUps!$B$2:$B$63635)))
C2
=IF($A2="","",(LOOKUP($A2,MyLookUps!$A$2:$D$63635,MyLookUps!$C$2:$C$63635)))
D2
=IF($A2="","",(LOOKUP($A2,MyLookUps!$A$2:$D$63635,MyLookUps!$D$2:$D$63635)))

Regards
Mark
 
F

Fly Fisher

Thanks for the reply Mark, but when I printed it I realized that I must have
been under the wrong part in Office. My issued is in Word not Excel.

Any ideas for MS Word?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top