Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Can anyone please help me, I'm trying to adjust the dropdown list of
the combobox but I need the exact string size. I already searched the net and found that it is computed in pixels and used an API SendMessage For i = 0 To cCmb.ListCount - 1 lResult = SendMessage(hWnd, CB_GETLBTEXTLEN, _ i, ByVal 0) 'MsgBox lResult If (lResult lItemMaxLen) Then sItemText = cCmb.List(i) lItemMaxLen = lResult End If 'MsgBox cCmb.List(i) 'MsgBox lItemMaxLen Next i The problem is that I don't know how can I obtain the handle for the combobox. I also found a code saying how to manipulate the "Name box" and tried to change other parts but it didnt work. Please help me... Thanks a lot in advance... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Fill handle turned into a move handle | Excel Discussion (Misc queries) | |||
Referencing a cell in another worksheet then using fill handle to continue pattern | Excel Discussion (Misc queries) | |||
Worksheet Combobox | Excel Discussion (Misc queries) | |||
How to handle "Invalid Worksheet Name" error programatically in VB | Excel Programming | |||
Copying Worksheet triggers Click event of combobox on another worksheet | Excel Programming |