Data Entry Form
I have created and designed a user form for data entry. How do get it so that
when you click the submit button the data entered in the forms is entered into the log table and the form is cleared for a new input. also how would i auto increment an issue number so its the nest in line? cheers |
Data Entry Form
Check out the below link
http://www.contextures.com/xlUserForm01.html If this post helps click Yes --------------- Jacob Skaria "Gazz_85" wrote: I have created and designed a user form for data entry. How do get it so that when you click the submit button the data entered in the forms is entered into the log table and the form is cleared for a new input. also how would i auto increment an issue number so its the nest in line? cheers |
Data Entry Form
Hi Jacob. I like this example. i have one more question. I need an button to
select the sheet i need the data to go. Today i need to select sheet "monday" from the button, and the data to go to this sheet. Tomorrow i will select "tuesday" sheet and the data to go to this sheet. Can this be done? Thanks! "Jacob Skaria" a scris: Check out the below link http://www.contextures.com/xlUserForm01.html If this post helps click Yes --------------- Jacob Skaria "Gazz_85" wrote: I have created and designed a user form for data entry. How do get it so that when you click the submit button the data entered in the forms is entered into the log table and the form is cleared for a new input. also how would i auto increment an issue number so its the nest in line? cheers |
Data Entry Form
Check your later post.
puiuluipui wrote: Hi Jacob. I like this example. i have one more question. I need an button to select the sheet i need the data to go. Today i need to select sheet "monday" from the button, and the data to go to this sheet. Tomorrow i will select "tuesday" sheet and the data to go to this sheet. Can this be done? Thanks! "Jacob Skaria" a scris: Check out the below link http://www.contextures.com/xlUserForm01.html If this post helps click Yes --------------- Jacob Skaria "Gazz_85" wrote: I have created and designed a user form for data entry. How do get it so that when you click the submit button the data entered in the forms is entered into the log table and the form is cleared for a new input. also how would i auto increment an issue number so its the nest in line? cheers -- Dave Peterson |
All times are GMT +1. The time now is 11:37 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com