A userform looks like one of those dialogs that you may find under
Tools|options. If you look at Tools|Options|General tab, you'll see a few
textboxes.

You could pop up a userform and have your code behind that userform that
reformats the value the user entered into strings no longer than 50 characters.

If you want to learn more about userforms:

Check Debra Dalgleish's site:
http://contextures.com/xlUserForm01.html

and these articles by Peter Aiken:
http://msdn2.microsoft.com/en-us/lib...ffice.10).aspx
http://msdn2.microsoft.com/en-us/lib...ffice.10).aspx



Renegade40 wrote:

Hi Dave
What do you mean by Userform how is this done. I have enherited this
project and am not really familier with excell. Mainly use quark-express a
long way from this.
any information would be greatly appreciated.

"Dave Peterson" wrote:

I don't think you'll find anything like this built into excel.

Maybe you could build some sort of userform that counts characters and puts data
where you want it.

(it might be lots more trouble than it's worth.)

Renegade40 wrote:

Here's what I'm trying to accomplish. I have a worksheet setup where the
user inputs their daily activities. The daily activities area is made up of
5 rows merged accross the page. I have them set to fixed width as to not
grow. What I need to happen is when they have typed enough information to
fill the row, it have it go to the next row automaticly, then the next until
the last row is fill. But if there is addtional information past the
worksheet's five rows then go to worksheet 2 and continue in the same manner.
can this be done? I don't want to use the alt+enter event because I'm not
the one typing the information.

--

Dave Peterson


--

Dave Peterson