Return filename only
Function to extract filename from path & filenameAuthor: michael@excelexperts.co.uk
Select a file
Allows user to choose a fileShows the user a familiar ‘explorer’ type dialogue boxAllows the use of a ‘start’ folderAllows the developer to define the …
Select a folder
Allows user to choose a folderShows the user a familiar ‘explorer’ type dialogue boxAllows the use of a ‘start’ folderAuthor: michael@excelexperts.co.uk
Leftmost worksheet in view
This ensures that the leftmost worksheet is always in view.Simply ‘call’ it from a procedure as required.If you have a ‘Control’ sheet containing end user …
Get the last column
This is the function l have been using for many years to return the last row.It suits most of my needs as the parameters allow …
Get the last row
This is the function l have been using for many years to return the last row.It suits most of my needs as the parameters allow …
New VBA procedure; error message
This is an example of a message presented in the event of an error being raised in the ‘NEW_Procedure’ procedure.Please edit to suit your requirements.Author: …
Starting a new VBA procedure
This is the code framework l use when building a new procedure. It includes error handling and timers.’ My approach is to include everything at …
Public Variables
These are the public variables which might be referenced in my vba code examples.