harveya915
Board Regular
- Joined
- Sep 4, 2015
- Messages
- 141
I created an employee attendance record sheet. The months are on the top row and the days (1-31) are on the left column. What I want to do is when I double-click a cell (example B2 for Jan. 1) it will bring up a UserForm with 5 buttons, click on one of the buttons in the UserForm to fill that selected cell with a certain color (example: yellow) and insert a letter (example: L ) in to that cell.
The first button would be to fill in the cell with color "Yellow" and the letter "L"
The second button would be to fill in the cell with color "Blue" and letter "P"
The third button would be to fill in the cell with color "Pink" and letter "S"
Fourth button fill color "Red" letter "X"
Fifth Button fill color "Green" letter "V"
Please bare with me as I'm still rather new at this with little to no experience at all, but I appreciate the help!
The first button would be to fill in the cell with color "Yellow" and the letter "L"
The second button would be to fill in the cell with color "Blue" and letter "P"
The third button would be to fill in the cell with color "Pink" and letter "S"
Fourth button fill color "Red" letter "X"
Fifth Button fill color "Green" letter "V"
Please bare with me as I'm still rather new at this with little to no experience at all, but I appreciate the help!