Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
VBA for entering time without a col
Name: track29 Date: April 23, 2005 at 07:52:39 Pacific OS: XP HOME CPU/Ram: 512
Comment:
I have found VBA code for entering time without colon however do not know how to limit this to colums C through F. The code I found results in undesired results elsewhere in the sheet.
Summary: Hi, Here is some information on Time in Excel. Times in Excel appear difficult, but if you ensure that all data entry follows a time format that Excel recognizes, you will be able to add and subtract ...
Summary: Hi I have found the following VBA code to allow me to have more than 3 conditional formats. Private Sub Worksheet_Change(ByVal Target As Range) Dim icolor As Integer If Not Intersect(Target, Ran...
Summary: A process, not a solution: 1 - Determine the number of months between the Project Start Date and the employee's next anniversary date. There are multiple ways to do this, starting with this info: htt...
