JohnFeb 25, 20222 minWorking with a UserForm's close button (the 'X' button)The close (or 'X') button appears at the right in the title bar of every UserForm. You can control the behaviour when it is clicked, or...
JohnFeb 24, 20222 minAdd an icon to a UserForm's title barAdding an icon to a UserForm's title bar can help to give a professional look to your UserForm. The source icon must be a .ico file. If...
JohnFeb 22, 20222 minGet or set the Ribbon visibilityThe examples here all work with Excel, Word and PowerPoint, they do not work with Outlook. Set the Ribbon visibility These methods allow...
JohnFeb 22, 20221 minJoin two parts of a file or folder pathNOTE: this post and the code it contains is still valid, however, it has been superseded by the 'Working with files and folders in VBA'...
JohnFeb 22, 20221 minDoes a file or folder exist?NOTE: this post and the code it contains is still valid, however, it has been superseded by the 'Working with files and folders in VBA'...
JohnFeb 22, 20222 minPause processingCode often needs to pause and wait for something else to happen. There are a number of options to do this. In Excel, you can use...