Hi friends,
Please refer below screen shot of a dictionary. if you type a data which is not available in dictionary database this dictionary donesn't show result but give spelling suggetion list like below.
same logic i want to apply in my database.
I receive orders from customer with mispellesd "Quality" Name. In this case I want a vba code which will look up very possible entry like above dictionary apply.
I can use intr or find function but it have very limited scope.
I will figure out rest such as if i want to show it userfrom or in excel. All i want to know logic.
Hope you help me.
Please refer below screen shot of a dictionary. if you type a data which is not available in dictionary database this dictionary donesn't show result but give spelling suggetion list like below.
same logic i want to apply in my database.
I receive orders from customer with mispellesd "Quality" Name. In this case I want a vba code which will look up very possible entry like above dictionary apply.
I can use intr or find function but it have very limited scope.
I will figure out rest such as if i want to show it userfrom or in excel. All i want to know logic.
Hope you help me.
