Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Cindy Fisher   on Aug 16 In MS Office Category.

  
Question Answered By: Pam Harrison   on Aug 16

My idea was on clicking the Submit button to loop through the userform
textbox's and collect the data into a single array.
Locate the last record, use offset to move to the next row.
Insert the user  input from the array


I like to make these routines as generic as possible, so would like to
additionally think of combo boxes, list boxes and option groups that I
may add  to the userform  at a later stage, but that is utopia. Just
dealing with plain textboxes at the moment, but if anybody has ideas I
would really appreciate them

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: