Author Topic: vb code for excel  (Read 7121 times)

0 Members and 1 Guest are viewing this topic.

andrew_nao

  • Swamp Rat
  • Posts: 566
vb code for excel
« 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

Matt__W

  • Seagull
  • Posts: 12955
  • I like my water diluted.
Re: vb code for excel
« Reply #1 on: June 26, 2013, 11:04:00 AM »
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?
Autodesk Expert Elite
Revit Subject Matter Expert (SME)
Owner/FAA sUAS Pilot @ http://skyviz.io

andrew_nao

  • Swamp Rat
  • Posts: 566
Re: vb code for excel
« Reply #2 on: June 26, 2013, 11:14:39 AM »
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?

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

  • Swamp Rat
  • Posts: 566
Re: vb code for excel
« Reply #3 on: July 03, 2013, 04:43:41 PM »
any help ?

andrew_nao

  • Swamp Rat
  • Posts: 566
Re: vb code for excel
« Reply #4 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

CADDOG

  • Newt
  • Posts: 82
  • wishbonesr
Re: vb code for excel
« Reply #5 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?

andrew_nao

  • Swamp Rat
  • Posts: 566
Re: vb code for excel
« Reply #6 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

Matt__W

  • Seagull
  • Posts: 12955
  • I like my water diluted.
Re: vb code for excel
« Reply #7 on: July 24, 2013, 10:12:56 AM »
I think this might be what you're looking for??
Autodesk Expert Elite
Revit Subject Matter Expert (SME)
Owner/FAA sUAS Pilot @ http://skyviz.io

andrew_nao

  • Swamp Rat
  • Posts: 566
Re: vb code for excel
« Reply #8 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.


Matt__W

  • Seagull
  • Posts: 12955
  • I like my water diluted.
Re: vb code for excel
« Reply #9 on: July 24, 2013, 02:04:26 PM »
thank you thats the right track however i need cells the row to read from cells A to M returned.
:?
Autodesk Expert Elite
Revit Subject Matter Expert (SME)
Owner/FAA sUAS Pilot @ http://skyviz.io

andrew_nao

  • Swamp Rat
  • Posts: 566
Re: vb code for excel
« Reply #10 on: July 24, 2013, 03:21:27 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

Matt__W

  • Seagull
  • Posts: 12955
  • I like my water diluted.
Re: vb code for excel
« Reply #11 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?
Autodesk Expert Elite
Revit Subject Matter Expert (SME)
Owner/FAA sUAS Pilot @ http://skyviz.io

andrew_nao

  • Swamp Rat
  • Posts: 566
Re: vb code for excel
« Reply #12 on: July 25, 2013, 01:06:03 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?

Matt__W

  • Seagull
  • Posts: 12955
  • I like my water diluted.
Re: vb code for excel
« Reply #13 on: July 26, 2013, 10:40:49 AM »
Try this one.
Autodesk Expert Elite
Revit Subject Matter Expert (SME)
Owner/FAA sUAS Pilot @ http://skyviz.io

andrew_nao

  • Swamp Rat
  • Posts: 566
Re: vb code for excel
« Reply #14 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