![]() Would some of you have ideas for more elegance? I have seen quoted a thousand times the link “ but we know all that the is dead and buried. We are therefore obliged, for the empty cell with temporary content, to hide its contents.īUT, in any case, it remains that the reading/analysis of the HYPERLINK URL is a pure shame of programming. While I'm very happy that this set works perfectly, even if the spreadsheet is protected, the final cleaning of the cell does not work if the sheet is protected. Even the most reluctant to use the spreadsheet cannot fail to admit this obvious. The incremental validation in check or uncheck with the arrow keys and the space bar is ecstasy that no normal control allows. Set up 500 checkboxes in a column take few seconds. We go to the cell with the arrow keys, we press on the spacebar for switches the control in hyperlink form. It works, it is fast enough to be discreet, but it is terribly laborious and very ugly. Cleaning the cell of its contents immediately.Putting this in an empty cell of the spreadsheet, which causes its interpretation.Taking the complete formula HYPERLINK as a string of characters.I would need a function of the type “ EVAL”. Here, what I want to recover is the result of the URL passed to HYPERLINK. But part of its result is much more complicated. To recover the formula of a cell is obviously very simple. And as I still want the copy/paste is done very easily, I use ADDRESS, ROW and COLUMNS functions. It is quite different for the radio buttons which, in addition to communicating the location of the clicked button, obviously also give the range of cells in which they act. Recovering the “ type” of the checkbox can also be done relatively easily, even if I specify, in the comment, that it is, according to my view of things, a bit coded with my feet. In the context of the call of the checkboxes, it is still relatively easy because the selection is, by definition, in place on the cell that receives the call from the spacebar. The URL’s reconstitution contained in the HYPERLINK function is not easy. Call the correct procedure, checkBox() or radioButton().Reconstitute the URL that contains the function.The goal of the game is to listen the spacebar and, if the selected cell contains a formula with a HYPERLINK function, typical of the checkboxes, make sure that the edition is diverted to: I had never played this game, but it is well documented to be no problem. For this, a listener type KeyHandler is obviously necessary. So I said that it would be nice if we can check or uncheck the boxes with the keyboard, for example with the spacebar. ![]() And the first of them is the exclusive use of the mouse. ![]() This simplifies the setup in other files (and copy/paste checkboxes too).Īs I am using this thing quite intensely, I have also been able to test its limits. ![]() For the sake of simplicity, I have just produced a new version that changes the module’s name from “ Module1” to “ checkBoxes”. The establishment of checkboxes becomes very simple since it is obviously a simple copy and paste. Because it is very useful to me, I continue to explore my little code snippet here. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |