Can I set where a userform shows on the sheet?

[tonywatsonhelp]

Hi everyone,
I have a userform that pops up when you click on column C any row,
but it shows up in the middle of the page can i tell it to show next to the cell ?

Thanks

Tony

 

[Waimea]

Hi,

you can. I havent' tried it myself but look at https://www.mrexcel.com/forum/excel-questions/671108-userform-startup-position.html

 

[MickG]

Try something like below:-

Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel As Boolean)
Cancel = True
If Target.Column = 3 Then
    With UserForm1
        .Show vbModeless
        .Left = Selection.Left + Target.Width
        .Top = Selection.Top + .Height
    End With
End If
End Sub

 

[tonywatsonhelp]

Thank you MickG
Exactly what i needed

 

[tonywatsonhelp]

Oops, I found a problem,
This works great when the first column visible is A but when I scroll to the right The form still shows where the selected cell would be not where it is.
is there anyway I can say
Look at position on the screen of activecell and use that?

 

[MickG]

This May/May Not help:-
http://www.cpearson.com/excel/formposition.htm