Excel Tips og Brukerveiledninger

Hurtigtaster

Diverse

VBA Snippets

Finding the Last Row
Finding the Last Column
Finding the Next Row
Auto Hide Current Sheet when Selecting Another
Set the worksheet as a Variable (abbreviate it)
Loop Through Your Database
Loop Through Every Cell in a Named Range
Loop Through All Worksheets
Loop Through ListBox Items
Loop Through Files in a Folder
Fill a ListBox From a Table/Database
Fill a ComboBox
Fill ComboBox Based on Another ComboBox
Spinbuttons to Increase/Decrease Userform Textbox Value
Use a Spinbutton to Increase/Decrease (Userform) Textbox
Use a Spinbutton to Cycle Through (Userform) Tabs
ScrollBar with Worksheet numbers
Insert Title Here
Disable/Enable ScreenUpdating
Disable/Enable Calculation
Disable/Enable Events
Binary, Baby!