Add Range Validation List to an Inputbox

[Gives]

Is there a way to add a named range-defined validation drop-down list to an InputBox without using a Userform for input? (I have a named list "Category" that I would like the user to select from)

 

[HalfAce]

Hello Gives,
Assuming by "an InputBox" you mean a ComboBox (from the Controls Toolbox toolbar)
that is planted directly on the sheet (as opposed to on a userform) you can set the
ListFillRange property to "Catagory" (without the quotes).

Hope it helps.
If this isn't what you've got, (or what you had in mind) then can you elaborate a bit?

 

[Gives]

Input Validation list

I was trying to use soem code like:

temptxt=InputBox("Select category from :")

where the inputbox would have a drop-down category list from the named range instead of an empty box to enter text.

 

[HalfAce]

So, this is part of some code that you want to interupt for some user input?
As far as I know the inputbox is the only option available for this.
At least it's the only one I've ever used, but that only goes up to Xl 2003. I don't
know about '07 if that's what you're using.
(I'd love to be proven wrong on this as a ComboBox would be pretty cool for that
purpose.)

If I'm right in what I think you're trying to do (and that the inputbox is the only tool
available) then my next question would be why you prefer not to use a userform.