Add Command Buttons to User Form at Runtime

Well I have been making a lot of progress (thanks to Norie ). See attached.

A few things I have planned:

1. Have the buttons placed from left to right then down (instead of down then left to right)
2. Work out a way to have a visually pleasing number of rows & columns. As can be seen from my sub, I am toying with the idea of using mod (once the number of buttons is greater than 10) to determine whether the number of buttons would fit neatly into X number of columns (say 5/7/9 columns). If no mod found on the desired column options then I will have to choose the number of columns that will have the closest fit (so that there isn't a large empty space on the last row). I'm not sure how to go about that yet.