PDA

View Full Version : Solved: Fixed Cell/Column Width - when reached move to cell below



Derek
01-18-2007, 05:20 AM
I am creating a sheet where the user will enter an undefined amount of text. I want the user's text to move down to the cell below once the width of the column has been reached - like an automatic carriage return. Can anyone help?

Bob Phillips
01-18-2007, 05:29 AM
The problem is that when you are typing into a cell, edit mode, Excel has full control, you cannot get control to invoke any of your code.

Derek
01-18-2007, 06:13 AM
Thanks for your feedback. I will revert to cell merging and wrap text. Its not ideal but if its the only way, its the only way ;o)

Derek

mdmackillop
01-18-2007, 06:27 AM
Hi Derek,
I found a need for this too.
Regards
MD
http://vbaexpress.com/kb/getarticle.php?kb_id=481

Derek
01-18-2007, 08:24 AM
:mbounce:
Wow!

Worked first time! You are the bomb! I have tinkered with it a bit, removed the input box for a fixed rate change (0.4 worked well). Entering long numbers is a bit tricky (serial numbers etc) but I have left instruction that if the number is more than 16 digits long, to leave a space after the 16th digit and type the rest.

It is fantastic and once again this forum produced results!!

Derek