View Single Post
 
Old 07-05-2017, 10:04 AM
Whytewhysper Whytewhysper is offline Windows 10 Office 2016
Novice
 
Join Date: Jul 2017
Location: Aurora, CO
Posts: 2
Whytewhysper is on a distinguished road
Default Using a drop down list in a macro

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

Last edited by Whytewhysper; 07-05-2017 at 12:13 PM.
Reply With Quote