View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ToferKing ToferKing is offline
external usenet poster
 
Posts: 41
Default Can the InputBox Prompt have Carriage Returns?

I am creating an InputBox and I have 8 options a person may select from.

I would like my InputBox to display the choices in a list form, but I cannot
figure out how to enter carriage returns.

Right now the input box has one statement that looks like this:

Enter the number of the type of work to be performed 1. Excavation 2.
Excavation/Footings 3. Sewer 4. Sewer/Water 5. Water 6. Storm 7.
Irrigation 8. Electric

I want it to look like this:

Enter the number of the type of work to be performed

1. Excavation
2. Excavation/Footings
3. Sewer
4. Sewer/Water
5. Water
6. Storm
7. Irrigation
8. Electric

I have placed (Chr(13)) before each number in the list, but the VB editing
box returns an error when I try to move off the coding line.

Do you have any help for me on this one? I thank you in advance.

Tofer