| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
MsgBox containing text from cell
Sorry, I should have noticed before, the correct reference to cell F29 in VBA
is Range("F29") or Cells(29,6). Check the format of F29, it should be Date! Sub ReminderMessageOnOpening() Dim ReportType As String If ThisWorkbook.Sheets("Instructions").Range("C29") < "" Then ReportType = ThisWorkbook.Sheets("Instructions").Range("C29") If ThisWorkbook.Sheets("Instructions").Range("F29") = Date Then MsgBox ("Reminder.... Project " & ReportType & "due today") End If End If End Sub Regards, Stefi |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| MsgBox text on several lines | Excel Discussion (Misc queries) | |||
| How to center text in a msgbox | Excel Discussion (Misc queries) | |||
| Centering MsgBox text | Excel Programming | |||
| wrapping text in a pop-up box - MsgBox | Excel Programming | |||
| VBA MsgBox() Text | Excel Programming | |||
Threaded Mode
