Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 684
  • Last Modified:

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

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
Bryce Bassett
Asked:
Bryce Bassett
1 Solution
 
bbaoIT ConsultantCommented:
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
 
JSRWilsonCommented:
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
 
Bryce BassettFreelance VBA programmerAuthor Commented:
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: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

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

Tackle projects and never again get stuck behind a technical roadblock.
Join Now