3 Replies Latest reply on Jan 11, 2017 5:11 PM by HardikS

    Text box input to Processbook macro

    GoosseUSS

      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?