Can it be possible to use sheet cell values as captions (lables) in user forms
T TUNGANA KURMA RAJU Jul 24, 2006 #1 Can it be possible to use sheet cell values as captions (lables) in user forms
R Ron de Bruin Jul 24, 2006 #2 Hi TUNGANA Yes, when you open the userform you can add code in the Initialize event Private Sub UserForm_Initialize() Me.Label1.Caption = Sheets("sheet1").Range("A1").Value End Sub
Hi TUNGANA Yes, when you open the userform you can add code in the Initialize event Private Sub UserForm_Initialize() Me.Label1.Caption = Sheets("sheet1").Range("A1").Value End Sub
