Macro help

tidefan1214 · Mar 12th, 2002, 01:19 PM

Trying to display a message box after a macro is run to let user know the iformation was entered correctly. I am using VBA editor to do this and can prompt the user for input, and display the input, just need to know how to display a message box after this is done. Can anyone help?

Mark O'Brien · Mar 12th, 2002, 02:11 PM

For the last line of your code put in someting like this:



Msgbox "Data Updated"

HTH

tidefan1214 · Mar 12th, 2002, 02:19 PM

Thanks alot, that was just what I needed.

Mar 12th, 2002, 02:11 PM	#2
Mark O'Brien MrExcel MVP Join Date: Feb 2002 Location: Columbus, OH, USA Posts: 3,519	For the last line of your code put in someting like this: Msgbox "Data Updated" HTH __________________ Mark O'Brien Columbus Ohio Celtic Supporters Club

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

Mar 12th, 2002, 01:19 PM	#1
tidefan1214 New Member Join Date: Mar 2002 Location: Alabama Posts: 2	Trying to display a message box after a macro is run to let user know the iformation was entered correctly. I am using VBA editor to do this and can prompt the user for input, and display the input, just need to know how to display a message box after this is done. Can anyone help?

Mar 12th, 2002, 02:19 PM	#3
tidefan1214 New Member Join Date: Mar 2002 Location: Alabama Posts: 2	Thanks alot, that was just what I needed.