Excel Userform

  • Thread starter Thread starter CC
  • Start date Start date
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!
 
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!
 
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
 
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!
 
Back
Top