W
Wild Bill
I'm pseudo-using Excel as a database with some huge cells such as 150
lines including LFs (I stripped the CRs). I'd like to see as much as
possible, navigate with the keyboard, and (hey, I can dream) if possible
find and land cursor on a search term (ideally repeating with a button).
Highlighting them would be the final victory - or at least enlarging or
emboldening - even if I could only do one at a time.
At a comfortable font I can see about 30 lines in the auto-expanding
Formula Bar while selecting the unwrapped cell so that's a start. It
looks clean with the LFs. I can then click in the (full screen height
now) formula bar and use all 4 arrow keys and even control-left,right
and control-home,end. I can even mark and copy text. So so far, fairly
useful.
I can improve on that by hitting a button and copying it on a full
screen form that has nothing but a huge textbox and exit button. That
also buys me use of page-up and page-down.
The only other thing I've found is to modify characters().font
properties such as .size (thank you for once giving that solution,
Darlin' Harlan). But that only affects the visible cell on the worksheet
- not the formula bar content or the form listbox. (I haven't considered
a listbox directly on the sheet.)
Background highlighting individual terms is my greediest hope, but I did
actually think of a way - parsing the cell word by word onto many cells.
But if you think about it, it makes unnatural sentences - because of
course I can't autosize widths differently on different rows.
Can you suggest where I can go now? Can I embolden or color parts of a
textbox or something? And/or get finds?
Maybe I should wimp out and copy the cell into a fresh Word .DOC and
highlight with (UGHH!)Word VBA. I'd certainly have the repeat-find
capability too.
lines including LFs (I stripped the CRs). I'd like to see as much as
possible, navigate with the keyboard, and (hey, I can dream) if possible
find and land cursor on a search term (ideally repeating with a button).
Highlighting them would be the final victory - or at least enlarging or
emboldening - even if I could only do one at a time.
At a comfortable font I can see about 30 lines in the auto-expanding
Formula Bar while selecting the unwrapped cell so that's a start. It
looks clean with the LFs. I can then click in the (full screen height
now) formula bar and use all 4 arrow keys and even control-left,right
and control-home,end. I can even mark and copy text. So so far, fairly
useful.
I can improve on that by hitting a button and copying it on a full
screen form that has nothing but a huge textbox and exit button. That
also buys me use of page-up and page-down.
The only other thing I've found is to modify characters().font
properties such as .size (thank you for once giving that solution,
Darlin' Harlan). But that only affects the visible cell on the worksheet
- not the formula bar content or the form listbox. (I haven't considered
a listbox directly on the sheet.)
Background highlighting individual terms is my greediest hope, but I did
actually think of a way - parsing the cell word by word onto many cells.
But if you think about it, it makes unnatural sentences - because of
course I can't autosize widths differently on different rows.
Can you suggest where I can go now? Can I embolden or color parts of a
textbox or something? And/or get finds?
Maybe I should wimp out and copy the cell into a fresh Word .DOC and
highlight with (UGHH!)Word VBA. I'd certainly have the repeat-find
capability too.