title: VBA Excel: Userform Textbox to show value of cell referenced in formula
body: <p>I have an excel workbook with two worksheets, used by my executives &amp; their admin assistants to co-ordinate workflow tasks. </p>
  
  <p>Data added to Sheet 1 (Support Staff Workflow) is 'copied' using a simple in-cell formula on Sheet 2 (Broker Workflow) - i.e cell B9 formula is <em>='Support Staff Workflow'!B9</em></p>
  
  <p>Columns A:F are identical in both sheets and these columns are protected in Sheet 2 so that they're only able to be edited via Sheet 1</p>
  
  <p>When a broker selects a cell in Column B (Client Name) of Sheet 2, a command button becomes visible so they can call a userform and select the administration tasks they want support staff to complete for that client. </p>
  
  <p>My userform has 2 textboxes (Client Name &amp; Policy Number) and various Y/N option boxes for each task. 
  The command button will find the matching Client Name (Column B) and Policy Number (Column E) on sheet 1 and enter a value for the tasks required for that transaction. </p>
  
  <p>To ensure we can match the client name &amp; policy number on Sheet 1, I want to auto-fill these textboxes to the value of the cell that the broker selected [to call the userform]. The problem I'm having is getting my VBA code to fetch the text in Sheet 1 instead of the formula that's in the selected cell on Sheet 2 (which is resulting in a blank textbox).</p>
  
  <p>I've tried searching online for a solution but haven't been able to find anything to assist. </p>
  
  <p>Any help that you could provide with this would be much appreciated. </p>
  
  <p>Thanks</p>
  
  <p><strong>EDIT</strong> </p>
  
  <p>The code on my userform (that's trying to fill these textboxes with values from Sheet 2) is:</p>
  
  <pre><code>Private Sub UserForm_Initialize()
     With Me
         .TxtClient.Value = Cells(ActiveCell.Row,"B").Value 
         .TxtPolNum.Value = Cells(ActiveCell.Row,"E").Value
     End With
  End Sub
  </code></pre>
  
  <p>When I run the form, the textboxes appear blank. I presume because the ActiveCell contains a formula not an actual value/text?</p>