Search & Edit in Excel Database possible?

S

saziz

Hi,
I am wondering if I can serach for a particular entry in Excel database
and edit it in a separate window. Is this possible through VB code?
Please advise.
Thak you
Syed
 
K

Kevin B

Have you tried DATA/FORM from the menu. It's a built-in data entry from with
search capability.
 
S

saziz

Hi Kevin,
Thank you for helping me out. I checked Data Form option. It seems i
does but now I need to know how I can put into the code the searc
criteria value taken from a user. I hope I am clear in explainin
this. I need opertaor to input a value for Data Form -> Criteria -
atleast one value from the data base which I am expecting it to com
from user.
Please let me know if you can.
Thank you
Sye
 
K

Kevin B

I don't know of a method that you can utilize with the built-in data form,
but a variant of the code below might work. The INPUTBOX function displays a
dialog box with the prompt you've entered and the user can fill it out.

After they click OK, it runs the line of code that performs a search for the
value that they've entered.

Sub FindMeIfYouCan()

Dim strFindWhat As String

strFindWhat = InputBox("What are you looking for?")

Cells.Find(What:=strFindWhat).Activate


End Sub
 
Top