Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access VBA Training and help » Excel VBA

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions

Excel VBA

Resolved · Medium Priority · Version 2010

Reply 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

For upcoming training course dates see: Pricing & availability

Reply 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.

Access articles

· How To Use The Analyze Table Tool In Access
· How To Make One Combo Show Values Determined By Another Combo In Access
· How To Use Concatenation In Access To Create A Custom Lookup
· Enhancing The Customer Experience With Access
· Microsoft Access Courses

Please browse our web site to find out more about
excel course, london and other Microsoft training courses.

Access tip:

Deleting duplicate records from a table

You cannot delete records tables where there duplicate records. A way around this is to create a new table which wont hold the duplicates. and then deleting the old table.

1. Use a make-table query based on this table only. IMPORTANT - Ensure that you include all of the fields from your original table or you may loose data.

2. Open the query's property sheet by using VIEW, QUERY, PROPERTIES, and set the Unique Values property to Yes

3. Because you have selected the Unique Values to Yes when you run the query, Access creates a new table without duplicate records. You can now delete the old table and rename the new one.

View all Access hints and tips