Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Printing on message box condition?
Does anyone know how to print when a certain condition is present in a message box e.g if my msgbox has text and value like....Bloggs J has 17 days booked off, is it possible to have some code that then finds all instances of that name in any column greater than row13 and also select the corresponding offset from column A paste them in to a workbook then print them off as 2 columns (if it can be done with out pasting in to a workbook even better!) so effectively it would look like this:- So Column A would be the date and the offset may be x amount of columns away that contains the name Bloggs J 12/2/05 Bloggs J 22/3/05 Bloggs J 4/7/05 Bloggs J etc.? Hope you can help, Simon -- Simon Lloyd ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.excelforum.com/member.php...fo&userid=6708 View this thread: http://www.excelforum.com/showthread...hreadid=478639 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Printing on message box condition?
Simon, the msgbox is set up with strings and integers already. It would
be a lot easier to test on these, rather than on a msgbox value. I can imagine that your msgbox is set up something like: msgbox PersonName & "has " & No_Days & " days booked off" where PersonName is string that contains Bloggs J and No_Days is the integer that has the number of days booked off. Write a do...loop that searches picks up all the values in your sheet matching the PersonName and paste them into your new sheet/book. Good luck Peter |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create a Message based on the condition | Charts and Charting in Excel | |||
Reminder message before printing | Excel Discussion (Misc queries) | |||
error message during printing | Excel Discussion (Misc queries) | |||
Display message based on condition | Excel Worksheet Functions | |||
Deactivating Printing Message | Excel Programming |