software

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--
saziz
------------------------------------------------------------------------
saziz's Profile: www.excelforum.com/member.php...foamp;userid=6350
View this thread: www.excelforum.com/showthread...hreadid=507869Have you tried DATA/FORM from the menu. It's a built-in data entry from with
search capability.

--
Kevin Backmannquot;sazizquot; wrote:

gt;
gt; Hi,
gt; I am wondering if I can serach for a particular entry in Excel database
gt; and edit it in a separate window. Is this possible through VB code?
gt; Please advise.
gt; Thak you
gt; Syed
gt;
gt;
gt; --
gt; saziz
gt; ------------------------------------------------------------------------
gt; saziz's Profile: www.excelforum.com/member.php...foamp;userid=6350
gt; View this thread: www.excelforum.com/showthread...hreadid=507869
gt;
gt;


Hi Kevin,
Thank you for helping me out. I checked Data Form option. It seems it
does but now I need to know how I can put into the code the search
criteria value taken from a user. I hope I am clear in explaining
this. I need opertaor to input a value for Data Form -gt; Criteria -gt;
atleast one value from the data base which I am expecting it to come
from user.
Please let me know if you can.
Thank you
Syed--
saziz
------------------------------------------------------------------------
saziz's Profile: www.excelforum.com/member.php...foamp;userid=6350
View this thread: www.excelforum.com/showthread...hreadid=507869I 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(quot;What are you looking for?quot;)

Cells.Find(What:=strFindWhat).ActivateEnd Sub

--
Kevin Backmannquot;sazizquot; wrote:

gt;
gt; Hi Kevin,
gt; Thank you for helping me out. I checked Data Form option. It seems it
gt; does but now I need to know how I can put into the code the search
gt; criteria value taken from a user. I hope I am clear in explaining
gt; this. I need opertaor to input a value for Data Form -gt; Criteria -gt;
gt; atleast one value from the data base which I am expecting it to come
gt; from user.
gt; Please let me know if you can.
gt; Thank you
gt; Syed
gt;
gt;
gt; --
gt; saziz
gt; ------------------------------------------------------------------------
gt; saziz's Profile: www.excelforum.com/member.php...foamp;userid=6350
gt; View this thread: www.excelforum.com/showthread...hreadid=507869
gt;
gt;