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]
|