View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] dantericafort@gmail.com is offline
external usenet poster
 
Posts: 1
Default 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...