Multiple Inputs in a Form (Inputbox) - Checkbox

  • Thread starter Thread starter aalwazeer
  • Start date Start date
A

aalwazeer

Hi,

Can we use one InputBox (or any other form) for multiple inputs. I
only know how use it for one input as follows (e.g.):
==
Dim Input1 As Variant
Dim Input2 As Variant
Dim Input3 As Variant
Input1 = Application.InputBox("Enter First Input:")
Input2 = Application.InputBox("Enter First Input:")
Input3 = Application.InputBox("Enter First Input:")
==
Is there any way to input the 3 inputs in one from


Also how can I define a variable by a checkbox instead of a variable
in a form :

e.g.:
==
Dim i As Variant
i= Application.InputBox("Do you want to change the data? (y or n):")
==

Can (i) be defined using a CheckBox?
 
Thanks

What I was thinking is getting the 3 or more inputs in boxes of one
form (InputBox or other form)
 
Back
Top