Hey guys,

Im searching for vba code for custom position userform example below

I do some reading from this website, but cant understand it...

http://cpearson.com/excel/FormPosition.htm

Hopefully someone can enlighten me...

What im expecting is, form will fixed position to which cell im preferred. This form also I already make it start once i open excel file..
Let say i want something like below...

9gafr7c.png

from http://cpearson.com/excel/FormPosition.htm
cstFhpFormRightCellLeft = right edge of form at left edge of cell
cstFvpFormBottomCellBottom = bottom edge of form at bottom edge of cell

and should be something like this?

Private Sub UserForm_Open()

    CallNumberUserForm.Show
     Dim PS As Positions
     CallNumberUserForm.StartupPosition = 0
     PS = PositionForm(CallNumberUserForm, Range("H5"), 0, 0, cstFhpFormRightCellLeft, cstFvpFormBottomCellBottom)
     CallNumberUserForm.Top = PS.FrmTop
     CallNumberUserForm.Left = PS.FrmLeft
     CallNumberUserForm.Show vbModal
End Sub
its not working...