Need help w/ userform with 12 textboxes with data going into colum
 

I have a form that asks for 12 numbers. The user has an button with the
(infinate) option to add another 12 numbers. All the data is sent to Column
D, starting on D8.
How do I send the information to the column?
How do I clear the form when the "Add More" button is selected?
How does the "Add More" Button find the next empty cell on Column D to enter
the next set of numbers?

Need help w/ userform with 12 textboxes with data going into colum
 

I'd start by looking at Debra Dalgleish's site:

http://contextures.com/xlUserForm01.html



cj2k2k wrote:

I have a form that asks for 12 numbers. The user has an button with the
(infinate) option to add another 12 numbers. All the data is sent to Column
D, starting on D8.
How do I send the information to the column?
How do I clear the form when the "Add More" button is selected?
How does the "Add More" Button find the next empty cell on Column D to enter
the next set of numbers?

--

Dave Peterson