5 Replies Latest reply on Jan 10, 2019 11:41 PM by Topper1

    Inputting data from a user form

    Topper1

      What I am trying to do is take data from a userform and put it into a process book display and then hold that information in that display until the next time the userform is activated. This is my code from the user form ok button.

      Private Sub OK_Click()

       

       

      Dim KPI As Display

       

      Set KPI = ThisDisplay

      s1 = SDH.Value

      s2 = SDL.Value

      s3 = SWH.Value

      s4 = SWL.Value

      s5 = GPH.Value

      s6 = GPL.Value

      s7 = MWH.Value

      s8 = MWL.Value

      s9 = SFH.Value

      s10 = DOH.Value

      s11 = DOL.Value

      s12 = STH.Value

      s13 = STL.Value

      s14 = CGMH.Value

      s15 = CGML.Value

       

      1. ThisDisplay.Text3.Contents = s1
      2. ThisDisplay.Text4.Contents = s2
      3. ThisDisplay.Text5.Contents = s3
      4. ThisDisplay.Text6.Contents = s4
      5. ThisDisplay.Text7.Contents = s5
      6. ThisDisplay.Text8.Contents = s6
      7. ThisDisplay.Text10.Contents = s7
      8. ThisDisplay.Text11.Contents = s8
      9. ThisDisplay.Text9.Contents = s9
      10. ThisDisplay.Text23.Contents = s14
      11. ThisDisplay.Text24.Contents = s15

       

       

      End Sub

      I know I am missing something simple please help if you can.