| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Custom MsgBox using values from 2 different cells
thanx, worked like a charm
"J.E. McGimpsey" wrote in message ... one way: With Sheets("Team Data") MsgBox "Stat entered successfully into Column " & _ .Range("X2").Value & "." & vbNewLine & _ "There are currently " & .Range("W3").Value & _ " remaining locations" End With In article , "Todd Huttenstine" wrote: I need to create a custom Message Box that has only an OK button. On Sheet1 named Team Data, in cell X2 I have a Letter. This is a letter of a Column. On Sheet1 named Team Data, in cell W3 I have a Number. The MsgBox will use the values in these 2 cells. Assuming the value of cell X2 is "V" and the value of cell W3 is 5, I want the MsgBox to say... "Stat entered successfully into Column V." then on next line of MsgBox I want it to use the value of cell W3. It should say... There are currently 5 remaining locations" Thanx in advance Todd Huttenstine |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Custom MsgBox | Excel Worksheet Functions | |||
| Macro display Msgbox when cells are empty | Excel Discussion (Misc queries) | |||
| msgBox sum values | Excel Discussion (Misc queries) | |||
| Validate MsgBox Entry to Data in Cells | Excel Discussion (Misc queries) | |||
| format values in MsgBox? | Excel Programming | |||
![Todd Huttenstine[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
