stirlingmw
Board Regular
- Joined
- Feb 18, 2013
- Messages
- 75
Good Morning All
I am trying to put together a workbook for my ships (Royal Navy) to ease data collection whilst at sea. I am almost there, but i am having difficulty with one specific cell and its data validation.
General Information.Range("K6") should contain the Date Time Group (DTG) that the data was collected in a specific format. I have a macro which adds the current DTG,
but if a crew forgets to add this DTG they need to enter it manually. I need to he a piece of code that then checks that the entered data is in the correct format and then warns if not.
can you help?
regards
Steve
I am trying to put together a workbook for my ships (Royal Navy) to ease data collection whilst at sea. I am almost there, but i am having difficulty with one specific cell and its data validation.
General Information.Range("K6") should contain the Date Time Group (DTG) that the data was collected in a specific format. I have a macro which adds the current DTG,
VBA Code:
Worksheets("General Information").Range("K6").Value = Format(Now - LocalOffsetFromGMT / 24, "ddhhmmZmmmyy")
but if a crew forgets to add this DTG they need to enter it manually. I need to he a piece of code that then checks that the entered data is in the correct format and then warns if not.
can you help?
regards
Steve