i have a problem
the code worked perfectly,but i want to put in another button to follow on
..i tried this and the text from the first command button was deleted and the
text from the second commmand button was displayed i need these to follow on
thank you john

"john tempest" wrote:

thankyou tom that worked perfectly

"Tom Ogilvy" wrote:

Private Sub Commandbutton1_click()
worksheets("Sheet2").Textbox1.Text = _
Worksheets("Sheet1").Range("B9").Text
End sub

Assuming the textbox is from the control toolbox toolbar as is the
commandbutton.

--
Regards,
Tom Ogilvy


"john tempest" wrote:

is it possible using a command button to copy text from a cell in sheet1 and
paste it into a text box in sheet 2
thankyou john