LinkBack URL
About LinkBacks
I'm trying to find a code which forces certain cells to do a line break (Alt+Enter) when you press enter in the cell. Anyone know how to make it, or where I can find one?
I'm trying to find a code which forces certain cells to do a line break (Alt+Enter) when you press enter in the cell. Anyone know how to make it, or where I can find one?
It is impossible to get code to run whilst a cell is being edited (without using Windows API calls anyway) and I would suggest it's a bad idea anyway - users are used to pressing Enter to leave a cell. You might consider using a textbox instead, or add a comment to the cell explaining that Alt+Enter is required.
Everyone who confuses correlation and causation ends up dead.
The problem with a textbox is that it doesn't make the cell bigger. It overlaps other cells, and I need to avoid that from happening.
Then I suggest you use a comment (or data validation message) to advise users to use Alt+Enter.
Well I added a comment now, though I came across another problem. The cells are merged and Alt + Enter doesn't seem to edit the row height automaticly while it does so in normal cells. Any ideas how that could be?
It's down to the fact that merged cells are an abomination.
Try this tip.
Thank you, that worked.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks