ExcelBanter - Cell values as captions

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Cell values as captions (https://www.excelbanter.com/excel-discussion-misc-queries/100864-cell-values-captions.html)

TUNGANA KURMA RAJU

Cell values as captions

Can it be possible to use sheet cell values as captions (lables) in user forms

Ron de Bruin

Cell values as captions

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

--
Regards Ron de Bruin
http://www.rondebruin.nl

"TUNGANA KURMA RAJU" wrote in message
...
Can it be possible to use sheet cell values as captions (lables) in user forms

All times are GMT +1. The time now is 04:08 AM.