Thread: Input box/form
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
merjet merjet is offline
external usenet poster
 
Posts: 812
Default Input box/form

Try a Userform. Put 2 Textbox controls on it for the 1st 2
inputs and a ListBox for the 3rd. Add a Label for each.

If you need further guidance, see:
Excel97 tutorial to create a simple UserForm:
http://support.microsoft.com/default...;en-us;Q161514

Excel 2000 tutorial to create a simple UserForm:
http://support.microsoft.com/search/...;en-us;Q213749

If you have XP, the above guidance will still probably work

In place of the code you now have put UserForm1.Show.

HTH,
Merjet