I'm not clear. What purpose would the text box serve?

In excel 2000, I don't usually paste information into a text box
because it has a linked cell property. I don't know about later
versions.

Dan



On Oct 22, 10:18 am, wrote:
I'm having an issue if anyone could help.
I'm very new to VB/VBA and I'm trying to Search a spreadsheet for
specific text in column A,
when it finds that data make the cell that data is in the Active
cell , then move to column b the same row the data was on and
select
the text there, Then paste it to a textbox, then it would have to go
to column d and do the same, How would i go about doing this?