98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access VBA Training and help » Excel VBA
Excel VBA
Resolved · Medium Priority · Version 2010
Thu 29 Sep 2011, 10:45Delegate Shamin said...
Shamin has attended:
Excel VBA Intro Intermediate course
Excel VBA Advanced course
Excel VBA
I need to do partial text comparision within VBA Cell, while I am looping through two lists.
Can you help me suggesting a piece code or already an existing Sub-routine.
Kind regards
Shamim Akhtar
Fri 30 Sep 2011, 07:28Trainer Anthony said...
RE: Excel VBA
Hi Shamin. I can't suggest particular code for this without seeing your data, but I would point you in the direction of the worksheet function FIND and the link below detailing the Find method in VBA. I suspect using the worksheet function in code is probably the direction you want to go with this.
http://www.ozgrid.com/VBA/find-method.htm
Hope this helps,
Anthony
Thu 6 Oct 2011: Automatically marked as resolved.
Training information:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Change caseTo change case from upper or lower case, highlight the text area, hold down the Shift key and pres F3 |
