User Form Frame size
Is there a way to auto size a UserForm Frame ?
I have code that takes names off a worksheet and adds a bit to it, but
if the name is long.. the frame cuts it off.
Here is my code that captures the name from the sheet..
Private Sub UserForm_Initialize()
Frame2.Caption = Worksheets("Block").Cells(3, 2).Value + "'s Average"
End Sub
Thanks a bunch!
Joe Derr
|