danbates77
New Member
- Joined
- Jan 10, 2017
- Messages
- 36
- Office Version
- 2016
Hi,
Please can someone help me?
I would like a VBA code that can look at a textbox text from a command button on the same userform and can identify a certain word.
for example:
Textbox2 text = Hello, how are you?
The trigger word is "how"
So because the word "how" is in there a message box appears saying yes.
If the word "how" doesn't appear in the textbox2 then nothing happens.
Any help would be appreciated.
Thanks
Dan
Please can someone help me?
I would like a VBA code that can look at a textbox text from a command button on the same userform and can identify a certain word.
for example:
Textbox2 text = Hello, how are you?
The trigger word is "how"
So because the word "how" is in there a message box appears saying yes.
If the word "how" doesn't appear in the textbox2 then nothing happens.
Any help would be appreciated.
Thanks
Dan