New Excel Forum

This forum has been moved to TeachExcel.

Ask all future questions in the new excel forum.

ExcelKey

How to automate Time in & out; and detect double entries

Macros, VBA, Excel Automation, etc.
Forum rules
This forum is closed.

All new posts should be made at our new Excel Forum at TeachExcel.com.

Re: How to automate Time in & out; and detect double entries

Postby NoSparks » Mon Dec 14, 2015 9:57 am

Hopefully, this time will have it :)
  • 0

You do not have the required permissions to view the files attached to this post.
NoSparks
Excel Hobbyist
 
Posts: 637
Joined: May 28, 2014
Reputation: 103
Excel Version: 2010

Re: How to automate Time in & out; and detect double entries

Postby mhyven » Mon Dec 14, 2015 11:46 am

NoSparks,

Yes! All conditions where met. You are awesome.

Very much appreciated. :D :D :D

Thank you! Thank you.
  • 0

mhyven
Regular
 
Posts: 29
Joined: Sep 21, 2015
Reputation: 0
Excel Version: 2013

Re: How to automate Time in & out; and detect double entries

Postby mhyven » Tue May 03, 2016 4:00 pm

Dear NoSparks,

Is it possible for the database you made to make a sound whenever the pop-up appears? If you can remember, there are three instances that a pop-up will appear: "not yet timed-in", "not yet timed-out", and "not yet timed in & out".

Hoping for your usual help and guidance.. :D

Thank you.
  • 0

You do not have the required permissions to view the files attached to this post.
mhyven
Regular
 
Posts: 29
Joined: Sep 21, 2015
Reputation: 0
Excel Version: 2013

Re: How to automate Time in & out; and detect double entries

Postby NoSparks » Tue May 03, 2016 11:08 pm

Hello mhyven

With those messages there are 3 built in possibilities that use sound.

I've used the Warning Message which is indicated in the code as the number 48.
The others are Information Message (64) and Critical Message (16).
I'm not sure but think the sounds used are determined by the sound scheme of the computer.

If you don't care for the one I used you can try the other 2.
I've commented the code so it will be easy to find and change if necessary.
Right click the sheet tab and select 'View Code'.

Hope that works
NoSparks
  • 0

You do not have the required permissions to view the files attached to this post.
NoSparks
Excel Hobbyist
 
Posts: 637
Joined: May 28, 2014
Reputation: 103
Excel Version: 2010

Re: How to automate Time in & out; and detect double entries

Postby mhyven » Wed May 04, 2016 2:25 am

Dear NoSparks,

I tried all three. I see the difference among those three but only visually. There seems no sounds playing/coming out when the pop-up appears.. im on windows 7 professional with 64bit. ms office 2013.

Thank you.
  • 0

mhyven
Regular
 
Posts: 29
Joined: Sep 21, 2015
Reputation: 0
Excel Version: 2013

Re: How to automate Time in & out; and detect double entries

Postby NoSparks » Wed May 04, 2016 7:53 am

It works for me, I'm also on Windows 7 Pro.
The actual sounds connected to the message boxes are set by the Windows sound control.

Opening Windows Control panel, then Sound, then the Sounds tab
my computer is set to use the Windows Default Sound Scheme.
Testing each sound....
48 gives me the sound set for Exclamation
16 gives sound of Critical Stop, and
64 sound of Asterisk.

All I can suggest is checking whether or not you hear these when tested directly in the sounds control.
If no, you can't... address that issue first
if yes, you can.... afraid I'm stumped.

Good luck
NoSparks
  • 0

NoSparks
Excel Hobbyist
 
Posts: 637
Joined: May 28, 2014
Reputation: 103
Excel Version: 2010

Re: How to automate Time in & out; and detect double entries

Postby mhyven » Wed May 04, 2016 9:02 am

NoSparks,

The PC' sounds were not set to default, else it was disabled.. :lol: :lol:

Thank you.
mhyven
  • 0

mhyven
Regular
 
Posts: 29
Joined: Sep 21, 2015
Reputation: 0
Excel Version: 2013

Re: How to automate Time in & out; and detect double entries

Postby mhyven » Wed May 17, 2017 10:25 am

NoSparks,

Good day!
Its more than a year and the file has always been great. But then, i have a question..
Is it possible to incoporate the codes from this excel file to a visual basic (vb) (gui)?, its just that i've read about the vb and it looks promising.

Thanks in advance.
  • 0

mhyven
Regular
 
Posts: 29
Joined: Sep 21, 2015
Reputation: 0
Excel Version: 2013

Re: How to automate Time in & out; and detect double entries

Postby Don » Tue May 23, 2017 9:26 am

Hi myhven, this forum is closing soon, please ask all future questions on the forum at https://www.teachexcel.com/talk/microsoft-office
  • 0

Don
Moderator
 
Posts: 733
Joined: Dec 4, 2011
Reputation: 2
Excel Version: 2010

Previous

Return to Macros and VBA Questions

Who is online

Users browsing this forum: Baidu [Spider], Google [Bot] and 6 guests

cron