Results 1 to 5 of 5

6 star ranking system: how to select a rating by clicking on one of the stars

Threaded View

  1. #1
    Registered User
    Join Date
    08-05-2016
    Location
    Pretoria
    MS-Off Ver
    2016
    Posts
    6

    6 star ranking system: how to select a rating by clicking on one of the stars

    Hello again,

    For my music database I set up a system of IF-formulas to turn a numeric rating into a 6 star visual. Now I want to make it possible to click one of the stars to change the rating. I understand I need to set up a macro but I am a newb with VBA. Can anyone tell me the needed code? I would also need a button to remove any rating. I attach the worksheet.

    Thanks!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Need to calculate 5 star reviews for given rating in excel
    By aism in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-05-2014, 04:05 PM
  2. Adding 5 star rating system
    By tarnationify in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 06-19-2014, 10:50 AM
  3. [SOLVED] Where did I go Wrong? inserting a 5 star rating in excel VBA
    By Dyls in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-23-2013, 05:32 AM
  4. Add 5 Star Rating to cell
    By panamakevin in forum Excel General
    Replies: 9
    Last Post: 10-10-2012, 04:25 PM
  5. Ranking by Rating
    By Mike2020 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 10-31-2007, 07:04 PM
  6. Rating system
    By TTL in forum Excel General
    Replies: 1
    Last Post: 07-10-2007, 12:17 AM
  7. Rating Stars As Chart
    By swieduwi in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-17-2005, 07:33 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1