Excel Userform

[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!

 

[Debra Dalgleish]

There are instructions for a sample UserForm here, including getting the
data into worksheet cells:

http://www.contextures.com/xlUserForm01.html

 

[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!

 

[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

 

[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!