How to get handle to a control on a spreadsheet?

[rdwray]

How do I get the handle for a combobox on a spreadsheet? I have tried ChildWindowFromPoint and RealChildWindowFromPoint without any luck. Thanks...

 

[rdwray]

Thanks Jaafar, I would have been looking for a long time to put this one together.

 

[John Douglas]

This is the exact code I need, but I require for a Combo Box. Is there a straight forward modification I can do to the code to make the Combobox scroll? Private Sub ComboBox1_MouseMove(ByVal Button As Integer, ByVal Shift As Integer, ByVal X As Single, ByVal Y As Single) Call HookListBox(Me.ComboBox1) End Sub Private Sub ListBox1_MouseMove(ByVal Button As Integer, ByVal Shift As Integer, ByVal X As Single, ByVal Y As Single) Call HookListBox(Me.ListBox1) End Sub

 

[John Douglas]

Can this code be modified to work with a Combo Box, as well as the list box? Thanks in advance