LinkBack URL
About LinkBacks
I want to create a column where each cell has 5 stars in it and you can click the stars like with most online website rating apps. Where can I find such an app?
I want to create a column where each cell has 5 stars in it and you can click the stars like with most online website rating apps. Where can I find such an app?
::I just found out that the brain is like a computer. If that's true, then there really aren't any stupid people. Just people running DOS.
For discussion:
A1 = cell to hold rating (stars)
B1 = Data Validation Cell, List Option. List = 1,2,3,4,5
Set font format of A1 to Wingdings
Use this formula in A1: =REPT(CHAR(171),B1)
what do you want to happen when "stars"clicked then?
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
If I were to click the 3rd star, i wanted to see 3 filled yellow stars, and two empty stars.
If I clicked the 1st star I wanted to see 1 filled yellow star and 4 empty stars.
Thanks alot for the help and consideration. I wanted one more complex than just using the wingdings font.
You would have to use five separate cells and some VBA. There's no way to tell where you clicked in a cell, only that it was clicked.
You could use shapes, but it would be messy.
Entia non sunt multiplicanda sine necessitate
How about something like this?
Book1.xls
Not stars but might be helpfull...
Now shg only need make vba to change cell's when they are populated
For example, third box (third cell become TRUE) need to make 1 and 2 TRUE and 4 and 5 false...
You know that VBA things
Last edited by zbor; 09-24-2009 at 03:04 AM.
Never use Merged Cells in Excel
Click a star to select stars up to that point.
Column G is used to remove star rating.
Please Login or Register to view this content.
Hello Excel experts,
I am trying to complete a task, can someone help?
Here are my requirements:
- Allow user to select the star rating with a mouse click. They can select up to 5 stars.
- Display the total number of selected stars under the "Total Stars" column.
I am a complete macro newbie and have no idea how to modify this code to meet the above requirements *and* insert the macro.
I have attached my file so you can see. If someone could modify the file directly and re post I would be so grateful.
Thank you!
Please Login or Register to view this content.
Welcome to the forum.
Please take a few minutes to read the forum rules, and then start your own thread in the appropriate question forum.
Thanks.
Hi This is exactly what i need but have no idea where to insert this code.
please advise i also want to have 6 stars.
Your help would be greatly appreciated
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks