Excel Control / Form Button Increase size

When I insert a Control or Form Button, the actual Button is too small.

At what point in the Design mode can I set the size, or how can I increase the Button size.

Can I create and assign my own "picture" ( a big dot) , to replace the default Button.

Any advise or assistance would be appreciated.

Tosagua
TosaguaAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
StephenJRConnect With a Mentor Commented:
Tosagua - I'm not sure that you can, or at least I can't find a way and that is not the same thing at all. If I can find the relevant thread I will try to alert more expert experts to this question.
0
 
StephenJRCommented:
When you first place the control you can drag the mouse until you have the size you want. You can extend it later by dragging the edge, or you can do it from the properties window (if Control) or with VBA. You can also assign macros to autoshapes which gives you much more flexibility, but you can probably also add your own picture (not sure how).
0
 
TosaguaAuthor Commented:
StephenJR,

My error.
Yes, a retangular Form Button can easily be resized.

I meant the round OPTION Button. I can resize the box that surrounds it, but not the actual button.

Tosagua
0
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

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

 
aikimarkConnect With a Mentor Commented:
If you are referring to a radio button (option button) control, then No.  There isn't a way to increase the size of that control.

You can substitute a control capable of displaying an image and then write your own code to change the image as its value changes.  

You can also overlay your image control on top of (z order) the existing radio button control.  You will still need to add code for both the radio buttons and image controls.
0
 
Dennis WallentinRetiredCommented:
An alternative approach is to use the zoom tool.
0
 
TosaguaAuthor Commented:
StephenJR, aikimark,

I appreciate the imput. After trying a number of things, I suspected that was the case. the buttons are a little small, but they will be usable.

We should put this on Microsoft's To-Do-List.

Thank you,

Tosagua
0
 
aikimarkCommented:
You could also look at third party components to see if they include a resize-able radio button
0
 
Dennis WallentinRetiredCommented:
The issue with third-party ActiveX controls is that they cannot be used in Excel. Instead, create a .NET add-in with WPF.
0
 
aikimarkCommented:
@XL-Dennis

Are you sure?  I remember seeing other controls in a selectable list for adding components to a user form.  It doesn't make sense to me to be able to see ActiveX controls if you can't use them.
0
 
Dennis WallentinRetiredCommented:
ActiveX controls made available by Microsoft work, more o less, in VBA. However, third-party ActiveX controls lack some security that prevent them from running.

(For several years ago I decided to dive into it but I ended up in a no-no case.
When using ActiveX controls in VB6/VB.NET we don't violate the licence's rules since we compile the solutions. With VBA we cannot compile any solutions and therefore distributing a third-party component may violate the licence we agreed to follow.)
0
All Courses

From novice to tech pro — start learning today.