+ Reply to Thread
Results 1 to 7 of 7

MS Excel Macro Search Help Needed

  1. #1
    Registered User
    Join Date
    11-25-2013
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    4

    MS Excel Macro Search Help Needed

    Hi,

    I have this macro, that i want to search for a different column besides the first one, however i don't know what to do. Please help..

    this is a user form 1:





    Please Login or Register  to view this content.

    What do i do? I have bolded the lines i have changed.. but still now luck. Right now it searchs for everything in column a1 but i need it to search for everything in column e, f , and g.. .using 3 other different modules. I just need an example of 1. Thanks,
    christian
    Last edited by celmassry; 11-26-2013 at 11:59 AM. Reason: code tags added per rule 3

  2. #2
    Valued Forum Contributor
    Join Date
    02-08-2012
    Location
    Newcastle, Australia
    MS-Off Ver
    Excel 2007 and Excel 2010
    Posts
    1,429

    Re: Please help regarding vb macro

    Please use code tags when pasting code to the forum. This is rule 3 of the Forum Rules.

    Thanks

  3. #3
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,810

    Re: Please help regarding vb macro

    Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

    Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

    Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



    (I have added them for you today. Please read all the forum rules and comply in the future.)
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  4. #4
    Registered User
    Join Date
    11-25-2013
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Please help regarding vb macro

    so the script is still not working.. i can change the range in this module.. but if i change it in any other module.. it still points back to rows a2-a500..even if i change the range in that module.. please help.

  5. #5
    Registered User
    Join Date
    11-25-2013
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Please help regarding vb macro

    Please Login or Register  to view this content.
    thats the other module.

  6. #6
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: Please help regarding vb macro

    ...on review of your question and your code, it is not really clear what you want to do. The part you bolded simply selects a cell, but it is not clear where you are using that selection. What is the overall purpose of the code? It may be that your code needs an overhaul rather than a tweak. Also, this may not be what you really want

    Please Login or Register  to view this content.
    because if the last row of data is row 123, you end up with a range like f2:F500123.

    Note: OP complied with request to update title
    Last edited by 6StringJazzer; 11-26-2013 at 04:55 PM. Reason: OP complied with request to update title
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  7. #7
    Registered User
    Join Date
    11-25-2013
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: MS Excel Macro Search Help Needed

    Lets try this again
    menu.png
    program.png
    1st image is the menu, second is the submenu.

    The first image, i have the option of search for bend, weld, robot, or vh part number.
    my previous code for the vh part number works fine, but the code for bend, weld and robot do not work...

    maybe one of the variables are wrong and its messing the whole thing up??
    here is an example of the bend...


    Please Login or Register  to view this content.
    Each one of these options has a module. i am not sure if i am doing this correct or if they can all just use one module.. but here is the bend module

    Please Login or Register  to view this content.
    Can someone please test this?

    Thankyou.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Macro to show Which macro didnt work in a nested macro
    By akhileshgs in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 06-10-2013, 03:21 AM
  2. Perform macro "on open" specific file- store macro in Personal Macro Workbook?
    By thompssc in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-17-2012, 12:38 PM
  3. lookup macro, solver macro, realtime macro
    By xelhelp in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-02-2011, 06:14 PM
  4. Cannot find macro error when running a macro from a macro in a diffrent workbook.
    By Acrobatic82 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-05-2010, 09:22 AM
  5. [SOLVED] Macro calling another Macro: "The macro 'Personal.xls!FindChar"
    By William Benson in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-07-2005, 09:05 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1