Centre Userform For Dual Or Multiple Displays
Force the userform to load to the centre of the active excel window, add this code to the userform Initialize event. Perfect for when you have more than 1 ac...
Recent posts
Backup And Copy The Active Sheet
Good if you are running a macro that will affect cell values
Adding A Context Menu To A Userform’s Textbox
A technique to add a custom right click menu (context menu) to a text box on a UserForm. There is no system context menu for text boxes in a userform, and th...
Add Leading Or Trailing Text To Constant Cells In A Range
You will be prompted with an input-box for the range of cells and for the leading text.
Add A Row To The Bottom Of The Active Table
Add a row at the bottom of the active table. This will test that the active cell is in a table, then add a single row to at the bottom.