UserForms and ActiveX-control Examples

Dialog example using pictures
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 tool.
Updated: 2002-05-22 Requires: XL97 File size: 90 kB

Create a temporary UserForm
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.
Click here to download this tool.
Updated: 2002-04-02 Requires: XL97 File size: 23 kB

ComboBox Example
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 tool.
Updated: 2000-12-15 Requires: XL97 File size: 131 kB

ListBox example 1
This example shows how you can create ListBoxes with a single column or multiple columns. The information can be filled in from a worksheet range or by a macro.

Click here to download this tool.
Updated: 2000-08-08 Requires: XL97 File size: 18 kB

Create a temporary dialog
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 tool.
Updated: 2000-08-08 Requires: XL97 File size: 6 kB

Progress Bar Control example
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 tool.
Updated: 2000-08-08 Requires: XL2000 File size: 38 kB

ListBox example 3
This example shows how you can move information between two ListBoxes.

Click here to download this tool.
Updated: 2000-08-08 Requires: XL97 File size: 20 kB

ListBox example 2
This example shows how you can update information in one ListBox depending on the selected item in another ListBox.

Click here to download this tool.
Updated: 2000-08-08 Requires: XL97 File size: 16 kB

Tree View Control example
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 tool.
Updated: 2000-08-08 Requires: XL97 File size: 28 kB

Progress bar examples
This workbook contains some examples on how you can create progress bars in UserForms without using the Progress Bar ActiveX-control.
Click here to download this tool.
Updated: 2000-08-07 Requires: XL97 File size: 31 kB

Document last updated 2002-05-22 12:43:43 Printerfriendly version

User comments:

Ongarelli from SJCampos, São Paulo, Brasil wrote (2006-11-11 20:53:38 CET):

Fantástico
Caro Erlandsen,

Parabéns pelas excelentes dicas e exemplos.

Somente deveria ter maiores atualizações.

Muito Obrigado.

Saurabh from India wrote (2006-11-07 09:05:48 CET):

Nice work ! Thanx for your suggestions.
Very useful information
Thank you very much for your Tips.
They where very useful for me.

Thanks

Peter Wooldridge from Melbourne Australia wrote (2006-06-14 11:07:58 CET):

Terrific
Dear Mr Erlandsen
Thank you for providing such an insightfull set of examples. I'm just a rank amature when it come to VBA and have struggled through numerous texts attmpting to achive some meaningful results. Unfortunately, most text assume you a erudite in terms of the language and syntax. Your examples not only work they are well structured with explanatory notes that mean something. Also like the fact that you work with MS97. Thanks again for your time and effort it is greatly appreciated.

Kind regards,

Peter Wooldridge

Asfar from Sabah, Malaysia wrote (2006-05-02 15:09:17 CET):

I'am gonna be loyal to this site...
I've never encounter such a site that contributes such a solomons effort...If there is rating for it i would surely rate it high...I would learn and contribute what i could to all knowledge providers and seekers in the future the same as what is here or even better ;)...Thank you again ("Terima Kasih" means Thank You)...

Leopold Klatka from Denver, Colorado wrote (2006-03-04 01:49:43 CET):

Thank you for good combo box example
Dear Mr. Erlandsen, thank you for good combo box example. It is a pleasure to learn from something that works - it gives life to my program.

Leopold

Ruiyuan Li from China Wuhan wrote (2005-12-09 12:49:28 CET):

Thank you for the tips
The code in the web is that I really long for.

Hector I. Rubio A. from http://www.venezuelaglobal.net wrote (2005-10-02 00:21:49 CET):

Gracias
Saludos Cordiales

Espero me funciones estos ejemplos de rutina, para un proceso de programación en Excel.

Guarita from Portugal wrote (2005-06-20 15:39:18 CET):

Very usefull information
Thank you very much for your Tips. They where very usefull for me.

Thanks