Re: Text Box Problem
- From: Bob Greenblatt <bob@xxxxxxxxxx>
- Date: Tue, 25 Oct 2005 07:52:51 -0400
On 10/24/05 9:22 PM, in article
1130203365.746156.143870@xxxxxxxxxxxxxxxxxxxxxxxxxxxx,
"ride2995@xxxxxxxxxxx" <ride2995@xxxxxxxxxxx> wrote:
> Hi Jim,
>
> Thanks for your prompt reply. I've told the people that I'm working
> for that the cell is best but they are really having trouble adjusting
> to inputting text that way. They much prefer the text box. Any other
> thoughts?
>
You can right click the text box, select alignment and check Resize to fit
text and wrap text. The text box will then grow vertically as text is
entered. Alternately, you might want to assign a macro to the text box and
trap the entry to enforce a size or text length.
--
Bob Greenblatt [MVP], Macintosh
bobgreenblattATmsnDOTcom
.
- Follow-Ups:
- Re: Text Box Problem
- From: ride2995
- Re: Text Box Problem
- References:
- Text Box Problem
- From: ride2995
- Re: Text Box Problem
- From: Jim Gordon MVP
- Re: Text Box Problem
- From: ride2995
- Text Box Problem
- Prev by Date: Re: Excel quitting due to error of type 2 unless I enter then leave VB editor
- Next by Date: Grouping & Set Print Area
- Previous by thread: Re: Text Box Problem
- Next by thread: Re: Text Box Problem
- Index(es):
Relevant Pages
|
