Since I got no answers, I'll try to clarify:

In my worksheet, I have in Cell A2 the value 10.

In my UserForm I have a textbox (TextBox1) with ControlSource set t
=A2

In UserForm_Initialize() I try to set: 'Me.TextBox1.Value = 14'.

This does not change the value. It's still 10 when I run the code.

If I however use this line
'Thisworkbook.Worksheets(1).Range("A2").Value = 14'

it works fine. Can someone please explain why?

/ phreu

--
Message posted from http://www.ExcelForum.com