AnsweredAssumed Answered

Text box input to Processbook macro

Question asked by GoosseUSS on Feb 19, 2015
Latest reply on Jan 11, 2017 by HardikS

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?

Outcomes