On Jul 30, 12:07 pm, Keith74 wrote:
Hi

I've just tested this with something in cells a1 and a2 on sheet1

Private Sub UserForm_Initialize()

TextBox1.Value = Sheets("sheet1").Cells(1, 1).Value
TextBox2.Value = Sheets("sheet1").Cells(2, 1).Value

End Sub

seems to work

Whats the problem you are having?

Hey Keith,

I actually found something on aother page that worked. It similar to
what you have here.

Me.TextBox9.Value = Worksheets("sheet2").Range("C3").Value

This worked perfectly..

Just wanted to thank you for helping.

Seamus.