Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default ControlTipText in a ListBox, doesnt refresh


Hellos,

I've been grinding information for the last 6hours with no success :(

I have a listbox in a form, 4 columns, n rows
I would like to use the MouseMove event to populate a new
ControlTipText depending on the column the user is over.
Knowing the width of the columns, i though it would be easy to play
with X to see in which column i am and populate the ControlTipText
accordingly.

Works really well for the first MouseMove, but the ControlTipText is
not refreshed when i move the mouse over the other columns. I have to
leave the control (listbox) and come back over it to refresh the
ControlTipText... kind of annoying...

Anyone knows/think of a work around i could use, would be greatly
appreciated.

Thanks

Vel

Private Sub ListBox2_MouseMove(ByVal Button As Integer, ByVal Shift As
Integer, ByVal X As Single, ByVal Y As Single)
Me.ListBox2.ControlTipText = "will parse the value"
End Sub


--
Velune
------------------------------------------------------------------------
Velune's Profile: http://www.excelforum.com/member.php...o&userid=30124
View this thread: http://www.excelforum.com/showthread...hreadid=498116

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
Listbox that dont refresh automatically Freddie[_2_] Excel Programming 1 October 8th 04 07:25 AM
OLE ListBox refresh Ken McLennan[_3_] Excel Programming 2 June 29th 04 02:02 PM
ControlTipText style phreud[_4_] Excel Programming 0 June 9th 04 09:09 PM
Refresh listbox on userform1 Jason Morin[_2_] Excel Programming 1 February 25th 04 02:11 PM
listbox will not refresh JSnader Excel Programming 1 December 8th 03 12:20 AM


All times are GMT +1. The time now is 08:31 PM.

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"