Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old October 28th 04, 01:41 PM
Mcasteel
 
Posts: n/a
Default VBA: Return Searched Value Inputed by End-User


Im trying to look up a specific SSN from Column F. The End-User will
input a Customer SSN that they are looking for into a text box
(txtCustSSN).

If the SSN is found, I want to return the customers Lname, Fname,
Info1, and Info2 back to my customized form. If the SSN is not found I
want to return msgbox "Customer Data not Found".

_Data:_
Column A = Date
Column B = Type
Column C = Lname
Column D = Fname
Column E = Mname
Column F = SSN
Column G = Info1
Column H = Info2

ANY IDEAS ON HOW TO SEARCH A COLUMN OF OR 300+ SSN'S TO \"MATCH\" THE
SSN THAT THE END-USER INPUTS INTO THE TEXT BOX TXTCUSTSSN?

Ive been having a really hard time with this, please respond with as
much info as you can.

Thank you!


--
Mcasteel
------------------------------------------------------------------------
Mcasteel's Profile: http://www.excelforum.com/member.php...o&userid=15698
View this thread: http://www.excelforum.com/showthread...hreadid=273165


  #2   Report Post  
Old October 28th 04, 03:09 PM
Frank Kabel
 
Posts: n/a
Default

Hi
use a INDEX / MATCH combination. Do you need a VBA solution?. If yes use
application.index and application.match

"Mcasteel" wrote:


Im trying to look up a specific SSN from Column F. The End-User will
input a Customer SSN that they are looking for into a text box
(txtCustSSN).

If the SSN is found, I want to return the customers Lname, Fname,
Info1, and Info2 back to my customized form. If the SSN is not found I
want to return msgbox "Customer Data not Found".

_Data:_
Column A = Date
Column B = Type
Column C = Lname
Column D = Fname
Column E = Mname
Column F = SSN
Column G = Info1
Column H = Info2

ANY IDEAS ON HOW TO SEARCH A COLUMN OF OR 300+ SSN'S TO \"MATCH\" THE
SSN THAT THE END-USER INPUTS INTO THE TEXT BOX TXTCUSTSSN?

Ive been having a really hard time with this, please respond with as
much info as you can.

Thank you!


--
Mcasteel
------------------------------------------------------------------------
Mcasteel's Profile: http://www.excelforum.com/member.php...o&userid=15698
View this thread: http://www.excelforum.com/showthread...hreadid=273165




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot Table Zero Value jcliquidtension Excel Discussion (Misc queries) 12 January 13th 05 05:21 AM
Data Entry Alert in User Form Kev Excel Discussion (Misc queries) 6 January 8th 05 04:01 PM
User defined charts- font size too small Bill B Charts and Charting in Excel 1 December 30th 04 07:23 PM
Columns in Excel will not allow user to click in them Kim Excel Discussion (Misc queries) 1 December 28th 04 07:37 PM
File is locked for Editing by user problem Mirth Excel Discussion (Misc queries) 1 December 3rd 04 05:45 PM


All times are GMT +1. The time now is 02:17 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017