ChristineJ
Well-known Member
- Joined
- May 18, 2009
- Messages
- 771
- Office Version
- 365
- Platform
- Windows
The code below is part of code I have for entering text in a pop-up box. ColumnC is a named range. When a cell in the range is selected, the text in the strMsg appears in a pop-up box. That works fine.
I'd like to replace the "55" in the answer and instead have it automatically show the value in the cell 18 columns to the right in the same row as the cell that is selected.
Thanks.
Code:
Case Range("ColumnC").Column
If Range("A37").Value = 1 Then
strMsg = "This is test 1." & vbCr & "This is test 2." & vbCr & "ANSWER: 55"
End If
I'd like to replace the "55" in the answer and instead have it automatically show the value in the cell 18 columns to the right in the same row as the cell that is selected.
Thanks.