ActiveX command button

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have added a command button manually and sized it quite small. Therefore I
want the size of the caption font to be as big as possible.

My question is: Can I decrease the command button margin (the space between
the button edge and the caption) in some way?

The Doctor
 
I developed a utiltiy a while back that allows you to replicate the common 3D
format options: raised, sunken, bump and etched. This can be applied either
to worksheet cells or to rectangles.

One use of this is to format a worksheet cell (or cells) to look like a
command button. The caption can simply be typed into the cell. You have a lot
more flexability this way. You assign a macro to the 3D format which is in
fact a grouped shape object.

If you're interested, I can provide the code responsible for the raised 3D
effect which should solve your problem. I quite using command buttons myself.

Regards,
Greg
 
Hi Greg

Thank you for the offer, but I think I'm going to use a form button instead.

The Doctor
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Command Button Question 8
command button 2
Multi-line text on a CommandButton 3
How to enumerate buttons on user form 2
Command Button That Will Toggle 10
command button caption 2
URGENT help needed for a macro to place and size command button 7
Excel excel code to change command button caption 1

Back
Top