Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

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

Posted on 2015-02-13
3
Medium Priority
?
649 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:Bryce Bassett
3 Comments
 
LVL 37

Expert Comment

by:bbao
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 2000 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:Bryce Bassett
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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Lost Word File? Eagerly, need it back? Read ahead; this File Recovery guide is for you.
Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
Office 365 is currently available in five editions. Three of them are for business use: Office 365 Business Essentials, Office 365 Business, and Office 365 Business Premium. Two of them are for home/personal use: Office 365 Home and Office 365 Perso…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…

963 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