View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Creating a warning window

How about just using an adjacent cell with a formula in it:

=if(someformulathatchecksyourinputisok,"","Please check your input!")

Format the cell in nice big, bold, red letters.

PCStechnical wrote:

I'm working on a timecard project. I want to create a popup window
(userform) when the values someone inputs on the worksheet for their
regular hours + other hours does not equal the time interval they
inputed.

Example: I input that I worked from 8:00am to 4:00pm (8hr day). I can
break down my hours between regular work hours and other hours
(overtime). If the employee puts in 5 regular hours and 10 other hours
for that day, obviously that is more than the 8 hour day they claimed
they worked.

If this scenario was true, I want a window to pop up telling them that
their hours don't equal.

CAN I DO THAT?

PCStechnical


--

Dave Peterson