PDA

View Full Version : Trying to create an interactive UserForm



ux3messe
06-12-2018, 12:47 PM
Hello,

I am working on creating a program that will go through a list that of identification numbers and ask a series of questions that require user input for each one.
Here is how I would like it to be structured: The text box will contain the identification number, and below that there will be three Option Buttons: A, B, and C. The user will choose one of the three options, and based on their choice, I would like the value "A", "B" or "C" to be placed in the cell that corresponds to the same row (new column) that the identification number came from. Furthermore, I want to implement another space where the user can input a number that will also be placed into the same sheet in the same row as the corresponding identification number and the chosen option (A, B or C), again, in a separate column.

I also need this to all be in a loop that runs until each identification number that is in the excel sheet has gone through the user input process.

Here is what I would like to pull from the excel sheet and have placed in a text box on the User Form.

Identification #
1130-19-408-A
5873-48-390-A
2083-03-947-B
2834-93-837-C
8473-00-287-A
0289-12-109-B
0842-85-209-B
0548-21-039-C

For example:

UserForm:

Identification number:
1130-19-408-A

O A
O B
O C

Quantity:
[User input here]


Output:
(assuming the user chose option B, and entered 2096 into the quantity box)

Identification # Option Quantity
1130-19-408-A B 2096
5873-48-390-A
2083-03-947-B
2834-93-837-C
8473-00-287-A
0289-12-109-B
0842-85-209-B
0548-21-039-C


I have been working on this myself for a few days now, read through many forums, but have not made much progress. I am eager to lean as much as I can so that eventually I will be self-sufficient with tasks in excel such as this, so any help that I can get will be greatly appreciated. Hopefully I was clean enough in my description above, but if not, please let me know! (This is my first time posting on this forum).