View Single Post
 
Old 02-05-2025, 06:22 PM
gmaxey gmaxey is offline Windows 10 Office 2019
Expert
 
Join Date: May 2010
Location: Brasstown, NC
Posts: 1,598
gmaxey is just really nicegmaxey is just really nicegmaxey is just really nicegmaxey is just really nicegmaxey is just really nice
Default

Quote:
Originally Posted by batman1 View Post
I forgot to write: can be "-" or without, case-insensitive. Code accepts 1-UK1234, 1UK1234, 1-BR, 1-br, 1BR

Good idea!


I thingk the next enhancement would be to ensure tasks can't overlap. For another day. It is getting late.



In the userform version I posted earlier, "L" or Leave can be a set 8 hours or defined with a start and end point. Will have to let OP decide what he wants and code can then be modified.


Have you posted a web page or any other material on construction of RegEx expressions? I've read quite a bit of on them since the last time you helped with one of those but still hard to grasp without good practical examples.
__________________
Greg Maxey
Please visit my web site at http://www.gregmaxey.com/
Reply With Quote