View Single Post
 
Old 09-07-2015, 08:40 PM
jcrennan jcrennan is offline Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: Sep 2015
Posts: 5
jcrennan is on a distinguished road
Default

Quote:
Originally Posted by NoSparks View Post
jcrennan

Can you post a sample file with user form which behaves this way ?

Also, what is the setting of Short Date in your regional settings ?
I have attached an empty copy

If you goto the Totals Worksheet and use Add Entry button this will bring up the form.
When you click the Add record button on the form the details from the user form get added to the Programs Worksheet.

To test select an entry that is in the 1st twelve days on the month and then also do an entry for one that is in the later part of the month.

The PC regional settings is English(Australia) Short Date d/MM/yyyy
Attached Files
File Type: xlsm MASTER File - Programs Daily Stats 2015-2016.xlsm (136.4 KB, 13 views)
Reply With Quote