Hello,
I have a problem with activeX-buttons. When I use excel in my laptop, font size in activex-button increase every time when I click it. How can I solve this?
Hello,
I have a problem with activeX-buttons. When I use excel in my laptop, font size in activex-button increase every time when I click it. How can I solve this?
Hi j12uha
This link has code that solves the problem:
http://stackoverflow.com/questions/9...command-button
or try
Private Sub MyButton_Click() MyButton.Height = MyButton.Height + 1 MyButton.Height = MyButton.Height - 1 ' Here you place your regular code End Sub
Good Luck
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the star to left of post [Add Reputation]
Also....add a comment if you like!!!!
And remember...Mark Thread as Solved.
Excel Forum Rocks!!!
You're better off not using ActiveX controls on worksheets at all. They're incredibly unstable have a look here https://www.google.co.uk/webhp?sourc...eet%20controls and by using them, you're asking for trouble.
Forms controls are much more reliable - they're in the same dropdown as the ActiveX ones, but are designed for use on worksheets - so you don't run into any stability issues, you can do most of the same things with them too and you can use them without using code.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks