Thanks, but I'm new to this and I don't understand all of it yet. I typed
that in but it didn't do anything. Is there someplace I can read up on the
subject, possibly showing examples?


"Tom Ogilvy" wrote:

msg = "the pieman bought " & Range("A1").Text & _
" pies at the fair. Each pie had a retail value of " & _
Range("A2").Text & vbNewLine & "but our pieman" _
& " only paid " & Range("A3").Text & " per pie."
msgbox msg

--
Regards,
Tom Ogilvy


"dbizek" wrote in message
...
I'd like to take data from different tables and create a sentance.
I've built a program to quote my companys products. Each quote is typed by
a
secretary. If I could program the variables to create the sentances, it
woud
streamline the process.