message box help

slim · May 11th, 2002, 04:17 PM

I want a message box to display a message plus the following activecell.value, I also want to change to title of the box.
The help file says I can only use the full versaion of the message box if I use an expression in the prompt section.
I'm lost! How do I turn my value into an expression?
Andy

Mudface · May 11th, 2002, 04:25 PM

Try the following, substituting as necessary:-

MsgBox "The active cell value is " & ActiveCell.Value, vbOKOnly, "This is my title."

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 11th, 2002, 04:17 PM	#1
slim New Member Join Date: Feb 2002 Posts: 42	I want a message box to display a message plus the following activecell.value, I also want to change to title of the box. The help file says I can only use the full versaion of the message box if I use an expression in the prompt section. I'm lost! How do I turn my value into an expression? Andy

May 11th, 2002, 04:25 PM	#2
Mudface MrExcel MVP Join Date: Feb 2002 Location: Sunny, spring-like Hull Posts: 3,339	Try the following, substituting as necessary:- MsgBox "The active cell value is " & ActiveCell.Value, vbOKOnly, "This is my title."