VBA Regex

Closed
Sanju_7454 Posts 13 Registration date Thursday May 9, 2019 Status Member Last seen May 28, 2019 - May 28, 2019 at 04:01 AM
i need a help to create regex to use in Excel vba. Actuality 3 regex

1. Only Numerics
Valid: 12,12.000, 2343342.123221321398783, 0.9874, -12, -23434.232123123
Invalid: 123*,!#@@!12, ^%*&^*$%_12,

2. Alphanumerics (Space acceptable)
Valid: 123 fjlkj, kjdfd, Vasf, VAldk, NVKDJF123
Invalid: @#!@#7373nkddf

3. Date time format 12/23/2019 05:10:23 only


PLZ help me. Thanks for ur time