Thread: [Solved] Using a drop down list in a macro
View Single Post
 
Old 07-05-2017, 02:38 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,527
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
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]
Reply With Quote