Userform position "off the screen"

[quackdad]

It appears that when a userform's startup position property is set to Manual, the position of the form is relative to the selected cell, but only in terms of the cell's position relative to A1. I could select a cell such as AC8, which means that A1 would not be visible, but form pops up as if A1 were showing in the upper left-hand corner of the screen. In other words, the selected cell is on the screen, but the pop-up is off the screen (in some netherland to the right). Is there a way to do this so the form is visible, or do I have to select another startup position property such as Center Owner, and forego the custom positioning?

 

[GTO]

Hi there,

I'm about to logo out, but for any 'answerer', maybe post (using code tags) the current code?

Mark

 

[Norie]

If you want to position a userform at a certain location, perhaps based on the active cell, then add code in it's Initialize event.

 

[quackdad]

Here's one example

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    If Not Intersect(Target, Range("E15:E507")) Is Nothing Then
        If Range("C1") = "" Then
            ViewTopic.Move ActiveCell.Left + Application.Left + 0, ActiveCell.Top + Application.Top + 55
            ViewTopic.Show
        End If
    End If
End Sub

I've tried adding Target.Select, to no avail