try this:
UserForm1.TextBox1.Value =
excel.application.activewindow.activesheet.range.( "A1").Value


tomro1 wrote:
Wrote:
It is possible to change the name of the sheet in the VBE environment
under the properties of the worksheet object. This name is different
from the name you give a sheet via the tab in excel. Normally the
first
sheet can always be referenced as "sheet1" unless the internal name
has
been altered. To check this go to the VBE and look at the properties
box for the sheet you need to work with. The first property listed
will
be (name) and it's value is what you want to use in place of "sheet1".
In the future I would avoid changing this name property unless you
really need to (if that turns out to be the problem)

Hope this helps.
[/url]

i used the proper names but the formula didn't work, so tried something
else, and nog its works


Worksheets("sheet1").Activate
Range("a1").Select
TextBox1.Text = ActiveCell.Value


--
tomro1
------------------------------------------------------------------------
tomro1's Profile: http://www.excelforum.com/member.php...o&userid=35081
View this thread: http://www.excelforum.com/showthread...hreadid=548293[/color]