Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
i want to assign a cell to save a worksheet | Excel Worksheet Functions | |||
Place a button on a worksheet and assign a macro to it? | New Users to Excel | |||
assign the same macro to every line in worksheet | Excel Worksheet Functions | |||
assign cell selection order in protected Excel worksheet | Excel Discussion (Misc queries) | |||
Assign a name to worksheet tabs by code | Excel Programming |