Hello,



I believe this needs to be moved to the VBA forum.
I want to have a drop down list used in a macro. Is it possible to have the drop down list appear in the InputBox? If so, what would the VBA code look like to make this happen?

What I am attempting to do is provide a list of vendors to choose from through a macro that is currently using InputBox for the person to enter the data. The list of vendors will help decrease typos and incorrect vendor names appearing in the document that is being using to help populate an email. I am really new to the VBA coding but not so new to programming and macro creation. I do not know if what I am asking is possible or if I need to take a different approach to yield the same results.

Tim M aka Whytewhysper

An InputBox cannot be made to function as a dropdown; you'd need a userform for that. The most you could do with an InputBox is to display a list (e.g. numbered) and have the user select an item from that list (e.g. input the corresponding item number).

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

You could start by looking at the example at https://www.msofficeforums.com/word/...uggestion.html which employs a simple userform populated from an Excel workbook. It wouldn't be too difficult to modify that to use your vendors' information to populate your document.

__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com