vb code for excel

andrew_nao · 发表于 2013-6-26 10:27:20

could anyone help me with this code.
if you click on the search and search for a word in the attached file, it returns just the info in that cell that it found the word.
can anyone tell me how to get it to show the whole row in the results box instead of just the cell the word was found in.
thanks

Matt__W · 发表于 2013-6-26 11:04:00

Damn, that search dialog box looks REALLY familiar. Where have I seen that before? It even has my timesheet add-in menu in there still.
Just so I understand what you're asking... if you do a search for "CRS" you'd like the results to show the product number (I'm assuming that's what it is) from the cell to the left of where "CRS" was found?

andrew_nao · 发表于 2013-6-26 11:14:39

ahhhh thats where i got it!
i had to search months of recovery backups looking for this file haha
what i am after is to not just have the code show up but the whole row. if the search word was found in cell A1 i would like cells B1, C1, D1, E1 etc to also be displayed in the results window.
ill have to bookmark this page so i dont loose this again... thanks

andrew_nao · 发表于 2013-7-3 16:43:41

any help ?

andrew_nao · 发表于 2013-7-23 11:19:35

bump still looking for this if anyone can help me out
or tell me what to change
thanks

CadDog · 发表于 2013-7-23 15:30:58

Do you want the columns in the sheet to find themselves into their own columns in the form?

andrew_nao · 发表于 2013-7-24 09:14:07

thanks for the reply
that is not necessary, im just looking for the whole row to display not just what is found in the cell
thanks

Matt__W · 发表于 2013-7-24 10:12:56

I think this might be what you're looking for??

andrew_nao · 发表于 2013-7-24 13:33:57

thank you thats the right track however i need cells the row to read from cells A to M returned.

andrew_nao · 发表于 2013-7-24 15:21:27

not possible?
right now the file you attached returns the info in cells A & B, if the other cells (C to M) had info in them can it return the info from those cells as well?
if you can provide instruction i would be more than willing to do editing
thanks again

vb code for excel

发表回复

精选推荐