hi
Inputbox does not provide a dropdown but that sound like a good idea.
A poor-man's way is to supply a help file with the legal answers.
Doesn't keep you from having to test the answer but it does allow the user to help him/herself.
Otherwise you could create a VBA userform that does just what you want.
db
--- In ExcelVBA@yahoogroups.com, railroads@... wrote:
>
> Hi
>
> I want to use a input box in some code. Would like, where the box asks for user input, to have a drop down to select required input. Is this possible with input box (like a combo)? if I use a combobox there is no place to put the question.
>
> Your comments appreciated.
>
> Thanks
>
> Charlie Harris
>
__._,_.___
----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------
MARKETPLACE
.
__,_._,___
Tidak ada komentar:
Posting Komentar