Results 1 to 15 of 15

Search box possibilities

Threaded View

smudgers9 Search box possibilities 12-28-2017, 08:51 AM
Sintek Re: Search box possibilities 12-28-2017, 08:53 AM
smudgers9 Re: Search box possibilities 12-28-2017, 09:01 AM
Sintek Re: Search box possibilities 12-28-2017, 09:05 AM
smudgers9 Re: Search box possibilities 12-28-2017, 10:59 AM
Sintek Re: Search box possibilities 12-28-2017, 11:23 AM
smudgers9 Re: Search box possibilities 12-28-2017, 12:42 PM
Sintek Re: Search box possibilities 12-28-2017, 12:49 PM
smudgers9 Re: Search box possibilities 01-02-2018, 10:56 AM
nigelog Re: Search box possibilities 01-02-2018, 12:22 PM
nigelog Re: Search box possibilities 01-02-2018, 12:07 PM
Sintek Re: Search box possibilities 01-02-2018, 12:28 PM
Sintek Re: Search box possibilities 01-02-2018, 12:25 PM
nigelog Re: Search box possibilities 01-02-2018, 12:29 PM
smudgers9 Re: Search box possibilities 01-03-2018, 05:29 AM
  1. #4
    Forum Guru Sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2019 | 2021
    Posts
    14,957

    Re: Search box possibilities

    Option Explicit
    Private Sub Worksheet_Change(ByVal Target As Range)
        Dim ws As Worksheet, rng As Range
        If Not Intersect(Target, Range("A1")) Is Nothing Then
            For Each ws In ThisWorkbook.Sheets
                If ws.Name <> ActiveSheet.Name Then
                    With ws.UsedRange
                        Set rng = .Find(Target, LookIn:=xlValues, lookat:=xlWhole)
                        If Not rng Is Nothing Then Application.Goto rng
                    End With
                End If
            Next ws
        End If
    End Sub
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. All possibilities for two tables?
    By SILENTBRONCO in forum Excel General
    Replies: 4
    Last Post: 06-21-2016, 07:36 PM
  2. New to the Possibilities of Excel
    By Old4xford in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 04-09-2014, 01:11 AM
  3. Vlookup & Sum if possibilities
    By dcad81 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-26-2013, 06:00 PM
  4. Replies: 2
    Last Post: 04-11-2013, 08:27 PM
  5. An if statement for more than two possibilities
    By percivaltroy in forum Excel General
    Replies: 2
    Last Post: 05-25-2009, 04:29 AM
  6. [SOLVED] Excel/VBA possibilities
    By The Alltime Best in forum Excel General
    Replies: 2
    Last Post: 04-30-2006, 04:25 PM
  7. Thousands of possibilities
    By sharkfoot in forum Excel General
    Replies: 5
    Last Post: 03-27-2006, 12:15 AM

Tags for this Thread

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