title: How to input data from a userform into a selected cell - Excel
body: <p>I'm a noob in excel VBA so please do understand. </p>
  
  <p>I am tasked to input employee total working time into a worksheet efficiently to minimize human error. So there is three option, normal working time is  490 minutes, over time is 640 minutes and user input option as sometimes the employee do not work for 490 or 640 minutes. </p>
  
  <p>So I've created a userform, in my userform, i have input 2 option button for the normal working time and over time. I have also input a textbox for the third option to the user to input a specific working time.</p>
  
  <p>Therefore, I wanted to open up the userform when click on a cell instead of a button. And input the data from the userform into the selected cell. I'm able to open up the userform by clicking on the cell, using this code</p>
  
  <pre><code>Private Sub Worksheet_SelectionChange(ByVal Target As Range)
      If Not Application.Intersect(Target, Range("H10:I29")) Is Nothing Then
          UserForm1.Show
      End If
  End Sub
  </code></pre>
  
  <p>My issues is I do not know how to input the data from the userform into the selected cell. </p>
  
  <p>Any help is appreciated. Thanks. </p>