Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find the Record
Hi Dears, In FoxPro to find the record we use just like the following commands. (and if found the record then rest of the fields shown in Textboxes of the userForm) Locate for xyz=mxyz if .not. found() wait wind "Record does not exist" else Field1=textbox1 Field2= Textbox2 I need the codes for Excel vba, To find the record and if found then show the fields of the table in Textboxes of UserForm Thanks in advance -- Syed Haider Ali ------------------------------------------------------------------------ Syed Haider Ali's Profile: http://www.excelforum.com/member.php...o&userid=21994 View this thread: http://www.excelforum.com/showthread...hreadid=397584 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find the Record
Syed Haider Ali wrote: Hi Dears, In FoxPro to find the record we use just like the following commands. (and if found the record then rest of the fields shown in Textboxes of the userForm) Locate for xyz=mxyz if .not. found() wait wind "Record does not exist" else Field1=textbox1 Field2= Textbox2 I need the codes for Excel vba, To find the record and if found then show the fields of the table in Textboxes of UserForm Thanks in advance -- Syed Haider Ali ------------------------------------------------------------------------ Syed Haider Ali's Profile: http://www.excelforum.com/member.php...o&userid=21994 View this thread: http://www.excelforum.com/showthread...hreadid=397584 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find the Record
Here's some old code from Tom Olgivy
Dim rng as Range set rng = Cell.find( Targetvalue) if not rng is nothing then ' found ' do something else ' not found End if see if this gets you going... -- steveB Remove "AYN" from email to respond "Syed Haider Ali" <Syed.Haider.Ali.1u4j6k_1124643937.6135@excelfor um-nospam.com wrote in message news:Syed.Haider.Ali.1u4j6k_1124643937.6135@excelf orum-nospam.com... Hi Dears, In FoxPro to find the record we use just like the following commands. (and if found the record then rest of the fields shown in Textboxes of the userForm) Locate for xyz=mxyz if .not. found() wait wind "Record does not exist" else Field1=textbox1 Field2= Textbox2 I need the codes for Excel vba, To find the record and if found then show the fields of the table in Textboxes of UserForm Thanks in advance -- Syed Haider Ali ------------------------------------------------------------------------ Syed Haider Ali's Profile: http://www.excelforum.com/member.php...o&userid=21994 View this thread: http://www.excelforum.com/showthread...hreadid=397584 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
find a record with a missing value | Excel Discussion (Misc queries) | |||
Find unique record | Excel Discussion (Misc queries) | |||
Find Record Box | Excel Discussion (Misc queries) | |||
Find record | Excel Worksheet Functions | |||
Find Record | Excel Discussion (Misc queries) |