Data Validation for all TextBoxes and Comboboxes in Userform

[singhabhijitkumar]

I have a userform with TextBoxes and Comboboxes. I am supposed to perform a data validation to check presence of comma (,) in any of the fields. I have written the following loop but I am not able to figure out how to check the data for presence of comma.
Need help.

Please Login or Register  to view this content.

[TMS]

Perhaps:

Please Login or Register  to view this content.

Regards

[singhabhijitkumar]

sorry not getting cCont.Value

[TMS]

Sorry

Please Login or Register  to view this content.

should have been

Please Login or Register  to view this content.

[singhabhijitkumar]

sorry friend not getting cCont.Value. did u try it yourself

[TMS]

No I don't have any textboxes to play with.

Subtitute should probably be "Application.WorksheetFunction.Substitute"

Post a sample workbook and I'll try it out.

Regards

[wotadude]

or ....

Please Login or Register  to view this content.