Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Junior Member
 
Posts: 13
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 84
Default 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


  #3   Report Post  
Junior Member
 
Posts: 13
Default

Thanks Peter T

That fixed the problem.
Sorry for the late reply.

Regards
Deutz

Quote:
Originally Posted by Peter T[_5_] View Post
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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
lisbox reference and calculation SDH Excel Programming 4 April 18th 07 11:22 PM
userform label double-click goes to click event John Paul Fullerton Excel Programming 3 May 19th 06 05:54 PM
LisBox Column Width Abdul[_2_] Excel Programming 4 April 4th 06 07:16 AM
Horizontal Scrollbar For Lisbox Justin Starnes[_2_] Excel Programming 5 October 20th 04 11:26 AM
LisBox List Abdul[_4_] Excel Programming 2 October 8th 03 05:08 PM


All times are GMT +1. The time now is 05:10 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"