Windows 10 and Office Excel

[DocAElstein]

This is post https://excelfox.com/forum/showthrea...ge50#post12770
https://excelfox.com/forum/showthread.php/2408-Windows-10-and-Office-Excel/page50#post12770

---

Plop #495a)

A GUI, simple square with a few square buttons, based on a few simple code lines and a bit of looping

5a) Introduction.
The thing is like approximately like box with 4 columns of buttons. I might leave it in that form, or add a column or two and move things about a bit.

The outer window box GUI form thing that comes up:- It’s too dammed fucking big, Chris
I’ve told him dozens of times so has others. I think he is oblivious to the fact that for most people it blots out the screen making lower buttons unusable. Chris often waffles some crap about automatic re sizing, but I expect he just has some code generated by Posh GUI, which possibly has some redundancy in it, as well as other issues, which he does not understand.
So bollox to all that. It just takes a few simple code lies to make a simple square that will conveniently fit on most peoples screens. About half the size of what he usually has is ideal, but I will use about two thirds as then I can still see a lot of his buttons on it as I migrate from his coding to my new coding.

The buttons
For each button we have a variable of object type. Most of the properties are defined in one go to the variable, (assigned to the variable), but the Click is Added ( the coding that does something) somewhere else. There might be some reason for that, or it might once again just be how Posh GUI chucked it out.
All the buttons are very simple wide rectangular ones and could all be done in a loop. This has been suggested and written for Chris a few times, but he’s not interested as he like his posh GUI.
( jumbled in this section we also have 4 “panels” which for want of a better description seem to be a invisible button with nothing in it, - something like a range, or range object. These 4** are tall things a bit wider than most buttons and extend to the area a bit bigger than to accommodate one of the 4 columns of buttons
A bit further down we add things, that is to say the corresponding buttons, in these column ranges.
The actual Form itself seems to act like a range, or can be used as such, so we actual Add the variables to 5** ranges in total.
We do this Form Controls AddRange first and amongst other things, then add the 4 column Panels to that first. I suppose that makes some sort of hierarchical OOP relesense.

Generate some stuff with a function.
As I mentioned previously, I expect the GUI generated coding, as typical from such stuff, gives all things and does not have the sense to group similar things, or come up with something like a single function talking arguments, to do the similar stuff repeatedly. So a lot of stuff is repeated. I am actually untypical in preferring that usually, but I am going to tidy stuff up with a function to give me some spare lines to put my stuff in, whilst keeping some of Chris’s stuff , albeit mostly commented out, for later ease of navigating around his later modifications.

Etc. etc..