Help with code
I think I may have asked this question before but I’m not sure. So will ask anyway
what I have is a Sheet that has 6 Textboxes on it and a Validity List.
Sheet2 has all these features, and Sheet3 is where the data comes from.
My Textboxes are linked to Cells X2,X4,X6,X8,X10,X12, these cells contain a Vlookup function so that when an item in my List is selected my Textboxes are populated with the matching info.
I tried to add a Save button so that I could type data into my textboxes and then save that data back to the next Blank Row in Sheet3. But what happened was that it deleted my Vlookup functions from the linked cells.
is there code “Macro” to be able to do this, without linking to cells.
thanks for any help in advance
oControls = oSheet.DrawPage.Forms.getByIndex( 0 )
I will take a look at this and see how I go
Remove the linked cell from the text box.
Sheet content changed event set to run LaunchSheetChanged.
Create a button on the Launch sheet and set it to run TextBoxButton.
You could possibly map TextBoxButton to the Text box text modified or changed event but I think a separate button might be more obvious to the user. The text box changed event only seemed to run after selecting outside of the text box.
Below are only copying text box to the end of the table, and updating one text box from a cell that would have your vlookup.