Greetings, I am working up another userform for quick data entry into a worksheet. Basically just five text boxes passing the name, date, item name, comments and serial number to the next blank row on the columns - simple stuff. Typically they user only enters one item at at time but occasionally they may do two or three. I was going to add in multiple sets of text boxes for each set of data but then it occurred to me, "I wonder if you could put all of the items in the same text box, maybe separated by a comma, and then just have the code parse it out to each subsequent row?" So for three items I guess I would have to type my name in the name TB three times, and then the item name and such in their own TB's separated by commas. Is this even practical? I have included the snippet of code that I am using to pass the values to the worksheet and I appreciate any input from everyone - thanks.
VBA Code:
Private Sub EnterData_Click()
Dim Found As Range
Dim i As Long
Dim Lastrow As Long
Worksheets("CDS History").Activate
With Sheets("CDS History")
nextrow = .Range("A" & Rows.Count).End(xlUp).Row + 1
.Range("A" & nextrow) = ChemicalBox.Value
.Range("B" & nextrow) = LotNumber.Value
.Range("C" & nextrow) = TechName.Value
.Range("D" & nextrow) = Now()
.Range("E" & nextrow) = CommentBox
.Range("G2") = ChemicalBox.Value
.Range("H2") = Now()
.Range("I2") = TechName.Value
.Range("J2") = CommentBox.Value
' and some other stuff....