Text box autosizing

[Guest]

Hi All,

I am trying to create a general report for users to fill in on a regular
basis. It is supposed to help people report anomalies within a system. At
the moment it has a huge text box within it for people to write a brief
descritption and maybe enter a picture.

Is it possible to force the text box to automatically size itself to the
text it contains without losing any of the other formatting (ie returns, line
lengths etc.)? Ideally I would like it to have a default size (so people can
see it's there) and then to change sizes if it needs to - if the user puts in
more than a couple of lines as a description or if they want to add a picture.

As an added challenge I am writing this using excel 97 and they will be
using it on excel 2000 - long story as to how this came about, just believe
me I can't do it at their computers, they are overseas.

Thanks,
Fiona

Also is there a FAQ page for the Excel group?

 

[Guest]

hi,
have you tried setting the text box's autosize property to
true?

 

[Guest]

Thanks,

I did that and it works now. I probably should have looked for that first...