For a better experience, please enable JavaScript in your browser before proceeding.

In cell A2 if the value A then allow both positive and negative integers.

I have attached sample data, i need someone to help me convert the left side to how the data looks on the right.

You create and access these UserForms in the Visual Basic Editor.

Your job, if you choose to accept it, is to add some controls to this UserForm.

You use the tools in the Toolbox to add controls to your UserForm.

If, for some reason, the Toolbox doesnt appear when you activate your UserForm, choose View Toolbox.

After you add a control, you can move and resize it by using standard techniques.

In addition, the UserForm itself has its own set of properties.

You can change these properties with the aptly named Properties window.

This shows the Properties window when a CommandButton control is selected.

If you select a different control, the properties change to those appropriate for that control.

To hide the Properties window and get it out of the way, click the Close button in its title bar.

If youre viewing code, double-click the UserForm name in the Project window to return to the UserForm.

Most of the time, you wont have any more code in the procedure.

As you later see, you put your event-handler procedures in the Code window for the UserForm.

These procedures kick in when the user works with the controls on the UserForm.

For example, if you add a CheckBox control to a UserForm named UserForm1, the CheckBox control is named CheckBox1 by default.

You can use the Properties box to make this control appear with a check mark.

If thats the case, you can omit the UserForm object qualifier and write the statement like this.

The following statement executes a macro named PrintReport if the check box (named CheckBox1) is checked.

How To Insert Userform In Excel 2016 For Mac