View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JB2010 JB2010 is offline
external usenet poster
 
Posts: 44
Default Cell Contents as text in Msg Box

Hi


Is there any way to take the contents of a cell & add that to the text you
programme into a Msg Box in VB?


For example, lets say cell A1 has the following formula "=Now()", meaning
text that says "10/05/06 13:47"


& I want the Msg Box to read "You Logged Out At 10/05/06 13:47."

Is there a way of sinking this formula into the VB code for a Msg Box? On a
spreadsheet i would obviously use (="You Logged Out At "&A1&"."), but VB is
getting confusing!


Any help gratefully receieved


cheers


jb