Home

Star Icon

Evalin
Occasional Visitor

Hi everyone,

 

I am not quite sure how to explain what I want to achieve with Excel for one of my projects but here is my question. Any help and training would be greatly appreciated. Thank you.

 

So I am creating a list of names of people with the reading chapters they have completed. So far I have the names in a column and the chapters in the top rows. This is where I get stuck. This is supposed to be an active activity where everyone goes up to the screen and check off what chapter they have read. The thing is that we want it to be stars instead of check marks. We can either have the stars blank and when we click it, it turns yellow or we can just click the empty space and the star icon appears automatically instead of having to copy and paste the star icon. How can I achieve this? Would this require VBA and Macros? Thank you in advance for your help. 

 

 

Chapter1234
Name    
BStarStar  
CStar   
DStar   
EStar   
FStarStar  
G