Multiple Inputs in a Form (Inputbox) - Checkbox

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?
 
A

aalwazeer

Thanks

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top