assign value to cell in another worksheet

  • Thread starter Thread starter tango
  • Start date Start date
T

tango

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
 
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").value = "sample
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

assign value to cell in other worksheet 1
VBA set thick borders around non empty cells in range 0
Run Macro If Cell have "x" value 0
Arrays and scattered cell values or another way? 16
Write to intersect of a row and column 7
Hidden sheet bleeds through 3
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Find value of active cell in other visible worksheets 8

Back
Top