title: How do I align a UserForm next to the active cell?
body: <p>I have a UserForm of a MonthView that opens when I click in the specified range of cells. <a href="https://stackoverflow.com/questions/24700052/position-userform-differently-for-each-activecell-clicked">This SO thread</a> gave me the basic script. It doesn't put the UserForm where I expect.</p>
  
  <p>Here is the script (that I placed in a specific worksheet) to open the UserForm when I click any cell in range <code>B3:C2000</code>.</p>
  
  <pre><code>Private Sub Worksheet_SelectionChange(ByVal Target As Range)
      Set oRange = Range("B3:C2000")
      If Not Intersect(Target, oRange) Is Nothing Then
          frmCalendar.Show
          frmCalendar.Top = ActiveCell.Offset(0, 0).Top
          frmCalendar.Left = ActiveCell.Offset(0, 1).Left
      End If
  End Sub
  </code></pre>
  
  <p>Question 1: I have the UserForm StartUpPosition property set to <code>0 - Manual</code> - is this correct?</p>
  
  <p>Question 2: When I click any cell in the specified range, for the first time after opening the workbook, the UserForm always opens in the far top left corner of the screen. Why?</p>
  
  <p>Question 3: When I click any cell in the specified range, for any clicks after the first, the UserForm opens relative to the previous cell that was active, instead of the one I just clicked.  How do I get it to open relative to the cell just clicked, instead of relative to the previous active cell?</p>
  
  <p>Question 4: Why does it appear to align the bottom of the UserForm instead of the top?</p>
  
  <p>After I do the following steps:<br>
  1 - Click cell C15<br>
  2 - UserForm opens<br>
  3 - Close UserForm<br>
  4 - Click cell 16<br>
  5 - UserForm opens</p>
  
  <p>This is what I see:</p>
  
  <p><a href="https://i.stack.imgur.com/Qs5sI.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Qs5sI.png" alt="Original result"></a></p>
  
  <p><strong>EDIT: Here is the result after implementing J. Garth's solution (and changing the Offset property to (0, 2):</strong></p>
  
  <p><a href="https://i.stack.imgur.com/KwRlM.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/KwRlM.png" alt="Correct result"></a></p>