Overflowing text.

  • Thread starter Thread starter rocky 123
  • Start date Start date
R

rocky 123

I was wondering whether anyone could please help me with this problem?

I am creating a form to fill in, and where the information for th
adress needs to be entered, goes onto 3 seperate lines (cells A1-A3
B1-B3, C1-3).

Rather than typing in cells A1-A3, then clicking into B1 and typin
again, is there away to automatically get the data to overflow int
cell B1 and so on?

Thankyou
 
Hi Rocky 123!

As described, not without VBA code.

But have you tried merging the cells.

Also, you might find later that it is useful to have different parts
of the address in different cells.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Thanks for your reply,

However i explained it badly. To improve the interface I have mad
lines 2 and 4 smaller, so infact the cells to type the text in ar
A1-A3, C1-C3 AND E1-E3.

So by having it this way i cannot merge the cells together as one. Th
cells along the same row are merged, but this does not allo
overflowing down into the next space,

any ideas please anyone?

thankyo
 
Sorry, i have just realised a big mistake,

I were thinking that the letters were the horizontal toolbar, and th
numbers are the vertical one.

So the address needs to be typed in cells A1,2,3 C1,2,3 and E1,2,3.

So its the same problem which i told really badly!

Thanks agai
 
I really am beggining to believe it's impossible, merging won't work
and evry macro i try to create won't either, any ideas please people?

Many thank
 
Back
Top