View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
tango tango is offline
external usenet poster
 
Posts: 45
Default 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