Put the value in a Label on that userform?
Or put it in a textbox that's not enabled??

Option Explicit
Private Sub UserForm_Initialize()
Me.Label1.Caption = Worksheets("sheet1").Range("h96").Value 'text???
'or
With Me.TextBox1
.Value = Worksheets("sheet1").Range("h96").Value 'text???
.Enabled = False
End With
End Sub
Peter wrote:

Hello,
I would just like to know if there is a way through VBA to retrieve data
from a cell and copy that back into a userform, and set it so that data
cannot be modified on the userform.
The data in question resides in a single cell at "H96" , and needs to be
read into the userform when it is first activated.

Thanks
Peter

--

Dave Peterson