If you used a ListBox, you could use the AddItem method ot increment the
list. Unfortunately, the TextBox does not accomodate the add item method. I
did think it would acknowledge a line feed, but apparently, the one from the
control tool box doesn't do that either. Unless you intend to have the user
type into or delete from the text box, I would give some serious
consideration to using the ListBox.

" wrote:


I'm using excel 2003, and I have a userform that needs to gather data,
there are 10 different textboxes
Some of them will have information on the sheet, i just dont know how
to make it search find the cell, save what row its on then increment
the columns, pull the data from the cells and put them into the
textbox i was thinking maybe do a
double loop where you set a high level loop to count through the
rows, then the second loop inside that one that would count through
the cells? But I'm not really sure how to do that :|

On Oct 22, 12:45 pm, dan dungan wrote:
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?- Hide quoted text -

- Show quoted text -