VBA Newbie - linking to other sheets...

[Patience]

Hey y'all. I am working my way through Excel VBA in Easy Steps by Ed Robinson, and the amazing thing is, some of it is sticking in my head. The question I have is, in the following simple test code, what do I need to add to make the 't' (the string) something from a different worksheet, for the sake of argument, Book1Sheet1CellA1? What are the letters needed in place of "t = Range("A1")"

Thanks in advance. I can't find it in the book.

Private Sub CommandButton1_Click()
Dim t As String
t = Range("a1")
MsgBox t
End Sub

 

[Richard Schollar]

Hi Patience

You need to prefix the Range with the source workbook/worksheet:

Private Sub CommandButton1_Click() 
Dim t As String 
t = Workbooks("Book1.xls").Sheets("Sheet1").Range("a1") 
MsgBox t 
End Sub

Check the naming on the source, as it will only end in .xls if it has been already saved.

 

[Patience]

That's absolutely super. Thank you for that!