| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
paste value from vba into cell
i have the following script working , but need help on pasting value into
another sheet in this workbook, any help would be welcome. Thank You Dim texzt as String Private Sub cmdReport_Click() Message = "Please Enter the Report Date" Title = "Report Date Input Form" Default = Date MyValue = InputBox(Message, Title, Default) texzt = MyValue Workbooks("SOUTH CROSS BAYOU - DOR11").Sheets("SCBPg1").Range("D1") = texzt End Sub |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
paste value from vba into cell
Dim MyStr As String
MyStr = "kjkjkj" Sheets("Sheet2").Select Range("A1").Formula = MyStr Sheets("Sheet2").Select Range("A1").Formula = MyStr "Mark J" wrote: i have the following script working , but need help on pasting value into another sheet in this workbook, any help would be welcome. Thank You Dim texzt as String Private Sub cmdReport_Click() Message = "Please Enter the Report Date" Title = "Report Date Input Form" Default = Date MyValue = InputBox(Message, Title, Default) texzt = MyValue Workbooks("SOUTH CROSS BAYOU - DOR11").Sheets("SCBPg1").Range("D1") = texzt End Sub |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I copy a value from a cell and paste it into another cell while adding it to the previous value in that cell | Excel Worksheet Functions | |||
| Password Protection - paste to unprotected cell locks the cell | Excel Discussion (Misc queries) | |||
| Macro to paste in the active cell the contents of a cell from another file?? | Excel Programming | |||
| Paste Link enters a 0 into the cell where I paste. How do I elemin | Excel Discussion (Misc queries) | |||
| Copy and Paste macro needs to paste to a changing cell reference | Excel Programming | |||
Linear Mode
