ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Excel Combobox Box Control (https://www.excelbanter.com/excel-programming/358455-excel-combobox-box-control.html)

[email protected]

Excel Combobox Box Control
 
I would like the code or property to make a combobox visible only when
the mouse rolls over it. This is for use in an excel worksheet. Thank
you in advance for your help.


Papou

Excel Combobox Box Control
 
Hello

Use the MouseMove event (see code sample below) but before that, I would
suggest that you make some kind of a sign nearby your control, otherwise
users will hardly know where to go!

Private Sub ComboBox1_MouseMove(ByVal Button As Integer, _
ByVal Shift As Integer, ByVal X As Single, ByVal Y As Single)
ComboBox1.Visible = True
End Sub

HTH
Cordially
Pascal

a écrit dans le message de news:
...
I would like the code or property to make a combobox visible only when
the mouse rolls over it. This is for use in an excel worksheet. Thank
you in advance for your help.




Papou

Excel Combobox Box Control
 
Forget my answer I've just tested it does not seem to work.

Cordially
Pascal

"papou" <cestpasbon@çanonplus a écrit dans le message de news:
...
Hello

Use the MouseMove event (see code sample below) but before that, I would
suggest that you make some kind of a sign nearby your control, otherwise
users will hardly know where to go!

Private Sub ComboBox1_MouseMove(ByVal Button As Integer, _
ByVal Shift As Integer, ByVal X As Single, ByVal Y As Single)
ComboBox1.Visible = True
End Sub

HTH
Cordially
Pascal

a écrit dans le message de news:
...
I would like the code or property to make a combobox visible only when
the mouse rolls over it. This is for use in an excel worksheet. Thank
you in advance for your help.







All times are GMT +1. The time now is 12:16 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com