Eksempler på brug af Excel VBA macros på Engelsk og deres oversættelser til Dansk
{-}
-
Colloquial
-
Official
-
Medicine
-
Financial
-
Ecclesiastic
-
Official/political
-
Computer
How to calculate time with Excel VBA macros.
Home> Excel VBA macros> Random numbers and drawing lots.
How to write a text file with Excel VBA macros.
Programming with Excel VBA macros- tips, tricks and examples.
Delete rows by using criteria with Excel VBA macros.
Home> Excel VBA macros> Process and mass balance.
Random numbers and drawing lots with Excel VBA macros.
How to hide orshow rows and columns conditionally with Excel VBA macros. Worksheet functions and addins Make your own worksheet functions and addins.
Calculate stop time, runtime etc. with Excel VBA macros.
The Range object in Excel VBA macros Home> Excel VBA macros> The Range object Excel VBA start page Excel VBA sitemap Spreadsheet downloads Home Contact The Range object in Excel VBA macros In Excel a Range represents any number of cells in a worksheet.
Merge or combine data and tables with Excel VBA macros.
Using Select Case in Excel VBA macros Home> Excel VBA macros> Select Case Excel VBA start page Excel VBA sitemap Spreadsheet downloads Home Contact Using Select Case in Excel VBA macros A common way of testing conditions in VBA is If-Then constructions.
How to hide or show rows and columns conditionally with Excel VBA macros.
TextBoxes on userforms in Excel VBA Home> Excel VBA macros> TextBoxes Excel VBA start page Excel VBA sitemap Spreadsheet downloads Home Contact TextBoxes on userforms in Excel VBA When you work with VBA macros in Excel, you often need user input via a userform.
How to hide orshow rows and columns conditionally with Excel VBA macros. Worksheet functions and addins.
Download Excel spreadsheets with VBA macro examples Home> Excel VBA macros> Excel VBA downloads Excel VBA start page Excel VBA sitemap Home Contact Download Excel VBA macro examples From this page you can download Excel spreadsheets with VBA macro examples.
How to calculate time with Excel VBA macros Home> Excel VBA macros> Calculating time Excel VBA start page Excel VBA sitemap Spreadsheet downloads Home Contact Calculating time with VBA This page shows examples of how to get hours, minutes and seconds out of a date formatted time like e.g. 03:40:51 3 hours, 40 minutes and 51 seconds.
Process and mass balance in Excel with VBA macros Home> Excel VBA macros> Process and mass balance Excel VBA start page Excel VBA sitemap Spreadsheet downloads Home Contact Process and mass balance in Excel with VBA macros Anybody here who hasn't tried to make a cicular reference in a spreadsheet?
If Then test in Excel VBA macros Home> Excel VBA macros> If Then test Excel VBA start page Excel VBA sitemap Spreadsheet downloads Home Contact If Then test in Excel VBA macros I can see that quite many search for information about If-Then conditions and constructions in VBA, and since there is a demand I have made this beginner's page on how to test conditions or constraints with"If Then.
How to make your own collections in VBA Excel Home> Excel VBA macros> Your own collections Excel VBA start page Excel VBA sitemap Spreadsheet downloads Home Contact How to make your own collections in Excel VBA There are many built-in collections in Excel(and other Office programs), and it is easy to make your own.
Loop through controls on a Userform with Excel VBA Home> Excel VBA macros> Loop controls on a Userform Excel VBA start page Excel VBA sitemap Spreadsheet downloads Home Contact Loop through controls on a Userform with Excel VBA A Userform is a useful tool to get user input for your Excel VBA application.
How to make your own menus in Excel with VBA Home> Excel VBA macros> Your own menus Excel VBA start page Excel VBA sitemap Spreadsheet downloads Home Contact How to make your own menus in Excel with VBA In Excel(and other Office programs) it is pretty easy to make menus tailored to your needs.
Histogram in Excel with VBA-macros Home> Excel VBA macros> Histograms in Excel with VBA Excel VBA start page Excel VBA sitemap Spreadsheet downloads Home Contact Histograms in Excel with VBA macros On this page I show how to make a histogram fast and easy in Excel with VBA macro code.
Sort hyperlinks in Excel with VBA macros Home> Excel VBA macros> Sort hyperlinks in Excel Excel VBA start page Excel VBA sitemap Spreadsheet downloads Home Contact Sort hyperlinks in Excel with VBA macros There is a known bug in Excel that makes errors in hyperlinks, if you sort the cells.
Make your own toolbar in Excel with VBA macros Home> Excel VBA macros>Your own toolbar Excel VBA start page Excel VBA sitemap Spreadsheet downloads Home Contact Make your own toolbar in Excel with VBA macros It is easy to make your own toolbars in Excel with a few macros written in VBA. .
Merge or combine data and tables with Excel VBA macros Home> Excel VBA> Merge or combine data and tables with Excel VBA macros Excel VBA start page Excel VBA sitemap Spreadsheet downloads Home Contact Merge or combine data and tables with Excel VBA macros This page shows examples of how to merge and combine data and tables(lists) using criteria.
Split a text file into smaller files with Excel VBA Home> Excel VBA macros> Split text files Excel VBA start page Excel VBA sitemap Spreadsheet downloads Home Contact Split a text file into smaller files with Excel VBA On this page I show how VBA can split a text file into smaller files with a user defined number of max lines/rows.
Random numbers and drawing lots with Excel VBA macros Home> Excel VBA macros> Random numbers and drawing lots Excel VBA start page Excel VBA sitemap Spreadsheet downloads Home Contact Random numbers and drawing lots with Excel VBA A reader asked me if I would make an example on how to generate random numbers with Excel VBA, and I did because it was funny.
Make your own popup menu in Excel with VBA macros Home> Excel VBA macros> Make your own popup menu in Excel Excel VBA start page Excel VBA sitemap Spreadsheet downloads Home Contact Make your own popup menu in Excel with VBA With VBA you can easily make a popup menu(shortcut menu) that pops up, when you right-click, and replaces Excel's built-in menu for right-click.
Date format in an Excel VBA ComboBox or ListBox Home> Excel VBA macros> Date format in a ComboBox or ListBox Excel VBA start page Excel VBA sitemap Spreadsheet downloads Home Contact Date format in an Excel VBA ComboBox or ListBox Having dates in a ComboBox or ListBox in Excel VBA can be a real teaser, because VBA changes the date format, and that may not be the way you want the dates displayed.