Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,565
Default VBA Input box (or MsgBox) with pull down or choices

You might find this helpful:

http://www.contextures.com/xlUserForm01.html

It gives several examples of how to create a UserForm and put controls on
it, which is baxically what you are asking about in your post.


"BlueWolverine" wrote in message
...
Hello,
MS Excel 2003 on XP PRO.

I'm looking to generate a popup (msg box or input box) that instead of
free
form text has a "combobox" or "pulldown" to it. So that the user picks a
value from a list, and hits OK. This way they can't input incorrect
values.

Is this possible? If not I have back up methods but this would be PERFECT
for my application.

Thanks,
--
BlueWolverine
MSE - Mech. Eng.
Go BLUE!



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
change cell contents when pull down menu choices change jb21 Excel Worksheet Functions 3 November 21st 08 10:34 PM
Using an input box for multiple choices has display limits jbarrington Excel Programming 2 September 28th 08 11:55 PM
Input selection choices ARGT Excel Discussion (Misc queries) 4 July 8th 08 03:59 AM
Input box with multiple choices jsd219 Excel Programming 0 November 1st 06 02:08 PM
validation - anyway to select multiple choices in the pull down? TracyChoi Excel Worksheet Functions 2 June 3rd 06 01:51 AM


All times are GMT +1. The time now is 06:42 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"