title: How to link textbox to a specific cell on specific sheet in Excel?
body: <pre><code>Private Sub RankCombo_Change()
  Dim Val As String
  
  Val = Me.RankCombo.Value
   [L15].Value = Val
   
  End Sub
  </code></pre>
  <p>I'm trying to get this textbox/dropdown to link to L15 on Sheet 1, which is not active sheet and is hidden. I tried [sheet1.L15] but I can't find the wording for it, thanks in advance.</p>