Originally Posted by grahamlthompson:
“Hi Les, your screen must have a little more overscan than mine. It says click and scroll. Only the first list is clickable.
If you look carefully the 2 lists should have every possible combination of BBC1 and BBC2 clicking on any gives the watchable channels for that combination. Once clicked you can scroll up and down.
To adjust the form and listbox sizes for your display.
Load the spreadsheet (don't press any buttons)
Choose Tools/Macro/Visual Basic Editor
In the project box top left open the forms entry
Double Click the TwoCablesSuggestion Form. You can resize the individual items by clicking them and pulling the handles.
Save the changes, you should (hopefully be able to see the whole form)”
“Hi Les, your screen must have a little more overscan than mine. It says click and scroll. Only the first list is clickable.
If you look carefully the 2 lists should have every possible combination of BBC1 and BBC2 clicking on any gives the watchable channels for that combination. Once clicked you can scroll up and down.
To adjust the form and listbox sizes for your display.
Load the spreadsheet (don't press any buttons)
Choose Tools/Macro/Visual Basic Editor
In the project box top left open the forms entry
Double Click the TwoCablesSuggestion Form. You can resize the individual items by clicking them and pulling the handles.
Save the changes, you should (hopefully be able to see the whole form)”
Ok, it may well be my display, I have it on "Large Fonts" & Large Size (120DPI), as my old eyes are not so good at short reading distance these days (but I can see for miles
). This does give some problems on Websites and some windows/boxes.If I understand the use of the 2 columns then, are you meant to read columns 1 & 2 across as each row? This is why there are duplications in column 2, for each combination with column 1?
I have to go out for an hour or so now, so I'll try the VBA sizing later.
Rgds.
Les.
I'm having a "thick" day.
