Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Concatenation in MsgBox
Excel 2007 - this works just as I expect it to, but I would like to do a
little mo Sub HisSales() Dim intSales As Integer intSales = Range("O3") Range("O3").Select If ActiveCell.Value = 0 Then If MsgBox("He has no sales this period.", vbOKOnly, "No sales!") = vbOKOnly Then End If ElseIf MsgBox("He has " & intSales, vbOKOnly, "His sales!") = vbOK Then End If End Sub Cell O3 contains a CountIf formula which tells how many sales he has made this period, and since he currently has 9, running the code displays a message box that says, "He has 9". I would like it to say, "He has 9 sales this period." but can't figure out how to put more text after intSales. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Concatenation help | Excel Worksheet Functions | |||
Concatenation | Excel Discussion (Misc queries) | |||
Concatenation | Excel Worksheet Functions | |||
concatenation | Excel Worksheet Functions | |||
Concatenation | Excel Programming |