Thread: VBA format text before colon issue with square bracket
View Single Post
 
Old 05-14-2025, 08:49 AM
gmaxey gmaxey is offline Windows 10 Office 2019
Expert
  
Join Date: May 2010
Location: Brasstown, NC
Posts: 1,617
gmaxey is just really nicegmaxey is just really nicegmaxey is just really nicegmaxey is just really nicegmaxey is just really nice
Default
No, I don't mind.


If I understand the problem correctly, this should work as well without need for the other change or On Error Resume Next line:


.Text = "([a-zA-Z0-9/[][!^13]@)([^t:])"
__________________
Greg Maxey
Please visit my web site at http://www.gregmaxey.com/
Last edited by gmaxey; 05-15-2025 at 05:49 AM.
Reply With Quote