Question

Which control is suitable to collect the input from the user in VBA

Answer 1

Answer:

If you are on excel you can also use application.inputbox

you can click to insert values of cells

Answer 2

The control that is suitable to collect the input from the user in VBA is the text box.

• Text boxes are a part of user forms and in the developer tab of any excel worksheet.
• If we want to make text boxes in a user form, we can select the textbox option from user form controls in VBA or the design tab in the worksheet.