MsgBox refer to seperate worksheet

Prev: MsgBox refer to seperate worksheet
Next: Passing dates to Sql Server 2005 stored procedure

From: Chris on 7 Jun 2010 05:42

---

Hi - I need to set up a message box that will read a cell on another
worksheet. The button for the msgbox (an where I want it to pop up) is on
the Questions worsheet. The code I have is below;

Sub Message()
Dim txtScore As String

txtScore = Worksheet("Calculations").Range("G2").Select

MsgBox "Your Score is", vbInformation & txtMaturityScore, "Risk Score"

End Sub

 | 
Pages: 1
Prev: MsgBox refer to seperate worksheet
Next: Passing dates to Sql Server 2005 stored procedure