+ Reply to Thread
Results 1 to 1 of 1

Creating search box in cell - Currently using Macro 'Range to search' *HELP*

  1. #1
    Registered User
    Join Date
    02-13-2013
    Location
    South Yorkshire
    MS-Off Ver
    Excel 2010
    Posts
    13

    Angry Creating search box in cell - Currently using Macro 'Range to search' *HELP*

    I need help editing my Macro.

    The Macro currently works by pressing CTRL+F to open the search box which searches either REF1 or REF2.
    If the information is found, it copies over to the next cell to basically show its there.

    If the information is not found, It paste the data searched for in cell L4 so a label can be printed.

    What I'm trying todo:
    Remove the CTRL+F and basically run from a cell (lets say cell L18)
    How ever, When scanned the scanner basically types in the numbers then presses enter/return.

    I was wondering, Would it be possible to make it run like this.

    Select cell L18 then keep scanning until either:
    A) The list is done - nothing is missing
    B) If REF1/REF2 doesn't match, pastes that data into cell L4 for a label to be printing.

    I've tried to explain as best I can, I've added some screenshots and the macro.

    Any help is appreciated !

    A.png

    B.png

    Please Login or Register  to view this content.
    Last edited by jacko058; 01-14-2014 at 05:40 AM.

+ 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. Modify this Search Formula to search across a range of cells
    By zicitron in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-16-2013, 08:11 AM
  2. Need Help Creating Macro to Search Multiple Files
    By watchoverme in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-25-2013, 06:27 PM
  3. [SOLVED] Creating a Search Command Button (Macro)
    By pinkgold in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 03-18-2013, 01:11 AM
  4. Creating Search Macro
    By vtmickster in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-13-2009, 12:04 PM
  5. Replies: 0
    Last Post: 03-05-2009, 01:43 PM

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