Daily posts of Excel tips…and other stuff
Archive for the ‘ActiveX Controls’ Category.
Hi all,
I decided I need a bit more content on my site for the average to intermediate Excel users:
Using controls on worksheets
Apart from input cells chained to cells with formulas, there are other options in Excel to make your spreadsheet model more interactive. You can add option buttons, check boxes and list boxes to your [...]
David wants to know why the WMP control won’t start playing right away. I’ll be damned if I know. Maybe you can tell us. First, show the Control Toolbox and click on More Controls. Find the Windows Media Player control and put it on Sheet1. Next, put these subs in [...]
Yesterday I installed OpenOffice on a couple of laptops. In order to accept the license agreement, I had to scroll down to the bottom of the textbox. The “Accept” button was disabled until I’d reached the bottom. I don’t know why they care if I read their EULA. I could go [...]
The TakeFocusOnClick and Default properties are not behaving like I’d like them to. ActiveX command buttons (the ones you put on userforms) have these two properties. Setting TakeFocusOnClick to False (the default is True) keeps the focus on whatever control had it before the command button was clicked. Setting Default to True [...]
In a previous post, I used the column header to sort the ListView. Now I’ve abandoned sorting and I’m using column headers for something else.
I need a way to easily add the same data to all of the ListItems. My ListItems are products and each product has an associated Board Software Package (BSP). [...]
Does anyone use non-standard UserForm controls? By non-standard, I mean those that normally don't appear in the VB Toolbox.
I generally avoid using such controls because I'm afraid that they won't work reliably for all users. Today I was playing around with the Microsoft Date and Time Picker 6.0. I don't even know where it came [...]
Demonstrate how we can use the Spreadsheet control as a datasource to the Chart control in OWC.
An introduction to the Chart Control in the Office Web Components.
