Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I fill a cell in a user form from a selection on same form? | Excel Discussion (Misc queries) | |||
How to attach legend frame to chart frame? | Charts and Charting in Excel | |||
size of user form | Excel Programming | |||
I am looking to see if anybody has an equivalant user form to Outlooks CONTACT form | Excel Programming |