coliervile
02-21-2008, 04:39 PM
The following worksheet allows employees' to submit time off of work, vacation and other types of time away from work. There are three (3) command buttons; Submit Leave Request Form, Search For Leave By Date and Search For Leave By Name. The command buttons are pretty much self explanatory. When a user uses the "Search For Leave By Date" they place the date in the search box (e.g. 9/5/08) and any names, types and when requested display in a message box (msgbox).... see below. Most of these codings where a product of "XLD"...thanks again for your help.
---------------------------
Microsoft Excel
---------------------------
GG (Leave type: Prime Time, Requested on: 15 Feb 2008 16:04:53)
EE (Leave type: Annual, Requested on: 15 Feb 2008 16:05:22)
CC (Leave type: Prime Time, Requested on: 15 Feb 2008 16:05:44)
BB (Leave type: Annual, Requested on: 15 Feb 2008 16:06:05)
FF (Leave type: Sick, Requested on: 16 Feb 2008 22:06:39)
---------------------------
OK
---------------------------
What I want to do is be able to print this information out...
GG (Leave type: Prime Time, Requested on: 15 Feb 2008 16:04:53)
EE (Leave type: Annual, Requested on: 15 Feb 2008 16:05:22)
CC (Leave type: Prime Time, Requested on: 15 Feb 2008 16:05:44)
BB (Leave type: Annual, Requested on: 15 Feb 2008 16:06:05)
FF (Leave type: Sick, Requested on: 16 Feb 2008 22:06:39)
Any ideas of how to do this from a message box???
I would also like to add to the message box the date that was requested in the search text box???
Best regards,
Charlie
---------------------------
Microsoft Excel
---------------------------
GG (Leave type: Prime Time, Requested on: 15 Feb 2008 16:04:53)
EE (Leave type: Annual, Requested on: 15 Feb 2008 16:05:22)
CC (Leave type: Prime Time, Requested on: 15 Feb 2008 16:05:44)
BB (Leave type: Annual, Requested on: 15 Feb 2008 16:06:05)
FF (Leave type: Sick, Requested on: 16 Feb 2008 22:06:39)
---------------------------
OK
---------------------------
What I want to do is be able to print this information out...
GG (Leave type: Prime Time, Requested on: 15 Feb 2008 16:04:53)
EE (Leave type: Annual, Requested on: 15 Feb 2008 16:05:22)
CC (Leave type: Prime Time, Requested on: 15 Feb 2008 16:05:44)
BB (Leave type: Annual, Requested on: 15 Feb 2008 16:06:05)
FF (Leave type: Sick, Requested on: 16 Feb 2008 22:06:39)
Any ideas of how to do this from a message box???
I would also like to add to the message box the date that was requested in the search text box???
Best regards,
Charlie