I'm developing in Excel XP. It's all VBA Forms. I am working on my first grid. I have about another 28 to implement.
For my DOS version, I wrote my own grid editor for popup input. It has two versions: one with a predetermined number of rows. Those have a set first column. The other version is extendable. If on the bottom row, pressing enter gets you another row. What I've implemented for iGrid to start, is a button asking the user how many rows to insert above the selected cell. That works, but doesn't solve when reaching the last row. And after entering on the last row, the insert will be above the input.
Also, when enter is pressed, the user stays in the cell. I'd link to advance them to the next cell below. Both could be implemented with a detection of enter in key press event. Searching found nothing useful. Something about with Keydown event with Access. But no working example. And I'm not connecting Access with the grid.
In DOS, I display the cursor row number, and total rows. I would need to know when the cursor changed rows.
The cell selected by the user is too dark. If I programmatically select the cell for an error, it is pale. They should be the same. In Excel, the cells are all white, with thick borders around the cell with the focus. I like that.
Edited by user
2025-03-22T12:35:52Z
|
Reason: Not specified