AnsweredAssumed Answered

Inputting data from a user form

Question asked by Topper1 on Jan 10, 2019
Latest reply on Jan 10, 2019 by 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.

Outcomes