Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
My userform contains various text label controls which display
the contents of a row of cells. I achieve this with the following code: Private Sub Worksheet_Change (ByVal Target As Range) UserForm1.Label1.Caption = Sheet1.Range("A1").Value UserForm1.Label2.Caption = Sheet1.Range("B1").Value UserForm1.Label3.Caption = Sheet1.Range("C1").Value ' .... ' etc, etc... End Sub I was wondering, is it wise to run the above code even when my userform is not loaded??? The code above seems to work fine even when my form is NOT loaded, but I'm worried that trying to set the text of a label that doesn't exist will cause bugs later on. thank you |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Changing the text of a label on a Userform | Excel Programming | |||
Multiple fonts in a VBA UserForm label (to make XL 95 form non-modal) | Excel Programming | |||
Userform - Formating Text in a Label | Excel Programming | |||
Help! Animated gif-image in form does not show animation when form loaded | Excel Programming | |||
Label, Text and Form controls in Excel 97 | Excel Programming |