Posted to microsoft.public.excel.programming

JMay

external usenet poster

Posts: 468

Msgbox syntax error

In my activesheet I have the value Memphis

In my code I'm try to get the Msgbox to say:

Memphis has not reported in today<<
but the following is turning red in my code window;
can someone assist?

MsgBox "Range("D1").value & " has not reported in today"

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
runtime error: syntax error or access violation	oucsester[_2_]	Excel Programming	1	May 3rd 06 05:51 PM
runtime error: syntax error or access violation	oucsester	Excel Programming	0	May 3rd 06 02:22 PM
syntax for code in MsgBox()?	Ouka[_4_]	Excel Programming	2	July 20th 05 05:18 PM
MsgBox Syntax	scott	Excel Programming	3	February 7th 05 10:04 PM
Syntax Error Runtime Error '424' Object Required	sjenks183	Excel Programming	1	January 23rd 04 09:25 AM

All times are GMT +1. The time now is 01:29 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us