Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combobox width not showing full data
Hi all,
I have completed a project with the help of this NG which is running fine but having a small problem. I have a combobox on a userform. This box shows texts strings collected from the sheets. This text is not shown in full. I have tried to increase the box width but then texts are shown in part only. rest of the width of box dropdown is blank. Even I can see the half cherecter indicating there is text but is not shown full. There must be a setting for this and I am surly overlooking the same. Pl help. Regards, Madiya |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combobox width not showing full data
What did you mean when you said "I have tried to increase the box width"?
How (by what means) did you increase it? Rick "Madiya" wrote in message ... Hi all, I have completed a project with the help of this NG which is running fine but having a small problem. I have a combobox on a userform. This box shows texts strings collected from the sheets. This text is not shown in full. I have tried to increase the box width but then texts are shown in part only. rest of the width of box dropdown is blank. Even I can see the half cherecter indicating there is text but is not shown full. There must be a setting for this and I am surly overlooking the same. Pl help. Regards, Madiya |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combobox width not showing full data
By the way, there is a ListWidth property you can set to make the drop-down
portion of the control wider than the edit field (plus drop down arrow) section... is that what you were trying to accomplish? Rick "Rick Rothstein (MVP - VB)" wrote in message ... What did you mean when you said "I have tried to increase the box width"? How (by what means) did you increase it? Rick "Madiya" wrote in message ... Hi all, I have completed a project with the help of this NG which is running fine but having a small problem. I have a combobox on a userform. This box shows texts strings collected from the sheets. This text is not shown in full. I have tried to increase the box width but then texts are shown in part only. rest of the width of box dropdown is blank. Even I can see the half cherecter indicating there is text but is not shown full. There must be a setting for this and I am surly overlooking the same. Pl help. Regards, Madiya |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combobox width not showing full data
On Feb 25, 2:23*pm, "Rick Rothstein \(MVP - VB\)"
wrote: By the way, there is a ListWidth property you can set to make the drop-down portion of the control wider than the edit field (plus drop down arrow) section... is that what you were trying to accomplish? Rick "Rick Rothstein (MVP - VB)" wrote in l... What did you mean when you said "I have tried to increase the box width"? How (by what means) did you increase it? Rick "Madiya" wrote in message ... Hi all, I have completed a project with the help of this NG which is running fine but having a small problem. I have a combobox on a userform. This box shows texts strings collected *from the sheets. This text is not shown in full. I have tried to increase the box width but then texts are shown in part only. rest of the width of box dropdown is blank. Even I can see the half cherecter indicating there is text but is not shown full. There must be a setting for this and I am surly overlooking the same. Pl help. Regards, Madiya- Hide quoted text - - Show quoted text - Rick, Thanks for reply. I opened vba editor and dragged the comboboc border to increase its width. Now I tried listwidth also. It increase the width of the dropdown but is not fully filled up with the data. for e.g. if text tring is "this is great NG to lot of things" then combobox width is ==================== box drop down width is (increased with listwidth as suggested by you) ================================= text appearing width is ============ text appeared is this is great NG t rest of the text is cut and is not appearing. Any thoughts? Hope I am explaining properly. Regards, Madiya |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combobox width not showing full data
On Feb 25, 3:00*pm, Madiya wrote:
On Feb 25, 2:23*pm, "Rick Rothstein \(MVP - VB\)" wrote: By the way, there is a ListWidth property you can set to make the drop-down portion of the control wider than the edit field (plus drop down arrow) section... is that what you were trying to accomplish? Rick "Rick Rothstein (MVP - VB)" wrote in l... What did you mean when you said "I have tried to increase the box width"? How (by what means) did you increase it? Rick "Madiya" wrote in message .... Hi all, I have completed a project with the help of this NG which is running fine but having a small problem. I have a combobox on a userform. This box shows texts strings collected *from the sheets. This text is not shown in full. I have tried to increase the box width but then texts are shown in part only. rest of the width of box dropdown is blank. Even I can see the half cherecter indicating there is text but is not shown full. There must be a setting for this and I am surly overlooking the same. Pl help. Regards, Madiya- Hide quoted text - - Show quoted text - Rick, Thanks for reply. I opened vba editor and dragged the comboboc border to increase its width. Now I tried listwidth also. It increase the width of the dropdown but is not fully filled up with the data. for e.g. if text tring is "this is great NG to lot of things" then combobox width is ==================== box drop down width is (increased with listwidth as suggested by you) ================================= text appearing width is ============ text appeared is this is great NG t rest of the text is cut and is not appearing. Any thoughts? Hope I am explaining properly. Regards, Madiya- Hide quoted text - - Show quoted text - Hi Rick, Got it. It was the Columnwidths property which needs tweeking. Still thanks to set me on the right track. Regards, Madiya |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combobox width not showing full data
Thanks for reply.
I opened vba editor and dragged the comboboc border to increase its width. Now I tried listwidth also. It increase the width of the dropdown but is not fully filled up with the data. for e.g. if text tring is "this is great NG to lot of things" then combobox width is ==================== box drop down width is (increased with listwidth as suggested by you) ================================= text appearing width is ============ text appeared is this is great NG t rest of the text is cut and is not appearing. The ComboBox is made up of two parts (not counting the drop down arrow)... a TextBox that you can type into (what I think you are calling the ComboBox width and which is sometimes called an Edit Field) and a ListBox that drops down when you click the drop down arrow on the right side of the TextBox. Now, are you saying that in the ListBox part, that the text is truncated as shown above (with a lot of white space after it)? If so, that is a new one on me... I've not seen that before. The only way I can duplicate what I think you are describing is to set the ColumnCount to a value greater than 1 and also set the ColumnWidth to a value less than the number of points necessary to display a complete line of text. Do you by any chance have these two properties set like this? Rick |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combobox width not showing full data
On Feb 25, 3:29*pm, "Rick Rothstein \(MVP - VB\)"
wrote: Thanks for reply. I opened vba editor and dragged the comboboc border to increase its width. Now I tried listwidth also. It increase the width of the dropdown but is not fully filled up with the data. for e.g. if text tring is "this is great NG to lot of things" then combobox width is ==================== box drop down width is (increased with listwidth as suggested by you) ================================= text appearing width is ============ text appeared is this is great NG t rest of the text is cut and is not appearing. The ComboBox is made up of two parts (not counting the drop down arrow)... a TextBox that you can type into (what I think you are calling the ComboBox width and which is sometimes called an Edit Field) and a ListBox that drops down when you click the drop down arrow on the right side of the TextBox. Now, are you saying that in the ListBox part, that the text is truncated as shown above (with a lot of white space after it)? If so, that is a new one on me... I've not seen that before. The only way I can duplicate what I think you are describing is to set the ColumnCount to a value greater than 1 and also set the ColumnWidth to a value less than the number of points necessary to display a complete line of text. Do you by any chance have these two properties set like this? Rick- Hide quoted text - - Show quoted text - Hi Rick, You gussed right. I had a problem with the dropdown list part, where text is truncated with lots of trailing white spaces even when width of dropdown list is much bigger. I have a column count as 1 only which desplays text of one cell only. If I put a very long text, then the text will be truncated and part of the text will be shown. Rest of the width of the dropdown list will be filled up with white spaces. If I increase Columnwidths property, entire text is desplayed. Hope this explaination is ok. If you need any more info or want me to do some trials, I will gladly do it becouse you people are helping lots of other novises like me. Regatds, Madiya |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combobox width not showing full data
I opened vba editor and dragged the comboboc border to
increase its width. Now I tried listwidth also. It increase the width of the dropdown but is not fully filled up with the data. for e.g. if text tring is "this is great NG to lot of things" then combobox width is ==================== box drop down width is (increased with listwidth as suggested by you) ================================= text appearing width is ============ text appeared is this is great NG t rest of the text is cut and is not appearing. The ComboBox is made up of two parts (not counting the drop down arrow)... a TextBox that you can type into (what I think you are calling the ComboBox width and which is sometimes called an Edit Field) and a ListBox that drops down when you click the drop down arrow on the right side of the TextBox. Now, are you saying that in the ListBox part, that the text is truncated as shown above (with a lot of white space after it)? If so, that is a new one on me... I've not seen that before. The only way I can duplicate what I think you are describing is to set the ColumnCount to a value greater than 1 and also set the ColumnWidth to a value less than the number of points necessary to display a complete line of text. Do you by any chance have these two properties set like this? Rick- Hide quoted text - - Show quoted text - Hi Rick, You gussed right. I had a problem with the dropdown list part, where text is truncated with lots of trailing white spaces even when width of dropdown list is much bigger. I have a column count as 1 only which desplays text of one cell only. If I put a very long text, then the text will be truncated and part of the text will be shown. Rest of the width of the dropdown list will be filled up with white spaces. If I increase Columnwidths property, entire text is desplayed. Hope this explaination is ok. If you need any more info or want me to do some trials, I will gladly do it becouse you people are helping lots of other novises like me. Since you have identified your problem was with the ColumnWidth property setting, I'm assuming you handled the problem by resetting this property. Do you still have a question pending or has it been resolved (kind of hard to tell by the way you ended your last message to me)? Rick |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combobox width not showing full data
On Feb 26, 9:30*pm, "Rick Rothstein \(MVP - VB\)"
wrote: I opened vba editor and dragged the comboboc border to increase its width. Now I tried listwidth also. It increase the width of the dropdown but is not fully filled up with the data. for e.g. if text tring is "this is great NG to lot of things" then combobox width is ==================== box drop down width is (increased with listwidth as suggested by you) ================================= text appearing width is ============ text appeared is this is great NG t rest of the text is cut and is not appearing. The ComboBox is made up of two parts (not counting the drop down arrow)... a TextBox that you can type into (what I think you are calling the ComboBox width and which is sometimes called an Edit Field) and a ListBox that drops down when you click the drop down arrow on the right side of the TextBox. Now, are you saying that in the ListBox part, that the text is truncated as shown above (with a lot of white space after it)? If so, that is a new one on me... I've not seen that before. The only way I can duplicate what I think you are describing is to set the ColumnCount to a value greater than 1 and also set the ColumnWidth to a value less than the number of points necessary to display a complete line of text. Do you by any chance have these two properties set like this? Rick- Hide quoted text - - Show quoted text - Hi Rick, You gussed right. I had a problem with the dropdown list part, where text is truncated with lots of trailing white spaces even when width of dropdown list is much bigger. I have a column count as 1 only which desplays text of one cell only. If I put a very long text, then the text will be truncated and part of the text *will be shown. Rest of the width of the dropdown list will be filled up with white spaces. If I increase Columnwidths property, entire text is desplayed. Hope this explaination is ok. If you need any more info or want me to do some trials, I will gladly do it becouse you people are helping lots of other novises like me. Since you have identified your problem was with the ColumnWidth property setting, I'm assuming you handled the problem by resetting this property. Do you still have a question pending or has it been resolved (kind of hard to tell by the way you ended your last message to me)? Rick- Hide quoted text - - Show quoted text - Problem is solved. Thanks again. Regards, Madiya |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Concvert Full Width Katakana characters into Half Width Katakana C | Excel Programming | |||
Concvert Full Width Katakana characters into Half Width Katakana C | Excel Discussion (Misc queries) | |||
width of ComboBox for data validation | Excel Discussion (Misc queries) | |||
How can I control the full screen display width ? | Excel Discussion (Misc queries) | |||
ASC() does not convert full-width to half-width letters (Exel 2003 | Excel Worksheet Functions |