Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

How to enter values from a user form in excel spreadsheet

  Asked By: Harley    Date: Dec 12    Category: MS Office    Views: 1770
  

I have a userform and I need to enter the values from this form to the
worksheet. Every time the user enters something in the form, they need
to be entered at the end of the existing rows in the worksheet.

I am new to VBA. Any help would be appreciated.

Share: 

 

1 Answer Found

 
Answer #1    Answered By: Laurie Lawrence     Answered On: Dec 12

well getting the last row is easy... range("A65535").end(xlup).row will give
you the last used row... so you just have to assign that + 1 to get the next
empty row.. for ex.

irow = range("A65535").end(xlup).row +1

then the data would be put at ... range("A" & irow).value = data....

hope this helps... if you need more help  i'd need to see what code you use now
to get the data from the form  to the spreadsheet

 
Didn't find what you were looking for? Find more on How to enter values from a user form in excel spreadsheet Or get search suggestion and latest updates.




Tagged: