Hi.
I was wondering how to get the find function working in forms.
On a spreadsheet it's fine. I just type in:
=Find("what-Eh-verrr",B5,1)
and it will look in cell B5 for the string: what-Eh-verrr
If it finds it then it returns the position of 'what-Eh-verrr' within B5.
E.g. B5 contains "yeah you guys - what-Eh-verrr" then the find function will count 17 characters. There are 16 characters before 'what-Eh-verrr', and for some reason it counts the string 'what-EH-verrr' as 1 as well.
Now I have a TextBox on a UserForm containing the immortal lines from the cartoon South Park:
'[Stan:] Cartman, you have a satellite dish coming out of your anus.
[Cartman:] Yeah you guys - what-Eh-verrr.'
I want to count the number of characters before the 'whatever'. There must be a way to do it. Unfortunately my brain is small.
I have tried:
x = Find("whatever", TextBox1,1)
but the computer stares at me coldly and says "find? that's not a word!"
Please help!
Bookmarks