Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

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

Posted on 2015-02-13
3
496 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: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 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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone 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

Microsoft Office Picture Manager is not included in Office 2013. This comes as a shock to users upgrading from earlier versions of Office, such as 2007 and 2010, where Picture Manager was included as a standard application. This article explains how…
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …

808 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