Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I wonder if anyone can shed any light on this?
I'm running a query triggered by the change event of a combo box. What it does is to look up the new value for combo1 against a table of possible values for combo2. For counter = 1 To UBound(vaPossActions, 1) If vaPossActions(counter, 1) = flPossActions Then cbSecActions.AddItem vaPossActions(counter, 2) End If Next counter The actual code works fine but, for some unfathomable reason, the data displayed in combo2 is truncated to a fixed width whilst it's being chosen, only when it's selected (and returns to a single line display) does it show the whole line of text. Am I doing something wrong or is this just "one of those things"? TIA Jeff (I'm not a little teapot for replies!) |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
It sounds more like the width of the dropdown list is too narrow.
Look at your setting for the ListWidth property. -- Regards, Tom Ogilvy "Jeff Q" wrote in message ... I wonder if anyone can shed any light on this? I'm running a query triggered by the change event of a combo box. What it does is to look up the new value for combo1 against a table of possible values for combo2. For counter = 1 To UBound(vaPossActions, 1) If vaPossActions(counter, 1) = flPossActions Then cbSecActions.AddItem vaPossActions(counter, 2) End If Next counter The actual code works fine but, for some unfathomable reason, the data displayed in combo2 is truncated to a fixed width whilst it's being chosen, only when it's selected (and returns to a single line display) does it show the whole line of text. Am I doing something wrong or is this just "one of those things"? TIA Jeff (I'm not a little teapot for replies!) |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() "Tom Ogilvy" wrote in message ... It sounds more like the width of the dropdown list is too narrow. Look at your setting for the ListWidth property. -- Regards, Tom Ogilvy Tom, you really are frighteningly good!! To my mind this combobox width is a really strange behaviour, especially as their seems to be no "autosize" type functionality Jeff |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how do I stop my text being truncated at RHS of a cell? | Excel Discussion (Misc queries) | |||
Pasted Text Truncated? | New Users to Excel | |||
Text in cells is truncated. | Excel Discussion (Misc queries) | |||
Truncated text when copying text from one excel doc to another | Excel Discussion (Misc queries) | |||
Textbox Text is Truncated | Excel Programming |