Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Search Window
I have a list of names on a worksheet. I would like to have a search box at
the top of the page. That when i type in the last name it will go to it. is that possible? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Search Window
One way is to enter the last name to find in A1 and execute the marco below;
'It will select the cell, in Col A, containing the same last name as in A1 Sub FindSelect() Dim c As Range, s As Long Range("A2:A65000").Select Set c = Selection.Find(Range("A1").Value) If Not (c Is Nothing) Then c.Select Else Range("A1").Select MsgBox "Last Name: " & Range("A1").Value & " not found!" End If End Sub "doss04" wrote: I have a list of names on a worksheet. I would like to have a search box at the top of the page. That when i type in the last name it will go to it. is that possible? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Search Window
Thats perfect!! A tow part question. If col b - j has information regarding
the person, can that be brought up in the search window also? How could i get it to show if the name is in the list more than once. Example below A B C D E F 1SEARCH WINDOW 2 NAME DOB HT WT HAIR EYES 3 DOE JOHN 10/10/09 6' 150 BRO GRN 4 I hope this makes sense? "Sheeloo" wrote: One way is to enter the last name to find in A1 and execute the marco below; 'It will select the cell, in Col A, containing the same last name as in A1 Sub FindSelect() Dim c As Range, s As Long Range("A2:A65000").Select Set c = Selection.Find(Range("A1").Value) If Not (c Is Nothing) Then c.Select Else Range("A1").Select MsgBox "Last Name: " & Range("A1").Value & " not found!" End If End Sub "doss04" wrote: I have a list of names on a worksheet. I would like to have a search box at the top of the page. That when i type in the last name it will go to it. is that possible? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Search Window
You can show the count in a message box or in a cell...
You can show the addresses of the occurrences... To search in b-j replace Range("A2:A65000").Select with Range("B2:J65000").Select but all this is already provided by the Excel Search function... "doss04" wrote: Thats perfect!! A tow part question. If col b - j has information regarding the person, can that be brought up in the search window also? How could i get it to show if the name is in the list more than once. Example below A B C D E F 1SEARCH WINDOW 2 NAME DOB HT WT HAIR EYES 3 DOE JOHN 10/10/09 6' 150 BRO GRN 4 I hope this makes sense? "Sheeloo" wrote: One way is to enter the last name to find in A1 and execute the marco below; 'It will select the cell, in Col A, containing the same last name as in A1 Sub FindSelect() Dim c As Range, s As Long Range("A2:A65000").Select Set c = Selection.Find(Range("A1").Value) If Not (c Is Nothing) Then c.Select Else Range("A1").Select MsgBox "Last Name: " & Range("A1").Value & " not found!" End If End Sub "doss04" wrote: I have a list of names on a worksheet. I would like to have a search box at the top of the page. That when i type in the last name it will go to it. is that possible? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Search Window
Thanks Sheeloo.
"Sheeloo" wrote: You can show the count in a message box or in a cell... You can show the addresses of the occurrences... To search in b-j replace Range("A2:A65000").Select with Range("B2:J65000").Select but all this is already provided by the Excel Search function... "doss04" wrote: Thats perfect!! A tow part question. If col b - j has information regarding the person, can that be brought up in the search window also? How could i get it to show if the name is in the list more than once. Example below A B C D E F 1SEARCH WINDOW 2 NAME DOB HT WT HAIR EYES 3 DOE JOHN 10/10/09 6' 150 BRO GRN 4 I hope this makes sense? "Sheeloo" wrote: One way is to enter the last name to find in A1 and execute the marco below; 'It will select the cell, in Col A, containing the same last name as in A1 Sub FindSelect() Dim c As Range, s As Long Range("A2:A65000").Select Set c = Selection.Find(Range("A1").Value) If Not (c Is Nothing) Then c.Select Else Range("A1").Select MsgBox "Last Name: " & Range("A1").Value & " not found!" End If End Sub "doss04" wrote: I have a list of names on a worksheet. I would like to have a search box at the top of the page. That when i type in the last name it will go to it. is that possible? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Missing Help Search Results Window | Excel Discussion (Misc queries) | |||
dynamic search in the Define Name window | Excel Discussion (Misc queries) | |||
The window opens in a smaller window not full sized window. | Excel Discussion (Misc queries) | |||
how to set google search window on side of excel ? | Excel Discussion (Misc queries) | |||
Resizing search results window | New Users to Excel |