Tags: appear, assign, below, button, cell, click, dear, excel, lacking, microsoft, msdn, pls, private, sample, software, sub, value, word, worksheet

assign value to cell in another worksheet

On Microsoft » Microsoft Excel

1,401 words with 2 Comments; publish: Fri, 23 May 2008 06:31:00 GMT; (30646.88, « »)

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

All Comments

Leave a comment...

  • 2 Comments
    • Hi

      see your other post

      --

      Regards

      Frank Kabel

      Frankfurt, Germany

      "tango" <tangopg.excel.todaysummary.com.yahoo.com> schrieb im Newsbeitrag

      news:f678e293.0410141945.ce3ee9.excel.todaysummary.com.posting.google.com...

      > 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

      #2; Fri, 23 May 2008 06:34:00 GMT