VBA Windows 7 style buttons

vba excel windows-7 activex
Tom Doodler picture Tom Doodler · Sep 1, 2015 · Viewed 10k times · Source

I'm pretty sure this question has been asked a lot around the web and I've read a lot of the questions and their "answers" on several forums but I've never seen a clear answer so I'd like to know:

Is is possible, to use Windows 7 style buttons

enter image description here

in Excel VBA or do I have to use these grey things looking like they come from

enter image description here

?

I dont want to use images, I mean importing these "ActiveX Controls", I think thats their name.

Answer

Ralph picture Ralph · Sep 1, 2015

I am unaware of a solution where you can make use of the "Windows 7 style buttons". Yet, I would like to note that programming does not require you to use the "Developer" tab exclusively. In other words: just because you want a button doesn't mean that you have to use just that from the Developer tab. In fact, almost any shape within Excel can be assigned a macro.

The easiest way to get a button similar to the "Windows 7 style button" is to Insert a Rectangle or a Rounded Rectangle from the Shapes menu. The "fancy" grey coloring can be easily achieved when you click on that shape and then on the Format tab for that shape select one of the predefined grey-scale shape style. These buttons look extremely similar to what you want and can be easily assigned a macro by right-clicking on these shapes.

A comparison of buttons created with Excel shapes to the standard Windows 7 button

Related questions

Can't find Microsoft Forms 2.0 Object Library or FM20.DLL

In my Excel 2016 project (Windows 7), I'd like to work with the clipboard: Dim DataObj As New MSForms.DataObject DataObj.GetFromClipboard But I've got this compiler Error at the first line of code: User-defined type not defined So I would like …

Read More
Is there a way to crack the password on an Excel VBA Project?

I've been asked to update some Excel 2003 macros, but the VBA projects are password protected, and it seems there's a lack of documentation... no-one knows the passwords. Is there a way of removing or cracking the password on a VBA …

Read More
How do I declare a global variable in VBA?

I wrote the following code: Function find_results_idle() Public iRaw As Integer Public iColumn As Integer iRaw = 1 iColumn = 1 And I get the error message: "invalid attribute in Sub or Function" Do you know what I did wrong? I tried …

Read More