-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
commandbuttons
-
S
[VBA] manually-select ActiveX commandbuttons & change font size
I need to manually select certain ActiveX commandbuttons on a worksheet, and then change its font size. Below is my attempted code but returns error. Sub Testing() Dim o As Variant For Each o In Selection o.Font.Size = 20 Next End Sub Thanks a lot!- smallxyz
- Thread
- activex change font size
- Replies: 13
- Forum: Excel Questions
-
S
Adding WindowsMediaPlayer to a form...At runtime.
Just like the Title says.. I am trying to figure out how to add a WindowsMediaPlayer control to a form via code. I am not able to find the correct syntax for it. Apparently, it is not done the same way as adding MSForms controls such as labels, texboxes, commandbuttons, etc.. Has anyone seen...- Steve_
- Thread
- adding form texboxes windowsmediaplayer
- Replies: 7
- Forum: General Discussion & Other Applications
-
X
VBA - Command button to run VLOOKUP formulae & also reset field button
Hi all, hoping someone can help me. I have the VLOOKUP formulae prepared which works in a normal excel field (=VLOOKUP(Calc!$E$1,Calc!$B$2:$C$200,2,FALSE)) However, I want to add a command button, which when clicked will calculate the lookup formulae and put the result into Cell D10. How do...- xxweelinseyxx
- Thread
- field vba vlookup
- Replies: 5
- Forum: Excel Questions
-
S
how to assign events to controls on [ Microsoft Forms 2.0 Frame ]
On a worksheet, I have created a MS Forms 2.0 Frame and added several commandbuttons onto it. But how can I code some events into the commandbuttons? I can't locate their names and appearance in VBE and elsewhere. The reason of using Frame is to fix the positions of a bunch of already-made...- smallxyz
- Thread
- events forms frame locate
- Replies: 5
- Forum: Excel Questions
