ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Click on userform transfers to lisbox below (https://www.excelbanter.com/excel-programming/446525-click-userform-transfers-lisbox-below.html)

deutz

Click on userform transfers to lisbox below
 
Hi and thanks in advance,

I am using Excel 2003

I have a userform with a listbox. When the user clicks a button on that form it opens another form with colour choices via a whole bunch of image controls. A problem occurs when I click on one of the image controls that sits directly over the listbox on the userform below. What happens is, I click the colour I want and the Colour form closes as expected but the mouse click then selects a row in the userform listbox below.

Thanks

Deutz

Peter T[_5_]

Click on userform transfers to lisbox below
 
Not sure I follow but a wild guess, for the image control try using the
MouseUp event and discard the Click event.

Regards,
Peter T


"deutz" wrote in message
...

Hi and thanks in advance,

I am using Excel 2003

I have a userform with a listbox. When the user clicks a button on that
form it opens another form with colour choices via a whole bunch of
image controls. A problem occurs when I click on one of the image
controls that sits directly over the listbox on the userform below.
What happens is, I click the colour I want and the Colour form closes as
expected but the mouse click then selects a row in the userform listbox
below.

Thanks

Deutz




--
deutz



deutz

Thanks Peter T

That fixed the problem.
Sorry for the late reply.

Regards
Deutz

Quote:

Originally Posted by Peter T[_5_] (Post 1603521)
Not sure I follow but a wild guess, for the image control try using the
MouseUp event and discard the Click event.

Regards,
Peter T


"deutz" wrote in message
...

Hi and thanks in advance,

I am using Excel 2003

I have a userform with a listbox. When the user clicks a button on that
form it opens another form with colour choices via a whole bunch of
image controls. A problem occurs when I click on one of the image
controls that sits directly over the listbox on the userform below.
What happens is, I click the colour I want and the Colour form closes as
expected but the mouse click then selects a row in the userform listbox
below.

Thanks

Deutz




--
deutz



All times are GMT +1. The time now is 10:23 PM.

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