Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compare Colours
Hello; I need to write a VBA for excel: Shift Schedule- Compare colour (Blue represent Day, Red represent Night) 1) Four button - Sunday Day, Sunday Nite, Saturday Day, Saturday Nite When I tick on the button, it will show who is on shift for all the three spreadsheet shift. 2) One button - Ask for user to key in the date, it will show who is on shift for all the three spreadsheet shift. Information: 1)The format will follow MG4shiftFY05 so that it will be easier as I know the 3 excel file are all different format, I will standardise the format. A1:AJ42 2) When I tick the button, For example Sunday Day : Line : Magma Team A Names of the people on shift Line : N2/N3 Team A Names of the people on shift Line : T6/9 Team A Names of the people on shift 3) When I tick button, Date Selection Ask user to key in the date : 2 Line : Magma Team C Names of the people on shift Line : N2/N3 Team C Names of the people on shift Line : T6/9 Team C Names of the people on shift Thanks +-------------------------------------------------------------------+ |Filename: Doc3.doc | |Download: http://www.excelforum.com/attachment.php?postid=3953 | +-------------------------------------------------------------------+ -- Hani ------------------------------------------------------------------------ Hani's Profile: http://www.excelforum.com/member.php...o&userid=28380 View this thread: http://www.excelforum.com/showthread...hreadid=479688 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I customise colours used in charts and keep those colours. | Charts and Charting in Excel | |||
How to save one of the MORE COLOURS in the THEME COLOURS? | Excel Discussion (Misc queries) | |||
How do I compare cells and if FALSE compare to next cell in EXCEL | Excel Worksheet Functions | |||
Excel 2003 font colours and cell colours | Excel Discussion (Misc queries) | |||
compare data from one column with another and compare result to yet another | Excel Programming |