Why not just do Range("D26").Copy? This puts a copy of D26 into the
clipboard for you, all you then have to do is paste into Word.

But if you need a popup textbox for some other reason, create a userform and
set its ShowModal property to False. Put a textbox on it and size it to your
liking, then use UserForm1.Textbox1.Value = Range("D26").Value to put the
cell value into the userform.
--
- K Dales


"Jack Sons" wrote:

Hi all,

At the end of my code I need a line that will let pop up a box in which I
see the content of cell D26 without halting execution of the code. (In fact
the code immediately following the needed "pop up line" is Exit Sub.) I want
to be able to higlight the text in the popped up box in order to copy it
with ctrC=ctrV to a Word document.

Your assistance will be appreciated.

Jack Sons
The Netherlands