Patience
Active Member
- Joined
- Mar 30, 2006
- Messages
- 275
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.
Thanks in advance. I can't find it in the book.
Code:
Private Sub CommandButton1_Click()
Dim t As String
t = Range("a1")
MsgBox t
End Sub