PDA

View Full Version : lines in a cell or dropdown to next cell



peterwmartin
11-05-2009, 01:34 PM
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
11-05-2009, 04:22 PM
Can you make up and post an image of what you are after?

peterwmartin
11-05-2009, 05:46 PM
2212Hi this is the sort of thing I am trying to do with A6

Zack Barresse
11-05-2009, 11:09 PM
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
11-05-2009, 11:27 PM
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
11-05-2009, 11:53 PM
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
11-06-2009, 12:30 AM
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
11-06-2009, 10:20 AM
What about a textbox with the transparancy set to 100%?

peterwmartin
11-06-2009, 10:32 AM
Thanks Lucas,
That seems to do it.

mdmackillop
11-06-2009, 04:27 PM
What about a textbox with the transparancy set to 100%?
A very neat solution Steve. :clap: :clap: :clap:

Zack Barresse
11-07-2009, 09:23 PM
If that solves it for you, can you mark your thread as Solved?