Can I add a search engine to my form?

Mar 15th, 2002, 06:44 AM

I have a form which is quite huge. Is there anyway I can add a search engine to my form where the user would search for an account number, find the row where the account number is and make any necessary amendments??

Thanks

Mudface · Mar 15th, 2002, 07:11 AM

Would the Autofilter function work OK for you?

slimpickens · Mar 15th, 2002, 11:01 AM

I don't know if it would work - as I am not well versed in this Visual Basic- Could you tell me what it would do?

Carol

gplhl · Mar 15th, 2002, 11:06 AM

On Menu

Data > Filter > AutoFilter

Al Chara · Mar 15th, 2002, 11:07 AM

The following code searches for a variable called AccountNumber and activates the cell:

Cells.Find(What:=AccountNumber, After:=Range("A1"),LookIn:=xlValues, LookAt:=xlWhole, SearchOrder:=xlByColumns,SearchDirection:=xlNext, MatchCase:=False).Activate

I hope this helps.
Kind regards, Al.

Mudface · Mar 15th, 2002, 11:10 AM

It's not a visual basic function

. Try clicking on the first cell in your data list and then select Data-Filter-Autofilter from the excel main toolbar. A set of drop-down arrows should then appear. Click on an arrow in the column in which you want to find a value and either scroll down to it on the dropdown list or use a custom autofilter. This will then just show the rows you want to modify. Click back on the arrow and select All to show all your data. Might be OK for you ....

gareth · Apr 23rd, 2002, 06:02 AM

Hello there from
Ò¿Ó⌐

Suggest you use the autofilter function my friend

Mar 15th, 2002, 11:06 AM	#4
gplhl Board Regular Join Date: Feb 2002 Location: Chippenham, UK Posts: 136	On Menu Data > Filter > AutoFilter __________________ Regards, Gary Hewitt-Long

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 15th, 2002, 06:44 AM	#1
Guest Posts: n/a	I have a form which is quite huge. Is there anyway I can add a search engine to my form where the user would search for an account number, find the row where the account number is and make any necessary amendments?? Thanks

Mar 15th, 2002, 07:11 AM	#2
Mudface MrExcel MVP Join Date: Feb 2002 Location: Sunny, spring-like Hull Posts: 3,339	Would the Autofilter function work OK for you?

Mar 15th, 2002, 11:01 AM	#3
slimpickens New Member Join Date: Feb 2002 Posts: 35	I don't know if it would work - as I am not well versed in this Visual Basic- Could you tell me what it would do? Carol

Mar 15th, 2002, 11:07 AM	#5
Al Chara MrExcel MVP Join Date: Feb 2002 Location: Monterrey, Mexico Posts: 1,433	The following code searches for a variable called AccountNumber and activates the cell: Cells.Find(What:=AccountNumber, After:=Range("A1"),LookIn:=xlValues, LookAt:=xlWhole, SearchOrder:=xlByColumns,SearchDirection:=xlNext, MatchCase:=False).Activate I hope this helps. Kind regards, Al.

Mar 15th, 2002, 11:10 AM	#6
Mudface MrExcel MVP Join Date: Feb 2002 Location: Sunny, spring-like Hull Posts: 3,339	It's not a visual basic function . Try clicking on the first cell in your data list and then select Data-Filter-Autofilter from the excel main toolbar. A set of drop-down arrows should then appear. Click on an arrow in the column in which you want to find a value and either scroll down to it on the dropdown list or use a custom autofilter. This will then just show the rows you want to modify. Click back on the arrow and select All to show all your data. Might be OK for you ....

Apr 23rd, 2002, 06:02 AM	#7
gareth Board Regular Join Date: Apr 2002 Location: Cape Town,South Africa Posts: 234	Hello there from Ò¿Ó⌐ Suggest you use the autofilter function my friend