Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
MsgBox refer to seperate worksheet
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
MsgBox refer to seperate worksheet
Sub msgboxfromothersheet()
MsgBox "Your score is " & sheets("Calculations").Range("G2") End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software "Chris" wrote in message ... 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 | |||
MsgBox refer to seperate worksheet | Excel Programming | |||
Refer to a named range in a seperate workbook | 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) |