lines in a cell or dropdown to next cell

[peterwmartin]

Hi all,
I need to have a cell with ruled lines so to speak in it, so when people type in a cell the lines are the same spacing as text or is it posible to have text automatically dropdown to next cell with out warping?
Tried placing lines in the cell but when person clicks in the cell they may click the line. Cell backgrounds have lines but spacing is too narrow.

[mdmackillop]

Can you make up and post an image of what you are after?

[peterwmartin]

Attachment 2212Hi this is the sort of thing I am trying to do with A6

[Zack Barresse]

As far as I know you can't do that. Why can't you do multiple lines? If it's a matter of showing the lines, you can toggle the grid lines. Or if you want to copy all the data to a single cell you could do that too. Not sure what the end-goal is here.

[peterwmartin]

HI Zack,
The picture shows what I need, I was asked to create a form that people could fill in and boss wants it the same as a paper version including lines. Also have a similar problem doing it in Word. I may just have to tell boss it can't be done.

[Zack Barresse]

Well you can, just use multiple rows. That would look just like it would on paper. Or use drawing lines (yuck, can't believe I'm saying this...) and protect the worksheet not allowing users to select objects.

[peterwmartin]

Thanks Zack,
The problem with multiple rows is expecting someone to move to the next row down once the current row is full, dont know if it is possible however have vba say once row is full go down automatically to the next row.
Protecting sheet? At some stage would like to add a calander for them to select date. Not allowing user to select objects then may become a problem. Did try that though may have done it wrong however could still select lines.

[lucas]

What about a textbox with the transparancy set to 100%?

[peterwmartin]

Thanks Lucas,
That seems to do it.

[mdmackillop]

What about a textbox with the transparancy set to 100%?

A very neat solution Steve.

[Zack Barresse]

If that solves it for you, can you mark your thread as Solved?