Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

General discussion

Word 2002 Macro/Form Feasibility/Issue

Dec 9, 2005 3:59AM PST

All,

I am attempting to design a standard Vendor Work Order form and I am wondering about the feasibility of what I would like the form to do.

I am wondering if it is possible to have an area of the form automatically populate with a vendor's information when that vendor is chosend from a drop down menu. In my case, I have 4-6 vendors. I would like when Vendor 1 is chosen, the field below it populates with vendor 1's contact info (address, phone, fax, email, etc). I also want to do the ame for the tech who is entering the info.

Is this even feasible? I have been playig around and I can only select one macro per drop down box. Also, when I run it, I get a debug error, but that may be moot given the feasibilty answer.

Thanks!

Brownie

Discussion is locked

- Collapse -
Excel seems better suited for the job.
Dec 9, 2005 7:28PM PST

Use lookup-functions to show the derived info. All very standard, no progamming required.

Kees

- Collapse -
RE: Excel seems better suited for the job.
Dec 12, 2005 3:14AM PST

Thanks for the advice, but could you be a little more specific on what one needs to do. We tried a help on look up, look-up, etc and nothing was htere. Not sure where to begin.

Thanks!

- Collapse -
Re: Excel lookup functions
Dec 12, 2005 4:45AM PST

LJB,

There's a horizontal lookup function, called hlookup (which is hardly used) and a vertical one, called vlookup (which is much more common). But I thought I would offer you the chance to set up your own spreadsheet.

http://www.ozgrid.com/Excel/excel-vlookup-formula.htm is just one of many, many google hits on Excel vlookup.

It's admirable you looked in the help. Not every poster does. But you couldn't find it because you didn't know the exact function name. Bad luck. Didn't you try the function wizard?
You might like to ask your boss to buy you some 'All about Excel'-book. Or better: choose one yourself and let him pay the bill. There are many 1000-page books about the program, and you'll learn a lot you don't know yet. He'll be impressed if you present him with graphs, pivot-tables, what-if analysis and customized buttons to automate routine things, to name but a few features.

Hope this helps. And post again if you've experience any problem you can't solve.


Kees