Just to add to Michael M's response...

..text tells excel to show what appears in the cell.

..value will return the value of the cell. So if your cell contains a date that
contains a special format (maybe a long date: mmmm dd, yyyy), you may really
want .text instead of .value.



pcor wrote:

Thanks for the VERY fast response but......
location u12 is not text but a formula that displays a date
Appreciate all the help
pcor

"Dave Peterson" wrote:

You can use a macro:

Option Explicit
Sub Auto_Open()
msgbox thisworkbook.worksheets("Sheet9999").range("u12"). text
End Sub

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

pcor wrote:

Here is what I would like: Open the Excel file and the first thing I would
see is a message box that tells me what is located in cell u12
Thanks
pcor

--

Dave Peterson


--

Dave Peterson