Hello!

I would like to write a macro that includes an inputBox.
If you start the macro, the inputBox should pop-up with a
list. Then, I would like the user to choose from a list
that is defined e.g. by the Range "A1:A10".
If the user chooses an item from the list, the macro
should continue with that item, e.g.: user chooses 2nd
item and the macro runs differently than with item 3 or 4.
How can I do it? Can anybody help?
Thanks so much,
Mirja

Use a userform with a listbox or a combobox.

http://www.microsoft.com/ExcelDev/Articles/sxs11pt1.htm
Lesson 11: Creating a Custom Form
Excerpted from Microsoft® Excel 97 Visual Basic® Step by Step.


Peter Aiken Articles:
Part I
http://msdn.microsoft.com/library/en...FormsPartI.asp
Part II
http://msdn.microsoft.com/library/en...ormsPartII.asp

XL97: How to Use a UserForm for Entering Data (Q161514)
http://support.microsoft.com/?id=161514

XL2000: How to Use a UserForm for Entering Data (Q213749)
http://support.microsoft.com/?id=213749

Other references:

http://j-walk.com/ss/excel/tips/tip84.htm

http://support.microsoft.com/default...b;en-us;829070
How to use Visual Basic for Applications examples to control UserForms in
Microsoft Excel


http://support.microsoft.com/?id=168067
File Title: Microsoft(R) Visual Basic(R) for Applications Examples for
Controlling UserForms in Microsoft Excel 97
File Name: WE1163.EXE
File Size: 161742 bytes
File Date: 05/08/97
Keywords: kbfile
Description: This Application Note is an introduction to manipulating
UserForms in Microsoft Excel 97. It includes examples and Microsoft Visual
Basic for Applications macros that show you how to take advantage of the
capabilities of UserForms and use each of the ActiveX controls that are
available for UserForms


--
Regards,
Tom Ogilvy


"Mirja" wrote in message
...
Hello!

I would like to write a macro that includes an inputBox.
If you start the macro, the inputBox should pop-up with a
list. Then, I would like the user to choose from a list
that is defined e.g. by the Range "A1:A10".
If the user chooses an item from the list, the macro
should continue with that item, e.g.: user chooses 2nd
item and the macro runs differently than with item 3 or 4.
How can I do it? Can anybody help?
Thanks so much,
Mirja

Many thanks, I'll try it out ...

-----Original Message-----
Use a userform with a listbox or a combobox.

http://www.microsoft.com/ExcelDev/Articles/sxs11pt1.htm
Lesson 11: Creating a Custom Form
Excerpted from Microsoft® Excel 97 Visual Basic® Step by
Step.


Peter Aiken Articles:
Part I
http://msdn.microsoft.com/library/en-
us/dnoffpro01/html/IntroductiontoUserFormsPartI.asp
Part II
http://msdn.microsoft.com/library/en-
us/dnoffsol02/html/IntroductiontoUserFormsPartII.asp

XL97: How to Use a UserForm for Entering Data (Q161514)
http://support.microsoft.com/?id=161514

XL2000: How to Use a UserForm for Entering Data (Q213749)
http://support.microsoft.com/?id=213749

Other references:

http://j-walk.com/ss/excel/tips/tip84.htm

http://support.microsoft.com/default.aspx?scid=kb;en-
us;829070
How to use Visual Basic for Applications examples to
control UserForms in
Microsoft Excel


http://support.microsoft.com/?id=168067
File Title: Microsoft(R) Visual Basic(R) for Applications
Examples for
Controlling UserForms in Microsoft Excel 97
File Name: WE1163.EXE
File Size: 161742 bytes
File Date: 05/08/97
Keywords: kbfile
Description: This Application Note is an introduction to
manipulating
UserForms in Microsoft Excel 97. It includes examples and
Microsoft Visual
Basic for Applications macros that show you how to take
advantage of the
capabilities of UserForms and use each of the ActiveX
controls that are
available for UserForms


--
Regards,
Tom Ogilvy


"Mirja" wrote in
message
...
Hello!

I would like to write a macro that includes an inputBox.
If you start the macro, the inputBox should pop-up with
a
list. Then, I would like the user to choose from a list
that is defined e.g. by the Range "A1:A10".
If the user chooses an item from the list, the macro
should continue with that item, e.g.: user chooses 2nd
item and the macro runs differently than with item 3 or
4.
How can I do it? Can anybody help?
Thanks so much,
Mirja


.