Various Tasks Within Worksheet

[DaDDy ICEPOC]

Hi,

Firstly apologies for the descriptiveness (or there lack of) title but i couldnt think of something that would pin the whole thing down.

Attached is my worksheet that i am working on. I have been working on this for a while and teaching myself as i go whilst also utilising help from here . i am not looking for someone to complete this whole task for me as i do want to learn it for expansion later, but in saying that i wont complain if someone does lol


What i want to do with the "Book In" button:
I need to use the check boxes to define which way it is going to book in. i.e. if "NIC Damaged" is ticked when i click to book in it will take the details (asset, serial, call ref in) and then populate the rest with default values that would be associated with that type as these would never change (apart from the date). for example, "Good Stock" would automatically be "No". once it has taken the information it will place it on the "Damaged" worksheet instead of the "In Cage" worksheet again because "NIC Damage" is ticked. "User Damage" and "NIC Damage" would never be ticked together but "Not Charged" is an additional note that could be ticked with either. If no check boxes are ticked it would go through the process i have already done.

What i want to do with the "Ship Out" Button:
This one is much simpler and i think i have most of it down except 1 thing. when it selects the right row, i want it to input the current date into the "Date Sent Out" column. when i tired this it would move the line to the "Shipped Out" tab but input the date on the "In Cage" tab. i cant workout what i am doing wrong so have removed my attempts from the code.

What i want to do with the "Send To Workshop" button:
As with the "Shipped Out" button the problem i have on this one is inserting the date (preferably also the time) in before it moves over.

What i want to do with the "Back From Workshop" button:
the same as the "send to" version of this but obviously into a different box.

The Damaged Button:
this button wont get used much as 99% of damage will be seen at the point of booking in but there area few that can present damage later on so will need moving. again as with the 2 above i need to input in a column before it moves. on this one though it needs to be a user input so i can describe the damage type. but if the NIC Damage check box is ticked it will just input the default value for nic damage into the column before moving it.

Whilst testing this within the sheet i noticed i cannot browse down the sheet? i dont know if this is because i am running it from vba editor but i really could do with being able to move up and down the sheet.
Also, if possible i need the functions to work properly on all sheets no matter what sheet i am on. for example if i am on the damage sheet and click on the "Book In" button it will refer back to the "In Cage" tab to ensure it works the code in that sheet. i have noticed currently that is not the case :/.


Mainly i am not sure how to "If's" and "If Else" type stuff outside what i have done and been kindly given. I can generally edit code but really rubbish so far at writing it from scratch lol.

This "Control Panel" should remain as a floating box at the front but i am not sure yet how to make that bit happen either.


Any help would be really appreciated even if it is a link to a tut on the area's i am trying to achieve. if you need more information please do ask.

Many Thanks

Paul

*edit* Excel 2007 is my choice of weapon