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
– David Zemens

2013-10-07 16:52:15 +00:00
Commented Oct 7, 2013 at 16:52 — David Zemens
– David Zemens, Commented Oct 7, 2013 at 16:52

Joseph · Accepted Answer · 2013-10-07 16:11:59Z

13

You could create a user form:

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

answered Oct 7, 2013 at 16:11

Joseph

5,2001 gold badge27 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Siddharth Rout Over a year ago

Bare Links are not answers :) This should be a comment.

Collectives™ on Stack Overflow

Multiple input box excel VBA

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related