Excel help required.

McGraw · 05-07-2006, 14:44

Hello.

Currently constructing an Excel spreadsheet to deal with a list of information sent over to various companies.

What I need is for any text I type to be bound by the cell it is typed in so that it doesn't overlap next door if next door is empty.

Ideally I would like the full text to appear in a box if you hover over the original cell.

So.

ABCDEFGHIJKLMNOPQRSTUVWXYZ

Typed into:

[ ][ ][ ][ ]

Would appear as

[ABCDEF][ ][ ][ ]

Ideally, hovering over the first cell would show all the contents.

Thanks a lot.

gazzae · 05-07-2006, 14:51

AFAIK the only way to do it would be to put a space in the adjoining cell.

As for hovering over you would have to use a comment for that.

littld · 05-07-2006, 15:50

You can format the cell as "Fill" instead of "General" (Format, Cells, Alignment in the menu).

That will stop it leaking over to the next cell.

I didn't really understand the rest of what you're trying to do - what's with the [[[[ ]]]]?

gazzae · 05-07-2006, 15:59

Quote:

Originally Posted by littld

You can format the cell as "Fill" instead of "General" (Format, Cells, Alignment in the menu).

Never knew that. Nice one.

littld · 05-07-2006, 16:16

OK I understand now and I think I have it cracked.

Ignore my previous comment, format alignment as Left and Top (defaults to bottom). Then set it to wrap text. Finally set the height of the row so that you don't see the text that's wrapped.

To get the comments to work you need to use a macro. Right click the worksheet tab and select "View Code" from the popup menu. Then paste in the following:

Private Sub Worksheet_Change(ByVal Target As Range)
With Target(1)
If .Comment Is Nothing Then .AddComment
.Comment.Text CStr(.Value)
End With
End Sub

Then close the Visual Basic editing window. From now on, every time you change the contents of a cell in the worksheet the comment will be updated for the rollover.

The end result looks spot on to me, but PM me if you want the spreadsheet sample sending on.

McGraw · 05-07-2006, 16:20

Quote:

Originally Posted by littld

I didn't really understand the rest of what you're trying to do - what's with the [[[[ ]]]]?

It was supposed to show how it should look but didn't put the spaces in.

littld · 05-07-2006, 17:07

Quote:

Originally Posted by McGraw

It was supposed to show how it should look but didn't put the spaces in.

I get it now, thanks. Let me know if the advice worked for you.

McGraw · 06-07-2006, 12:30

Thanks for your help. I'm sure it will work but don't have time to sort it at the moment.

Cheers.