How to get handle of Combobox in worksheet
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...
|