Solved

MS Office UserForm Button Style - Can I turn off 3D effect?

Posted on 2015-02-13
3
441 Views
Last Modified: 2016-02-10
Simple question.   In a UserForm created by VBA, I'd like to turn off the 3d look of a CommandButton.  The ComboBox control, for example, has the SpecialEffect property where I can change the default sunken to plain.  I don't see any such control over the look of a CommandButton.  I am going for the look on the right below.   Can anybody help?  Thanks!

3doff.GIF
0
Comment
Question by:versatilebb
3 Comments
 
LVL 37

Expert Comment

by:Bing CISM / CISSP
ID: 40609185
the Shadow property of ComboBox control is the switch to enable to disable the 3D-look you mentioned.

More detials can be found here.

https://support.office.microsoft.com/en-gb/article/Add-a-list-box-or-combo-box-to-a-worksheet-555bee5f-96e6-4047-a469-78e4f1d988b3
0
 
LVL 23

Accepted Solution

by:
JSRWilson earned 500 total points
ID: 40609492
Pretty sure the command button does not have properties to turn off 3D.

Maybe you could use something else?

For example a label (difficult to center text) or maybe a combination of a label and empty image. I'm sure you can work out other combinations.
0
 

Author Closing Comment

by:versatilebb
ID: 40609810
Yep, I've toyed with using a label as a button, and seen the workaround of layering 2 layers on top of each other to produce vertically centered wording.  Was hoping to avoid that.  I may just tell my designer this is a case where function is going to win out over form.  

Thanks
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
Recently Microsoft released a brand new function called CONCAT. It's supposed to replace its predecessor CONCATENATE. But how does it work? And what's new? In this article, we take a closer look at all of this - we even included an exercise file for…
This video shows where to find templates, what they are used for, and how to create and save a custom template using Microsoft Word.
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …

896 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now