Multiple input box excel VBA

excel vba input multiple-columns
Thatdude1 picture Thatdude1 · Oct 7, 2013 · Viewed 124.5k times · Source

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?

Answer

Joseph picture Joseph · Oct 7, 2013

You could create a user form:

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

Related questions

Excel VBA calling sub from another sub with multiple inputs, outputs of different sizes

I would like to call a sub from another sub inside in the same module. The first sub would be my main code and there I would call the second subroutine. Second subroutine receives multiple inputs as integer, double, double …

Read More
Is there a way to crack the password on an Excel VBA Project?

I've been asked to update some Excel 2003 macros, but the VBA projects are password protected, and it seems there's a lack of documentation... no-one knows the passwords. Is there a way of removing or cracking the password on a VBA …

Read More
How do I declare a global variable in VBA?

I wrote the following code: Function find_results_idle() Public iRaw As Integer Public iColumn As Integer iRaw = 1 iColumn = 1 And I get the error message: "invalid attribute in Sub or Function" Do you know what I did wrong? I tried …

Read More