Instr Function

Hi,
This is a portion of a larger Save event for a userform:

On the userform the user chooses a combobox value.
If the user chooses, in this case, Sundried Tomatoes,
I would like to

1. determine if Textbox12 contains text
2. compare that text to a number of terms (jar, jarred, packed in oil)

If any of theses terms are present, to raise a MsgBox event informing the user what to do.
Then, once the OK button is clicked, run a Clear_MultiPageControls sub.

If the condition is false just move along with the rest of the code.

My code does not seem to either check for the terms or raise the MsgBox event.

How do I fix this?

Please Login or Register  to view this content.

Thanks
Mark

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

Please Login or Register  to view this content.

That expression will only return True if the entire phrase "jar jarred packed in oil" appears in the textbox.

This line will never be executed with the Exit Sub appearing immediately above it:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Thanks Shg,

That did the trick!

Here's the finished code:

Please Login or Register  to view this content.

Good job.

Testing for jarred is redundant if you've tested for jar.