Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA: Extracting Range from worksheet and inserting into userform
_What_is_the_\"ME\"_in_your_recommended_solution?_ It looks like thi will probably work for what Im doing. Im just not sure If I understan what the ME. is. and 2nd.... ANYONE HAVE AN IDEA ON HOW TO SEACH AND RETREIVE THAT CUSTSSN FROM COLUMN OF 300 OR MORE CUSTSSN'S Thanks again, this is a a great site, Im glad I came across it -- Mcastee ----------------------------------------------------------------------- Mcasteel's Profile: http://www.excelforum.com/member.php...fo&userid=1569 View this thread: http://www.excelforum.com/showthread.php?threadid=27226 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extracting Range from worksheet and inserting into userform
Me refers to the object that the code is being executed from, so in a
userform it refers to the form, in a worksheet it refers to that worksheet. It is a simple way of ensuring you are referring to 'this' container. What does the second part mean exactly? To search you have a customer number to search for, so do you just want the index within the customer numbers where that item is found? Something like iRow = Worksheetfunction.Match(sCustSSN, Worksheets("Sheet1").Range("A1:A300"),0) if iRow = 0 Then MsgBox "Not found" End If -- HTH RP "Mcasteel" wrote in message ... _What_is_the_\"ME\"_in_your_recommended_solution?_ It looks like this will probably work for what Im doing. Im just not sure If I understand what the ME. is. and 2nd.... ANYONE HAVE AN IDEA ON HOW TO SEACH AND RETREIVE THAT CUSTSSN FROM A COLUMN OF 300 OR MORE CUSTSSN'S? Thanks again, this is a a great site, Im glad I came across it. -- Mcasteel ------------------------------------------------------------------------ Mcasteel's Profile: http://www.excelforum.com/member.php...o&userid=15698 View this thread: http://www.excelforum.com/showthread...hreadid=272267 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inserting pictures into unprotected range in a protected worksheet | Excel Worksheet Functions | |||
VBA: Extracting Range from worksheet and inserting into userform | Excel Programming | |||
Extracting metatags from a web page and inserting them in a worksheet. | Excel Programming | |||
Extracting Colors from Image loaded in userform | Excel Programming | |||
Showing Worksheet Range in Userform | Excel Programming |