Excel Userform

C

CC

I need help on getting my userform data into an Excel sheet. I have the
nextrow macro but need to be able to have the userform data enter into
specific cells or fields on an Excel spreadsheet.
Any suggestions? Thanks!
 
C

CC

Thank you but this gives me the next row instructions. I really need
some way of getting the data into unique cells, not just the next row.
Ex.) Enter textbox1 data into cell A5. Thanks again!
 
D

Dave Peterson

Maybe just getting rid of the references to iRow and put the ranges you want:

'copy the data to the database
ws.Cells(1, 5).Value = Me.textbox1.value
or even
ws.Range("a5").value = Me.textbox1.value
 
C

CC

I ended up figuring it out. Thanks for your help. Here is what I came
up with:

Sheets("Print Central Request").Activate
Cells(5, 8) = DateSubmitted2.Value

Thanks again!
 
Top