| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Link Cell to Label Caption
So, I want Cell A1 to equal the value in lbl1.Caption. I tried: Code: -------------------- =lbl1.Caption -------------------- but obviously that didn't work. Any ideas? -- papaitaliano ------------------------------------------------------------------------ papaitaliano's Profile: http://www.excelforum.com/member.php...o&userid=32680 View this thread: http://www.excelforum.com/showthread...hreadid=524861 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Link Cell to Label Caption
activesheet.range("a1").value = lbl1.caption
maybe??? papaitaliano wrote: So, I want Cell A1 to equal the value in lbl1.Caption. I tried: Code: -------------------- =lbl1.Caption -------------------- but obviously that didn't work. Any ideas? -- papaitaliano ------------------------------------------------------------------------ papaitaliano's Profile: http://www.excelforum.com/member.php...o&userid=32680 View this thread: http://www.excelforum.com/showthread...hreadid=524861 -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| hyperlink - link one cell to another in a worksheet. how? | Excel Worksheet Functions | |||
| How to link cell for value in another cell of pivot table? | Excel Discussion (Misc queries) | |||
| Clicking Cell Link Changes Cell on Another Sheet | Excel Discussion (Misc queries) | |||
| Use Cell Content to Build Link | Excel Worksheet Functions | |||
| Link - deactivate being sent to source when click on linked cell? | Excel Worksheet Functions | |||
Hybrid Mode
