|
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 |
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 |
| All times are GMT +1. The time now is 01:47 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com