M
Mcasteel
I have 3 more questions for you regarding your solution.
1. SSN
The SSN column is formatted as "Special" / Social Security Number i
the Excel file.
When viewing the SSN: it shows with dashes (123-45-6789) but if I pul
the value from Excel into the form as a string it displays with out th
dashes (123456789) which suites my needs.
After the above experiment Im assuming the ssn is just a string or tex
and not a number.
2. Im not sure If I understand your last line of code, what is the Cln
used for?
iRow = whateveryouchose.match_(*CLNG*(_CustSSN), _
Worksheets("Sheet1").Range("f27:f307"), 0)
3. With this piece of code, I will be able to take values from th
record and display them in my form, correct?
Thanks again, Im working on trying your code right now
1. SSN
The SSN column is formatted as "Special" / Social Security Number i
the Excel file.
When viewing the SSN: it shows with dashes (123-45-6789) but if I pul
the value from Excel into the form as a string it displays with out th
dashes (123456789) which suites my needs.
After the above experiment Im assuming the ssn is just a string or tex
and not a number.
2. Im not sure If I understand your last line of code, what is the Cln
used for?
iRow = whateveryouchose.match_(*CLNG*(_CustSSN), _
Worksheets("Sheet1").Range("f27:f307"), 0)
3. With this piece of code, I will be able to take values from th
record and display them in my form, correct?
Thanks again, Im working on trying your code right now