Updating Text in a message boxes automatically

  • Thread starter Thread starter robertguy
  • Start date Start date
R

robertguy

Hi

can anyone help me please??

I'm trying to update the text in a message box automatically using th
contents of a particular cell.

e.g. the message box would say "last updated on XXXXXXX" where XXXXXX
is the contents of a particular cell (say A1)


Many thanks in advance


Ro
 
Robert,

Is this a VBA Msgbox?

If so, you could use

Msgbox "last updated on " & activesheet.range("A1").text

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Many thanks to :-

Bob Phillips

&

Rollin_Again


Both ways worked and resolved my problem i.e. to Update Text in
message box automatically


Thanks again Guys


Ro
 
Back
Top