Message Box

rc090320

New Member
Joined
Mar 7, 2006
Messages
36
G'day

I've seen a spreadsheet where when you click on the cell it comes up with a box that gives instructions.

As you select the next cell, the same box has a different set of instructions.

It also hovers around so that it moves when the page moves.

However when you select a cell that doesn't have a message attached to it the whole box disappears.

IT IS NOT A COMMENT. The box appears upon selection of the cell not when you hover your mouse onto it like when you have a comment.

It's not a form or a macro as I cannot see anything other than the macro and module I've created.

HOW DO YOU DO THIS??

Any help will be greatly appreciated.

Regards
Ronnie
 

Some videos you may like

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop

Watch MrExcel Video

Forum statistics

Threads
1,113,953
Messages
5,545,148
Members
410,666
Latest member
Al3cs
Top