Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Jan 2002
    Posts
    142
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Using FIND results (2K)

    I posted before but couldn't resolve my issue, so here it is worded differently:
    Is there a way to use the results of a FIND to automatically trigger a macro?
    Lets suppose I have a workbook with names (text) and values, based on those
    names are associated actions: If John then do this, If Marsha then do this etc.
    At present I am using Alt-F to locate, then closing the FIND and performing
    the operation. The operation is:
    Now that you have Marsha, add the five cells to the right of her name, if greater
    than "CELL B5" insert 2 rows into workbook "2-Do" at ROW A, then copy a form
    from workbook "Forms" into workbook "2-Do" at ROW A, then copy her name and
    the five cells to workbook "2-Do" into the form, and return to the original workbook
    "Sales" at ROW 1 COLUMN A. If less than "CELL B5" add a ROW but copy only
    her name into workbook "2-Do" at the added ROW and return to the original
    workbook "Sales" at ROW 1 COLUMN A.

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Using FIND results (2K)

    No, there is no way to do what you are asking. What I would do in this case would be to include the find operation in the macro and assign the macro to a button on a tool bar. Then I could press the button, have the macro ask what I wanted to find and then go do its thing.
    Legare Coleman

Posting Permissions

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