Fredrik1987
Board Regular
- Joined
- Nov 5, 2015
- Messages
- 69
Hi!
I'm wondering if there's a way to create a simple VBA code that interprent a name, indifferently it starts with a capital letter or not. I've been searching around a little, and haven't really found anything.
For instance:
Column A consist of names (Hans, Gretel etc.). Where each name correspons to a value in column B (1, 2... etc.)
What I want the script to understand, is that if I insert "hans" instead of "Hans", the meaning are the same.
Also, is there a way to include misspelling (e.g. ahns instad of Hans)
<tbody>
</tbody>
This is just a simplified example of a large script, I think I read somewhere that it is possible to script in such a way that VBA only looks for the letters in a word, indepent of their arragement?
I'm wondering if there's a way to create a simple VBA code that interprent a name, indifferently it starts with a capital letter or not. I've been searching around a little, and haven't really found anything.
For instance:
Column A consist of names (Hans, Gretel etc.). Where each name correspons to a value in column B (1, 2... etc.)
What I want the script to understand, is that if I insert "hans" instead of "Hans", the meaning are the same.
Also, is there a way to include misspelling (e.g. ahns instad of Hans)
Column A | Column B |
Hans | 1 |
hans | 1 |
ahns | 1 |
<tbody>
</tbody>
This is just a simplified example of a large script, I think I read somewhere that it is possible to script in such a way that VBA only looks for the letters in a word, indepent of their arragement?
Last edited: