siddharthnk
New Member
- Joined
- Jun 20, 2013
- Messages
- 48
Dear reader,
Normally I would research this and do it myself however I am greatly pressed for time. I need to set up forms for for getting data into two excel worksheets. The users mess up the data and enter it incorrectly/do not enter all the required data, most of the time. My intention is to use a set of interlinked user forms to guide the users to enter the correct data in the correct cells. I need the workflow to be as follows
Every userform should contain the forward and back buttons. Also i need to display a short text message on every form giving instructions on how that form needs to be filled. All the worksheets of the workbook should be hidden as long as the forms are in operation.
1st userform should contain 3 radio buttons
Create a new code
Add new serial number to the code
Request addional funding on the code
If the user selects the 1st option and clicks next, this form should automatically be hidden and form 2 should be displayed (based on your inputs and sample workbook, i will link the subsequent forms)
The second form should contain a set of entry fields which are linked to cells in the 1st worksheet called Main sheet. as soon as i enter the required values and click on next, the data should be dumped into those cells in the worksheet, the form should be hidden and form no 3 should be displayed. Please note that whenevr i click on the back button on any of the forms the values i have entered in the text boxes hould be visible in the text boxes so that I can modify them on the go.
Form no 3 should have combo boxes. When i select a value from one of the dropdowns, for e.g. if i select east the number EA_02 should be entered in a cell in the worksheet.
Please note that these are basic requirements of the workflow that needs to be achieved and i that have about 20 such forms that i need to design to fill in the enire workbook. I would appreciate if you could send this to me as fast as possible since I would need to adapt the userforms and code in your workbook to my requirements.
Really appreciate the help.
Thanks in advance
Normally I would research this and do it myself however I am greatly pressed for time. I need to set up forms for for getting data into two excel worksheets. The users mess up the data and enter it incorrectly/do not enter all the required data, most of the time. My intention is to use a set of interlinked user forms to guide the users to enter the correct data in the correct cells. I need the workflow to be as follows
Every userform should contain the forward and back buttons. Also i need to display a short text message on every form giving instructions on how that form needs to be filled. All the worksheets of the workbook should be hidden as long as the forms are in operation.
1st userform should contain 3 radio buttons
Create a new code
Add new serial number to the code
Request addional funding on the code
If the user selects the 1st option and clicks next, this form should automatically be hidden and form 2 should be displayed (based on your inputs and sample workbook, i will link the subsequent forms)
The second form should contain a set of entry fields which are linked to cells in the 1st worksheet called Main sheet. as soon as i enter the required values and click on next, the data should be dumped into those cells in the worksheet, the form should be hidden and form no 3 should be displayed. Please note that whenevr i click on the back button on any of the forms the values i have entered in the text boxes hould be visible in the text boxes so that I can modify them on the go.
Form no 3 should have combo boxes. When i select a value from one of the dropdowns, for e.g. if i select east the number EA_02 should be entered in a cell in the worksheet.
Please note that these are basic requirements of the workflow that needs to be achieved and i that have about 20 such forms that i need to design to fill in the enire workbook. I would appreciate if you could send this to me as fast as possible since I would need to adapt the userforms and code in your workbook to my requirements.
Really appreciate the help.
Thanks in advance
