Prizeo12
03-14-2012, 12:02 PM
Hello! I'm new here, so don't be too critical. I'm a chemical engineer that only touched on VBA (2007) back in school, and I'm trying to learn how to use it again. So anyway, time for business:
I've made a module that allows user input, and pastes those values into the worksheet in selected cells. What I WANT to do is make a log of those cells. So, have it paste Product to "C3", Size to "C5", etc...AND below a set row (say, 35) look for the next empty row to paste all the data in line. I'm guessing it's something after:
...
ThisWorkbook.Sheets("Dry").Range("H11") = Fines.Value
ThisWorkbook.Sheets("Dry").Range("H14") = Overs.Value
ThisWorkbook.Sheets("Dry").Range("H17") = Dust.Value
ThisWorkbook.Sheets("Dry").Range("H21") = Down.Value
'these paste the values in the F/O/D/D ^ input boxes to the ranges.
Unload Me
End Sub
I've looked all over the internet for something, but I can't find anything that refers from a module (not that there should be much difference). Any help is much appreciated!
I've made a module that allows user input, and pastes those values into the worksheet in selected cells. What I WANT to do is make a log of those cells. So, have it paste Product to "C3", Size to "C5", etc...AND below a set row (say, 35) look for the next empty row to paste all the data in line. I'm guessing it's something after:
...
ThisWorkbook.Sheets("Dry").Range("H11") = Fines.Value
ThisWorkbook.Sheets("Dry").Range("H14") = Overs.Value
ThisWorkbook.Sheets("Dry").Range("H17") = Dust.Value
ThisWorkbook.Sheets("Dry").Range("H21") = Down.Value
'these paste the values in the F/O/D/D ^ input boxes to the ranges.
Unload Me
End Sub
I've looked all over the internet for something, but I can't find anything that refers from a module (not that there should be much difference). Any help is much appreciated!