| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
determine the actual vissible text
Hi:
I know I can get the text and the value, from he .text,and .value properties. How though can I obtain the text that is actually visible on screen? Cheers Sean. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
determine the actual vissible text
In what circumstances does the Text property not return the text as
displayed? Can you provide and example? Cordially, Chip Pearson Microsoft Most Valuable Professional Excel Product Group, 1998 - 2009 Pearson Software Consulting, LLC www.cpearson.com (email on web site) On Sun, 18 Jan 2009 18:21:45 -0000, "Sean Farrow" wrote: Hi: I know I can get the text and the value, from he .text,and .value properties. How though can I obtain the text that is actually visible on screen? Cheers Sean. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
determine the actual vissible text
You will have to describe to us exactly what you mean by "the text that is
actually visible on the screen". Do you mean you want the text from *every* cell that is in the visible part of the screen? Or do you mean you want the text from a particular cell only if that cell is visible on the screen? What constitutes "visible on the screen"? When it is in the current scroll area? What if the row or column the cell is in is hidden? Or perhaps you have something totally different in mind? -- Rick (MVP - Excel) "Sean Farrow" wrote in message ... Hi: I know I can get the text and the value, from he .text,and .value properties. How though can I obtain the text that is actually visible on screen? Cheers Sean. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
determine the actual vissible text
Rick Rothstein;187661 Wrote: You will have to describe to us exactly what you mean by "the text that is actually visible on the screen". Do you mean you want the text from *every* cell that is in the visible part of the screen? Or do you mean you want the text from a particular cell only if that cell is visible on the screen? What constitutes "visible on the screen"? When it is in the current scroll area? What if the row or column the cell is in is hidden? Or perhaps you have something totally different in mind? -- Rick (MVP - Excel) "Sean Farrow" wrote in message ... Hi: I know I can get the text and the value, from he .text,and .value properties. How though can I obtain the text that is actually visible on screen? Cheers Sean. I don't know if this has any relevance to your problem, but, I discovered recently that the .text property of a Range has a maximum limit to 1024 characters, while the .Value property will return up to 32K, in Excel 2003. -- Leith Ross Sincerely, Leith Ross 'The Code Cage' (http://www.thecodecage.com/) ------------------------------------------------------------------------ Leith Ross's Profile: http://www.thecodecage.com/forumz/member.php?userid=75 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=51748 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
determine the actual vissible text
Hi:
I mean the text visible in the cell on screen. For example is the cell is two small for all the text to fit, I need to know and find out what text currently actually fits in the cell. If say the text: This is a test was the text in a cell but the text: this is a wasall that was visible, I need to know that all the text doesn't fit and tha the text this is a is visible and currently fits in the cell. hope this helps. Sean. "Leith Ross" wrote in message ... Rick Rothstein;187661 Wrote: You will have to describe to us exactly what you mean by "the text that is actually visible on the screen". Do you mean you want the text from *every* cell that is in the visible part of the screen? Or do you mean you want the text from a particular cell only if that cell is visible on the screen? What constitutes "visible on the screen"? When it is in the current scroll area? What if the row or column the cell is in is hidden? Or perhaps you have something totally different in mind? -- Rick (MVP - Excel) "Sean Farrow" wrote in message ... Hi: I know I can get the text and the value, from he .text,and .value properties. How though can I obtain the text that is actually visible on screen? Cheers Sean. I don't know if this has any relevance to your problem, but, I discovered recently that the .text property of a Range has a maximum limit to 1024 characters, while the .Value property will return up to 32K, in Excel 2003. -- Leith Ross Sincerely, Leith Ross 'The Code Cage' (http://www.thecodecage.com/) ------------------------------------------------------------------------ Leith Ross's Profile: http://www.thecodecage.com/forumz/member.php?userid=75 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=51748 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to programmatically determine actual page count in Excel 2003? | Excel Programming | |||
| how do i copy the actual text of a formula? | Excel Discussion (Misc queries) | |||
| equals the actual number...not text ???? | Excel Worksheet Functions | |||
| Can't export actual text - Get #### instead | Excel Discussion (Misc queries) | |||
| Tab in text box inserts actual tab | Excel Programming | |||
Hybrid Mode
