Multiple input box excel VBA

Question

Right now I've been using multiple Input boxes to get user input for a couple of strings i need:

 Dim U As String
 Dim P As String

U = Application.InputBox("Enter Username", "Username", Type:=1))
P = Application.InputBox("Enter Pwd", "pwd", Type:=1))

etc ..

Is there any way I can make an input box with multiple inputs or some sort of multiple input into an Excel worksheet using VBA?

UserForms are the way to go, per the answer below. – David Zemens Oct 07 '13 at 16:52 — David Zemens, Oct 07 '13 at 16:52

score 13 · Accepted Answer · answered Oct 07 '13 at 16:11

13

You could create a user form:

http://www.excel-vba-easy.com/vba-userform-excel-vba.html

answered Oct 07 '13 at 16:11

Joseph

5,070
1
25
26

5

Bare Links are not answers :) This should be a comment. – Siddharth Rout Oct 07 '13 at 16:12

Multiple input box excel VBA

1 Answers1