Solved

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

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

ScreenConnect 6.0 Free Trial

Discover new time-saving features in one game-changing release, ScreenConnect 6.0, based on partner feedback. New features include a redesigned UI, app configurations and chat acknowledgement to improve customer engagement!

Question has a verified solution.

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

My experience with Windows 10 over a one year period and suggestions for smooth operation
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
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 …
In a previous video Micro Tutorial here at Experts Exchange (http://www.experts-exchange.com/videos/1358/How-to-get-a-free-trial-of-Office-365-with-the-Office-2016-desktop-applications.html), I explained how to get a free, one-month trial of Office …

770 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