I am not sure what I am doing wrong, I am new to UserForms but I've done a few and they worked fine. I'm trying a new one where I am entering in data into the userform and having it populate into a spreadsheet. I have using the following code, and it is either making the next line go way down the worksheet or it's overriding something already in the worksheet. What am I doing wrong? I have attached the files. The code I am using is, " emptyRow = WorksheetFunction.CountA(Range("A:A")) + 1" Which works for other sheets, but not this one...
Reason: I am creating baselines for a manufacturing production line. I have the first tab have the printable baseline. I have the second tab with all the data and the userform. The idea is that the userform populates the spreadsheet, and then the operator can use the baseline sheet to type in the blueprint number and have the information pop into that printable sheet. Previously, we did all this without the userform and I just input the data for the operators - but if I can have the operators input it into the userform that saves a huge step.
Bookmarks