VBA MsgBox Query

[EwEn999]

When I'm entering a Message Box in VBA, you have to enter a prompt as string, i was wondering if it possible to reference another cell within the string?

i.e. MsgBox("Employee [insert name] has two shifts scheduled for this day") where the employee's name is located in the same worksheet

 

[dmt32]

Hi,
something like this maybe

MsgBox "Employee " & Cells(4, 4).Value & " has two shifts scheduled for this day", 64, "Shifts Scheduled"

Change the range shown in RED as required.

Dave

 

[EwEn999]

Thanks, it seem so obvious now to break up the string. I'm annoyed at myself.