For giggles,

what would the code be for reconstruction the text inserted in th
column back into a text box in a form?

I enter "See spot run." into the text box in Userform1 above and pres
comman button.

In A1:A6 =

A1 See
A2
A3 spot
A4
A5 run
A6 .
_______________
Now in Userform2, in Textbox2, how do we reconstruct "See spot run." i
Textbox2

--
Message posted from http://www.ExcelForum.com