Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
MsgBox refer to seperate worksheet
Chris,
Try it this way Sub Message() Dim txtScore As String txtScore = Sheets("Calculations").Range("G2").Text MsgBox "Your score is " & txtScore, vbInformation, " Risk Score" End Sub -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Chris" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Refer to a named range in a seperate workbook | Excel Programming | |||
Refer to a different worksheet | Excel Programming | |||
How to get evaluated value of worksheet names that do not refer to worksheet ranges? | Excel Programming | |||
How do I have seperate headers for seperate pages in 1 worksheet? | Excel Discussion (Misc queries) | |||
Refer to seperate workbook for validation list for drop downs? | Excel Discussion (Misc queries) |