TheSwamp

Code Red => VB(A) => Topic started by: andrew_nao on June 26, 2013, 10:27:20 AM

Title: vb code for excel
Post by: andrew_nao on June 26, 2013, 10:27:20 AM

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

Title: Re: vb code for excel
Post by: Matt__W on June 26, 2013, 11:04:00 AM

Damn, that search dialog box looks REALLY familiar.  Where have I seen that before (http://www.theswamp.org/index.php?topic=37905.msg429409#msg429409)?  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?

Title: Re: vb code for excel
Post by: andrew_nao on June 26, 2013, 11:14:39 AM

Quote from: M@yhem on June 26, 2013, 11:04:00 AM

Damn, that search dialog box looks REALLY familiar.  Where have I seen that before (http://www.theswamp.org/index.php?topic=37905.msg429409#msg429409)?  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?

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

Title: Re: vb code for excel
Post by: andrew_nao on July 03, 2013, 04:43:41 PM

any help ?

Title: Re: vb code for excel
Post by: andrew_nao on July 23, 2013, 11:19:35 AM

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

thanks

Title: Re: vb code for excel
Post by: CADDOG on July 23, 2013, 03:30:58 PM

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

Title: Re: vb code for excel
Post by: andrew_nao on July 24, 2013, 09:14:07 AM

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

Title: Re: vb code for excel
Post by: Matt__W on July 24, 2013, 10:12:56 AM

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

Title: Re: vb code for excel
Post by: andrew_nao on July 24, 2013, 01:33:57 PM

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

Title: Re: vb code for excel
Post by: Matt__W on July 24, 2013, 02:04:26 PM

Quote from: andrew_nao on July 24, 2013, 01:33:57 PM

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

:?

Title: Re: vb code for excel
Post by: andrew_nao on July 24, 2013, 03:21:27 PM

Quote from: M@yhem on July 24, 2013, 02:04:26 PM

Quote from: andrew_nao on July 24, 2013, 01:33:57 PM

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

:?

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

Title: Re: vb code for excel
Post by: Matt__W on July 24, 2013, 03:23:48 PM

It can be done it's just that.....  Well... that's a LOT of information to display in the search results dialog box.  Is it necessary??  Why not just use the regular search function at that point?

Title: Re: vb code for excel
Post by: andrew_nao on July 25, 2013, 01:06:03 PM

Quote from: M@yhem on July 24, 2013, 03:23:48 PM

It can be done it's just that.....  Well... that's a LOT of information to display in the search results dialog box.  Is it necessary??  Why not just use the regular search function at that point?

because when you have 6000+ rows and you try to search for a keyword, it displays TOO much info

can you change it to read A to D?

Title: Re: vb code for excel
Post by: Matt__W on July 26, 2013, 10:40:49 AM

Try this one.

Title: Re: vb code for excel
Post by: andrew_nao on July 30, 2013, 10:42:36 AM

when the info is on another sheet
i get a run time error '1004':
application-defined or object-defined error