paste value from vba into cell

G

Guest

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
 
G

Guest

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

Using MyValue in SaveAs Fname 3
Automatic Protecting Question 2
Select variable range 1
Loop Check for Workbooks already open 2
Copy FROM - TO Object/Block variable not set 6
how to store user responses 2
Validatio Problem 1
paste is too fast 2

Top