Cutting entered data in a textbox into pieces automatically

[Sietske]

How to cut entered data in a textbox into pieces?

I want to make a search form, which can search multiple words at a time in a
memo field. E.g. when a record contains "I am a moron because I know too
little about VBA", and you fill in "little moron VBA", that you can still
find it. The best thing I can think of, is cutting the search entry into
pieces, but how to do it, considered that the space is the place to cut?

 

[Pieter Wijnen]

The split function is usefull for this kind of thing

Pieter

 

[Sietske]

Thanks! The split function, followed by a For Each-loop works very well now!