Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Userforms in Excel 2003
How do I draw information from a cell within Excel and add it to a
label/caption on a Userform? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Userforms in Excel 2003
Like this, have to include the sheet
Private Sub UserForm_Activate() UserForm1.Caption = Sheets("sheet1").Cells(1, 1) End Sub -- -John Please rate when your question is answered to help us and others know what is helpful. "Elsa" wrote: How do I draw information from a cell within Excel and add it to a label/caption on a Userform? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Userforms in Excel 2003
When do you want it to happen
Say when the form is first shown In the userform module: Private Sub Userform_Initialize() me.Label1.Caption = Worksheets("Sheet2").Range("B9").Text End Sub If you wanted to link it to a cell then use a textbox. for Properties, change the specialeffect property to flat and the backcolor to menu bar and Locked to true This will make it look pretty much like a label. -- regards, Tom Ogilvy "Elsa" wrote: How do I draw information from a cell within Excel and add it to a label/caption on a Userform? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Userforms in Excel 2003 | Excel Programming | |||
Excel VBA UserForms in in Mac OS X | Excel Programming | |||
Userforms in Excel 2003 created in Excel 2000 | Excel Discussion (Misc queries) | |||
Help Userforms / Excel SUMIF | Excel Worksheet Functions | |||
Creating UserForms in Excel | Excel Programming |