assign value to cell in another worksheet
 

dear all,
when i click the button the word sample will appear in a cell in other
worksheet. below is lacking the info. Pls help


Private Sub CommandButton_Click()

Range("D2").Value = "Sample"

End Sub

assign value to cell in another worksheet
 

In your code the word sample is placed in the active sheet.

To place the word sample in a specafic sheet use

Sheets("sheet1").range("d2").value = "sample"

or

workSheets("sheet1").range("d2").value = "sample"

You can also specify a workbook by

workbook("book1").Sheets("sheet1").range("d2").val ue = "sample

--
mudrake
-----------------------------------------------------------------------
mudraker's Profile: http://www.excelforum.com/member.php...nfo&userid=247
View this thread: http://www.excelforum.com/showthread.php?threadid=26945

assign value to cell in another worksheet
 

Hi
see your other post

--
Regards
Frank Kabel
Frankfurt, Germany

"tango" schrieb im Newsbeitrag
...
dear all,
when i click the button the word sample will appear in a cell in
other
worksheet. below is lacking the info. Pls help


Private Sub CommandButton_Click()

Range("D2").Value = "Sample"

End Sub