Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Textbox - search
I dont know how to do one thing.
I have filled column with some data (text). i would like to create a search module. in one textbox i want to enter letters and in another textbox (or list) i want to see first matched name. example: 1 aaaaaa 2 aaabbb 3 abbccc 4 aabbaa if i enter a i would like to see 1 if i enter aaab i would like to see 2 i dont want to enter the whole phrase to see matched cell. please help me thanks in advice |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Textbox - search
Look at the find command
Dim rng as Range set rng = Range("A1:A500").find(what:=Textbox1 & "*", _ After:=Range("A65536"), Lookin:=xlValues, _ Lookat:=xlWhole, SearchOrder:=xlbyColumn, _ SearchDirection:=xlNext, MatchCase:=False) if not rng is nothing then textbox2.Value = rng.row Else textbox2.value = 0 End if -- Regards, Tom Ogilvy Greg wrote in message om... I dont know how to do one thing. I have filled column with some data (text). i would like to create a search module. in one textbox i want to enter letters and in another textbox (or list) i want to see first matched name. example: 1 aaaaaa 2 aaabbb 3 abbccc 4 aabbaa if i enter a i would like to see 1 if i enter aaab i would like to see 2 i dont want to enter the whole phrase to see matched cell. please help me thanks in advice |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculate Textbox value based on another textbox value.doc | Excel Discussion (Misc queries) | |||
Calculate Textbox value based on another textbox value | Excel Discussion (Misc queries) | |||
How do I search and replace text in a textbox in Excel? | Excel Discussion (Misc queries) | |||
How do I do a search and replace in a textbox in Excel? | Excel Discussion (Misc queries) | |||
UserForm TextBox to ActiveSheet TextBox over 256 characters | Excel Programming |