Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Highlighting contents of cells


Hi,

I would like the contents of cells to appear in a little box above i
so that when i have cells that are thinner than the contents it's eas
for people to see what's in the cell without having to expand th
column.

It's a bit hard to explain. But you can see what I mean when you hove
the mouse over a button and a few seconds later the word 'Print' appear
below it.

Anyone know how to do this in VBA for a cell in a worksheet?

Thanks,

Hele

--
Darlajan
-----------------------------------------------------------------------
Darlajane's Profile: http://www.excelforum.com/member.php...fo&userid=1532
View this thread: http://www.excelforum.com/showthread.php?threadid=31486

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 212
Default Highlighting contents of cells

Add comment to that cell, copy the cell content in to comment text, size the
comment baloon properly and keep the comment always visible.
Sharad
"Darlajane" wrote in message
...

Hi,

I would like the contents of cells to appear in a little box above it
so that when i have cells that are thinner than the contents it's easy
for people to see what's in the cell without having to expand the
column.

It's a bit hard to explain. But you can see what I mean when you hover
the mouse over a button and a few seconds later the word 'Print' appears
below it.

Anyone know how to do this in VBA for a cell in a worksheet?

Thanks,

Helen


--
Darlajane
------------------------------------------------------------------------
Darlajane's Profile:
http://www.excelforum.com/member.php...o&userid=15326
View this thread: http://www.excelforum.com/showthread...hreadid=314868



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
concatenate contents of cells whose contents resemble cell referem cathyh Excel Worksheet Functions 3 May 23rd 09 12:16 PM
compare the contents of one range of cells with the contents of a. Dozy123 Excel Discussion (Misc queries) 1 January 24th 07 10:14 AM
HIGHLIGHTING CELLS Dave803 Excel Discussion (Misc queries) 6 November 28th 05 12:29 AM
Highlighting blanks via GO TO SPECIAL is not highlighting blank cells - HELP, I'm totally stuck. Jamie Furlong Excel Discussion (Misc queries) 6 August 28th 05 09:27 PM
Highlighting 'corresponding' cells R. Todd Miller Excel Programming 2 July 18th 03 07:46 PM


All times are GMT +1. The time now is 07:05 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"