paste value from vba into cell

M

Mark J

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
 
P

pgchop

Dim MyStr As String
MyStr = "kjkjkj"
Sheets("Sheet2").Select
Range("A1").Formula = MyStr
Sheets("Sheet2").Select
Range("A1").Formula = MyStr
 

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

Copy FROM - TO Object/Block variable not set 6
Automatic Protecting Question 2
how to store user responses 2
Using MyValue in SaveAs Fname 3
simplify date input 0
Loop Check for Workbooks already open 2
how to add a textbox if user chooses yes in response to msgbox. 0
Select variable range 1

Top