| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell reference to userform
-- I am just a beginner in vba programming for excel. I need to show the number of a specific cell in the textlabel on my form. How do i get the number to be shown? Thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Cell reference to userform
Use this event in the Userform module
Private Sub UserForm_Initialize() Me.Label1.Caption = Sheets("Sheet1").Range("A1").Value End Sub It runs when you open the userform -- Regards Ron de Bruin http://www.rondebruin.nl "Jens Peter Nielsen" wrote in message ... -- I am just a beginner in vba programming for excel. I need to show the number of a specific cell in the textlabel on my form. How do i get the number to be shown? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| absolute cell reference A spreadsheet cell reference that does no | Excel Discussion (Misc queries) | |||
| Reference a cell in a worksheet from a userform | Excel Programming | |||
| problem with cell reference in =sum(offset(cell reference,x,y,z,a)). Want cell ref to be variable. | Excel Worksheet Functions | |||
| Problem with =sum(offset(cell reference,w,x,y,z). I want cell reference to be variable | Excel Worksheet Functions | |||
| Userform cell reference help | Excel Programming | |||
Linear Mode
