Excel VBA - Better, Professional Looking Userform Buttons

[Dsewardj]

Hi,

This might seem like a silly request but I am wondering if there is anyway I can get better looking, application-like buttons in the userforms in VBA.

I have developed a pretty cool data comparison tool which compares two different extracts and reports the differences, and there are a few userforms I am using. I looked online and I've seen a few spreadsheet applications use userforms with buttons that look like they are from regular applications and I was wondering if there was some reference I could use without any licensing issues?

Any suggestions?

 

[GlennUK]

I'm curious .... what do these buttons look like exactly? I'm wondering how they differ from what the normal ones look like.

 

[DauntingGecko]

You can use images as buttons on the VBA userforms, or they have probably developed third party apps using .NET in Visual Studio, which gives a lot more functionality with how it is displayed.

 

[Ruddles]

You can make your own buttons here: http://www.cooltext.com/. There are lots of other button generators - Google button generator and take your pick.

Tip: if you do generate buttons using an online service, make a note of the settings you finally decide on, because if you ever have to generate new or modified buttons for the form, that will save you loads of time trying to get them to look the same as the existing ones.

 

[Dsewardj]

GlennUK,

The buttons look like regular buttons used in Windows applications. I am using Windows 7 and the buttons in these other spreadsheet applications have buttons which look like them. The standard command buttons in VBA look like buttons from Windows 98.

I am assuming these spreadsheet applications use VB6 or .NET to create better userforms.

Below is a link to a site with a userform I am talking about:

http://www.formulasoft.com/img/xlscwiz.gif
http://www.formulasoft.com/img/xlscmain.gif

Does anyone know if any resources or references which can show me how to tie-in VB6 or .NET with Excel?

 

[myfe]

If someone knows a website or a software that helps with building a good looking buttons and background for the userform or even a website with tips on how to build one I would really apreaciate.

QUOTE=Dsewardj;2662618]GlennUK,

The buttons look like regular buttons used in Windows applications. I am using Windows 7 and the buttons in these other spreadsheet applications have buttons which look like them. The standard command buttons in VBA look like buttons from Windows 98.

I am assuming these spreadsheet applications use VB6 or .NET to create better userforms.

Below is a link to a site with a userform I am talking about:

http://www.formulasoft.com/img/xlscwiz.gif
http://www.formulasoft.com/img/xlscmain.gif

Does anyone know if any resources or references which can show me how to tie-in VB6 or .NET with Excel?[/QUOTE]