supermom28115
New Member
- Joined
- May 9, 2022
- Messages
- 43
- Office Version
- 365
- Platform
- Windows
I am trying to determine if I am just doing this wrong or if this is just not possible. I have a userform set up with multipage with 3 pages, the first page has 6 textbox items and I would like to have a procedure pull those details from the sheet that initiates the userform and just have the user verify that the data is correct. Then the user will use records to add data to pages 2 and 3, then a sub takes that data and transfers it all to a second sheet.
The data on page 1 is identifying data for the subject of the data on pages 2 and 3. I have code all over the place trying to make this work, so the whole thing is kind of a mess right now, however this part is the section that doesn't work and I have tried to write code to this operation many different ways. I have been writing the code in the userform code sheet because I was attaching it to a toggle switch for the user to verify that the data is correct. Then I tried to write the code in the sheet code window and call it to the toggle switch code. I have read 4 different books over the last two days and all the information the provided regarding userforms and have not found an answer. Is this even possible? Can I use code similar to textbox4.value = x.offset(52,0).value to get those identifiers onto page 1? If I have to use input boxes and select each cell then I might as well just write code to just copy those 6 data points separately by macro or command button. I was just hoping to automate it as a group and not have to do two different operations to get the task done. I have not found a reference anywhere that says this can not be done, however I also have not found a reference showing how to do this, only how to do a list box or hard set a value into the box that would only change through user input or a change in the properties of the text box. A list would be way to involved and constantly be added to so I would be updating it or some linked table regularly.
Here is the breakdown of what I have been trying to accomplish:
1 - user inputs data into a sheet and may or may not need to add additional notes for each record
2 - If user needs to add additional notes they would use the button on the sheet where they entered the original data which brings up a input box asking for the column name
3 - user puts in the column letter giving the code a cell reference for the data on page one of the form and some later code on the chance the process gets cancelled so that a sub can clear the cell the user puts data in to indicate they have added additional data
4 - At this point the form shows and page 1 should show the identifying data and the user would use the toggle button to indicate if the data is correct
5 - if true the toggle does nothing if false the toggle cancels the task
6 - the user adds the data on page 2 and page 3 and presses a command button to add the data
7 - the command button goes to sheet2 finds the next empty row and puts the data from the form into the cells
8 - then the form unloads and closes until triggered again
The data on page 1 is identifying data for the subject of the data on pages 2 and 3. I have code all over the place trying to make this work, so the whole thing is kind of a mess right now, however this part is the section that doesn't work and I have tried to write code to this operation many different ways. I have been writing the code in the userform code sheet because I was attaching it to a toggle switch for the user to verify that the data is correct. Then I tried to write the code in the sheet code window and call it to the toggle switch code. I have read 4 different books over the last two days and all the information the provided regarding userforms and have not found an answer. Is this even possible? Can I use code similar to textbox4.value = x.offset(52,0).value to get those identifiers onto page 1? If I have to use input boxes and select each cell then I might as well just write code to just copy those 6 data points separately by macro or command button. I was just hoping to automate it as a group and not have to do two different operations to get the task done. I have not found a reference anywhere that says this can not be done, however I also have not found a reference showing how to do this, only how to do a list box or hard set a value into the box that would only change through user input or a change in the properties of the text box. A list would be way to involved and constantly be added to so I would be updating it or some linked table regularly.
Here is the breakdown of what I have been trying to accomplish:
1 - user inputs data into a sheet and may or may not need to add additional notes for each record
2 - If user needs to add additional notes they would use the button on the sheet where they entered the original data which brings up a input box asking for the column name
3 - user puts in the column letter giving the code a cell reference for the data on page one of the form and some later code on the chance the process gets cancelled so that a sub can clear the cell the user puts data in to indicate they have added additional data
4 - At this point the form shows and page 1 should show the identifying data and the user would use the toggle button to indicate if the data is correct
5 - if true the toggle does nothing if false the toggle cancels the task
6 - the user adds the data on page 2 and page 3 and presses a command button to add the data
7 - the command button goes to sheet2 finds the next empty row and puts the data from the form into the cells
8 - then the form unloads and closes until triggered again
Last edited: