Erlandsen Data ConsultingThis example workbook contains a simple custom calendar that can be used as a replacement for the MS Calendar Control that sometimes causes problems with missing references. The example file is for Excel 2007 or later, but the solution will probably work in Excel 97 and newer versions. Click here to download this file. Updated: [...]
This workbook shows how you can create an UserForm in Excel97 that uses one or more images that can be updated from a file. The example dialog also shows how you can create a progress bar to show the progress of the running macro. Click here to download this file. Updated: 2002-05-22 Requires: XL97 File [...]
This example workbook shows how to create a temporary UserForm. The UserForm is created in the active workbook and deleted after use. The workbook example shows how a table/database in an Excel worksheet can be filtered with user-defined criteria from the temporary dialog. Note! Newer versions of Excel has a built in protection that prevents [...]
This workbook shows how you can create a combobox dropdown in a worksheet, a dialogsheet or in a UserForm. Contains examples for both the ActiveX-control (with single and multiple columns) and the Forms-control. Click here to download this file. Updated: 2000-12-15 Requires: XL97 File size: 131 kB
From another open workbook It’s possible to set the RowSource-property for a ListBox- or ComboBox-control to get data from another workbook by filling in something like this: ‘[Filename.xls]Sheet1′!$B$1:$B$15 The other workbook must be open for the control to display any values. With the macro below you can fill a ListBox-control with data from another closed [...]
This workbook shows how you can use the TreeView Control to display information in a directory tree and let the user select a single or multiple items. Click here to download this file. Updated: 2000-08-08 Requires: XL97 File size: 28 kB
This example shows how you can move information between two ListBoxes. Click here to download this file. Updated: 2000-08-08 Requires: XL97 File size: 20 kB
This example shows how you can update information in one ListBox depending on the selected item in another ListBox. Click here to download this file. Updated: 2000-08-08 Requires: XL97 File size: 16 kB
This workbook shows how you can use the ProgressBar Control to display the progress of a macro with a single or multiple progress bars. Click here to download this file. Updated: 2000-08-08 Requires: XL2000 File size: 38 kB
This workbook show how you can create a temporary dialog (Excel 5/95 default). The dialog is created in the active workbook and deleted after use. Click here to download this file. Updated: 2000-08-08 Requires: XL97 File size: 6 kB