View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default InputBox using "Data Validation"

Nope.

But you could create your own userform that does exactly what you want.

If you want to design your own userform:

Debra Dalgleish shares some tips:
http://contextures.com/xlUserForm01.html


MikeF wrote:

Is there any way an InputBox can provide a drop-down list [ie Data
Validation] ?

A range named NumberID [up to six, or possibly a few more rows] should
ideally "drop down" when the InputBox is called.

Thanx,
- Mike


--

Dave Peterson