| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Link cell to Label Caption
So, I want Cell A1 to equal the value in lbl1.Caption. I tried: Code ------------------- =lbl1.Captio ------------------- but obviously that didn't work. Any ideas -- papaitalian ----------------------------------------------------------------------- papaitaliano's Profile: http://www.excelforum.com/member.php...fo&userid=3268 View this thread: http://www.excelforum.com/showthread.php?threadid=52486 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Link cell to Label Caption
If using vba then the code is:
Range("A1") = lbl1.caption |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Link cell to Label Caption
Gee....That was easy. Thanks -- papaitalian ----------------------------------------------------------------------- papaitaliano's Profile: http://www.excelforum.com/member.php...fo&userid=3268 View this thread: http://www.excelforum.com/showthread.php?threadid=52486 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| label caption | Excel Discussion (Misc queries) | |||
| Is it a comment ? or a label ? or a caption ?.... | Excel Discussion (Misc queries) | |||
| Linking Cell to Label Caption | Excel Worksheet Functions | |||
| Link Cell to Label Caption | Excel Discussion (Misc queries) | |||
| label caption | Excel Programming | |||
Linear Mode
