Results 1 to 7 of 7

VBA -searching using range of values

Threaded View

  1. #1
    Registered User
    Join Date
    10-07-2008
    Location
    Singapore
    Posts
    11

    Question VBA -searching using range of values

    Hi i will appreciate any help rendered!

    scenario:
    I have a value X in cell B5 and a Value Y in cell B6, in multiple worksheets
    In my userform, i have 2 comboboxes
    one holding value ranges for the x coordinaate (eg 0-10, 11-20,21-30)
    the other holding values for the y coordinate (eg 0-10, 11-20,21-30)

    i want the user to be able to select a range from the x coordinate and the y coordinate...then i want to search thru all the B5 n B6 cels across the worksheets and return those worksheets that match the users input...

    is it possible for this to be done?
    Last edited by ACOM; 05-16-2009 at 03:59 PM.

Thread Information

Users Browsing this Thread

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

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