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