discussion: Run excel macro within embedded excel object
in Private Sub TextBox1_Change() code appears to take a value from a Processbook textbox and write it to Excel
When I use the
Days = TextBox1.Value line
TextBox1 will not compile. It goes to debug.
Right click on the text box shows [Text1] but changing to Days = Text1.Value also fails.
I have been able to recover a value from Excel into Processbook, change it and place it into Excel
Is there a way to read a value from a Processbook text box into a variable within a macro?