Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Adelina Fischer   on Dec 18 In MS Office Category.

  
Question Answered By: Harriet Hughes   on Dec 18

It sounds as though you are on the right track.

I would locate the last+1 row number, and then put the value of each of the
text boxes into its relevant column.

I would not try to make it generic in the sense of using "for each" to loop
through the text boxes because you want to specify which column the value goes
in. So I would use something like:

Newrow = ... last row + 1

With ActiveSheet

.range("A" & Newrow).value = tbxDate.value
.range("B" & Newrow).value = tbxName.value
...
End with

You may also want to capture the username and current date/time and put those
in the list.

Share: 

 

This Question has 3 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on Userform Array to worksheet Or get search suggestion and latest updates.


Tagged: