VBA Buttons: Form controls Command Buttons verses ActiveX controls Command Buttons (On Worksheets)
Can anyone add any explanations of the differences or give us the benefit of any experience they have had with these 2 different ways to get a simple button on a Worksheet to set off a macro…
( ActiveX controls and Forms controls 2WorksheetButtonTypes.JPG 2WorksheetButonTypesExcel2003.JPG https://imgur.com/T6GZiSV https://imgur.com/yx2eZaj ).
Hi
I have checked out a lot of stuff, and the purpose of this Thread is just to get any other view points or comments on this subject area…
I myself have been doing VBA stuff for a while now, but have mostly avoided pretty user interfaces such as Buttons. I have started adding a few Buttons here and there as I must confess they can make things a bit convenient or simpler… to use..
Just to be clear what I am talking about..2 different things
In the simple case of a Button in a Worksheet to kick off a macro there are two ways available:
( What I have researched so far )…..I made a short summary here of those two control things:_..
http://www.excelfox.com/forum/showth...0581#post10581
_.. those notes are the result of a bit of reading and internet searching and experimenting on and off over the last few weeks.. ..
So there you have them, those things summarised at that above link, are the 2 separate typical “ways” to get a simple Button on a worksheet to start a macro.… now my question is:
Can anyone else add any explanations of the differences or give us the benefit of any experience they have had with the 2 different ways … etc..
Here a few general questions
_1 ) This one confuse me… A lot of internet research seems to give me the impression that the ActiveX stuff is a more “native” excel VBA thing, and is used in UserForms. That confuses me as I thought ActiveX sounds like something different, and you can find loads of massive books on it that have nothing at all to do with Excel or VBA, whereas I was guessing that the two words userForms and Form control buttons might have suggested that they were some how related. That appears not to be the case ?? is it just an unfortunate choice of word(s) using Form for those two things, the UserForm and the Worksheet Form control ??
_2) If ActiveX control buttons are those used in UserForms?? , then why have they not messed up as much there as they have apparently in there use in worksheets?? Why should anyone not expect that ActiveX controls in UserForms might mess up as much as they have in Worksheets ??
_3) If you spend a lot of time reading up on what the whole Microsoft LECMO technology is all about, as I did, then you end up finding that “ActiveX” technology is behind any “Embedded Object” or just about anything… So you could say:
In a worksheet an ActiveX control is an ActiveX thing.
In a worksheet a Form control is an ActiveX thing.
A worksheet is an ActiveX thing…
So WTF is the difference: In the meantime, the only thing I am fairly sure is not to do with ActiveX is myself. But maybe I am but forgot?
_....
So, ….Can anyone else add any explanations of the differences or give us the benefit of any experience they have had … etc.. …
( _4) I can’t get any ActiveX controls to work in any Excel 2003 on any computer.. can anyone help me here: I have another Thread on that problem: http://www.excelfox.com/forum/showth...0590#post10590 )
Thanks
Alan
References:
http://www.excelfox.com/forum/showth...ing-Techniques
https://msdn.microsoft.com/en-us/lib...ffice.11).aspx
http://www.jkp-ads.com/Articles/controls02.asp
https://www.bayt.com/en/specialties/...controls-quot/
https://support.office.com/en-us/art...0-FFB9AB94E7C2
https://www.excelforum.com/excel-pro...ml#post4637193
https://www.excelforum.com/developme...ml#post4637173
https://www.excelforum.com/excel-pro...ml#post4382894
https://stackoverflow.com/questions/...trols-disabled
http://www.excelfox.com/forum/showth...0518#post10518
https://support.office.com/en-us/art...rs=en-US&ad=US
https://msdn.microsoft.com/en-us/vba...rols-on-sheets
Reply With Quote
Bookmarks