Posted to microsoft.public.excel.programming

external usenet poster

Posts: 20

label caption changes depending on activecell

Hi i have a worksheet with a label on it. and i want its caption to
change depending on which cell is highlighted on the time.

say if cell A3 is highlighted the label shows 'msg1'. and if A7 was
highlighted label shows 'msg2'.

thanks in advance.
nick

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

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
label caption	gramps	Excel Discussion (Misc queries)	0	November 1st 07 03:56 PM
Dynamic Label Caption	Turtle MacDermott	Excel Programming	6	November 22nd 04 02:43 PM
Label - Caption not changing	Brian Hribek[_2_]	Excel Programming	0	October 11th 04 10:02 PM
Label - Caption not changing	Brian Hribek	Excel Programming	1	October 11th 04 09:19 PM
label caption	Rod Taylor	Excel Programming	2	July 31st 03 03:25 AM

All times are GMT +1. The time now is 11:00 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us