Userforms in Excel 2003

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I draw information from a cell within Excel and add it to a
label/caption on a Userform?
 
Like this, have to include the sheet
Private Sub UserForm_Activate()
UserForm1.Caption = Sheets("sheet1").Cells(1, 1)

End Sub
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Userforms in Excel 2003 4
VBA userform Vlookup Excel 1
Changing the text of a label on a Userform 1
Frame control scroll bar 0
Set Userform label text if form is not loaded??? 3
Userform as childwindow in statusbar not redrawn when Excel window isresized 10
Designer 3
How to enumerate buttons on user form 2

Back
Top