I have been trying to come up with a workable solution to a project and hope tha

Question

I have been trying to come up with a workable solution to a project and hope that this could be the easiest way to achieve my goal.

I have a spreadsheet which contains employee data in columns A, B and C after that the columns are set out like a calendar for a specific month. I would then block colour days where that employee is carrying out a certain activity. Due to the amount of time it takes to select the cells, select the correct colour and then adding into that errors with selecting the wrong colour my idea is to select the required cells and then select a Command Button (Add) this will bring up a Userform (Add Activity). It will give me a drop-down menu of the available activities.

When an activity is selected, the highlighted cells on the spreadsheet are blocked in the correct colour. I would a letter to be added into these cells also, which would correspond to the first letter of the activity (This is purely so I can work out Stats of who is doing what at a certain time).

I have the SpreadSheet and Userform but not the coding to achieve the goal.

Please help

Explanation / Answer

To just delete the text/formulas in the selected range, use

Selection.ClearContents

If you want to blow everything away; contents, number formats, shading, conditional formatting and all the other hard work you did to the cell, use

Selection.Clear

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.