Another newbie question:

I can't figure out how to copy text from a particular cell on Sheet1
and paste it into my text box, everything I've tried hasn’t worked. The
idea is so the user can edit the text without having to retype it.

I can copy text from the text box but cannot retrieve it, here's what I
have so far.


Private Sub cmdSave_Click()
Dim ws1 As Worksheet
Dim ws2 As Worksheet
Set ws1 = Worksheets("Names Birth Dates")
Set ws2 = Worksheets("BDS Under Construction")

'Retrieve text from the correct cell location.

'copy text back to the same cell location.
ws1.Cells((ws2.Cells(2, 87)) - 3, 3) = Me.BdayText.Value

End Sub


Any comments are greatly appreciated.

Matt


--
Flintstone
------------------------------------------------------------------------
Flintstone's Profile: http://www.excelforum.com/member.php...o&userid=15310
View this thread: http://www.excelforum.com/showthread...hreadid=552797