Regular ActiveX buttons are similarly limited, since they can only use an image or a solid color for their background, but not skins and hover/click/focus effects. They can only receive a single click (not right click, double click, mousemove events, etc) and can’t use advanced visual enhancements, like gradients, skins, hover and click effects.
If you need something that will work on Windows and Mac, you’ll probably lean toward a Form Control or Shape, but they are extremely limited. You may also opt to use a Shape in the place of a button as these can be changed to look very similar to an Html type button. The default buttons in Excel for Windows are under the Developer Ribbon->Insert -> Form Controls OR ActiveX Controls. In Excel, the ability to use a custom button has been around since the nineties, but getting a good-looking, modern button is another thing entirely. Websites have been using a variety of button animations and beautiful, shiny buttons for years using CSS (cascading style sheets) that make it easy to reuse a formatting type. In fact, the modern individual is so used to clicking or tapping buttons, we’ve all become numb to them. One of the most common things in applications is the humble button. ExcelVbaIsFun does not accept money for editorial product or software reviews.
When you buy something using the retail links in our pages, we may earn a small commission.
