Hours after Ron bought his new favorite car, he applied at the dealership to become a salesperson. “I built a great car selection tool, now I can use it to make good business.”
But he knows something was not quite enough – a good interactive user interface should further remove the user from the raw data. And he is right. As his experienced dealer superior recalls, if you give too many detailed choices to the average customers, they will get too stressed out and freak out.
So Ron decides to build a new UI – one that allows the user to select among the car options and displays the specs (and price) for the car of interest, one at a time.
First, he makes a list of cars currently available at the dealership. With ActiveX Control’s Option Button (Alt L > I > O), the basic selector is created as follows:
In this case, like before, he links each of the Option Buttons to a cell to the right of the car name. Note that this could be a tedious process once the list gets long. Consider using VBA to automate the task.
To develop a good UI, it’s important to have an interactive way to distinguish the selection. Note how your browser changes the color of a link that you click on? Ron decides to first format this entire table to the de-selected look. The column of TRUE/FALSE values might confuse the customer, so he hides it by changing the font color to white. Note that the graying out of fonts could add contrast to enhance your selection, but it’s a matter of personal style.
Now, he adds conditional formatting to the table. In this case, one set of rules is applied to each of the three columns. Excel 2007 gives you this really neat Rules Manager for conditional formats, but the same effect can be done in earlier versions of Excel.
This is what the result looks like. When the customer clicks on a car of desire, the entire selection lights up!
Lastly, he uses a combination of lookup functions to create a detailed table of specs to display on the right:
With such an interactive UI, obviously, Ron’s car dealer business is taking off!
Comments are now closed.