Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Text box character limit issue
I'm working with a spreadsheet that has automatic calculation disabled
because a large number of UDF database lookups refer to one cell and recalculating the sheet takes a long time if the wrong selection is made in that cell. The wrong selection is easy to make because the contents are a non-descriptive number that could refer to a list of other items. To work around this, I created a dynamic name that looks up the list of items the non-descript number refers to and linked a text box to that name (the text box will update without recalculating). Last night, I could have sworn the text box was displaying the full cell conents even for those cells containing over 255 characters. Today it stops at 255. Other than saving the spreadsheet, I can't figure out what has changed. Was I hallucinating? If not, how do I get the full text back? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Character limit when retrieving indirect text from external sheet | Excel Worksheet Functions | |||
Text in formular bar doesn't all show (is there a character limit. | Excel Discussion (Misc queries) | |||
Text box character limit | Excel Discussion (Misc queries) | |||
255 Character Limit | Excel Discussion (Misc queries) | |||
Any way to get around the 240-character line limit on text output? | Excel Discussion (Misc queries) |