Results 1 to 8 of 8

Question regarding vba search capabilities

Threaded View

  1. #1
    Valued Forum Contributor
    Join Date
    03-17-2007
    Location
    Michigan
    MS-Off Ver
    Excel 2016
    Posts
    957

    Question regarding vba search capabilities

    I would be greatly appreciative with any assistance or advice one could give regarding the following: I've attached a small sample workbook of what I'm trying to accomplish as it pertains to searching for individual phone and/or direct connect records. I could potentially have thousands of different phone numbers (some of which could be matching over several months worth of data) as well as direct connect numbers. Using a simple filter button for any particular column would contain to many numbers for me to easily identify the number I'd be looking for to filter and would be very time consuming. I started to create a user form for what I'd like to open up via a macro type activation button, which would allow me to search either by phone number or direct connect number. I however am not very knowledgable with vba to get this to work and any assistance would be greatly appreciated. My thought, if possible would be to have whatever number (either phone or direct connect number) that is typed in the user form and after the search button his clicked, attempt to locate the number via the filtering function and if found automatically filter it by unchecking all of the others non-applicable numbers in either column B or C. Due to having incoming and outgoing numbers the code would have to look at data in columns "B6 and below" and "C6 and below" while maintaining the integrity of the other column data affiliated with each number. I hope this makes sense!

    Thanks to anyone willing to take the time to look at this!
    Attached Files Attached Files
    Last edited by lilsnoop; 02-08-2009 at 04: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