Solved

How to ensure that a single row will highlight in mshflexgrid.mousemove event.

Posted on 2003-10-23
3
223 Views
Last Modified: 2010-05-01
Dear experts
         I have spent 100 points already for this question but these became useless due to it was not on proper place.
        I want to arrange a subroutine in which i want to select the specific row in mouse move event like this
                 sub mshlfexgrid1_mousemove()
                      mshflexgrid1.row=mshflexgrid1.mouserow
                      mshflexgrid1.rowsel=mshflexgrid1.row
                     end if
but this subroutine highlights nothing just change the row of flexgrid. if i change the routine like this.
             mshflexgrid1.rowsel=mshflexgrid1.mouserow
then it highlights the multi row not a single row each time.
pls help me in thins contest.
thanks
Ali
0
Comment
Question by:ALIHAIDER1
3 Comments
 
LVL 5

Expert Comment

by:jayeshshah
ID: 9609076
change the
allowBigSelection property to false and then use the above code as

Private Sub MSHFlexGrid1_MouseMove(Button As Integer, Shift As Integer, x As Single, y As Single)
    MSHFlexGrid1.Row = MSHFlexGrid1.MouseRow
    MSHFlexGrid1.RowSel = MSHFlexGrid1.MouseRow
End Sub

K'Regards

Jayesh
0
 

Author Comment

by:ALIHAIDER1
ID: 9612474
Sorry Jayesh
      Nothing happened. Result is as it was before.
Any other opinion.
Ali
0
 

Accepted Solution

by:
Mahesh_kn earned 100 total points
ID: 9615489
Hi

Try this

Private Sub MSHFlexGrid1_mousemove(Button As Integer, Shift As Integer, x As Single, y As Single)
    If MSHFlexGrid1.Row <> MSHFlexGrid1.MouseRow Then
        MSHFlexGrid1.Row = MSHFlexGrid1.MouseRow
        MSHFlexGrid1.ColSel = MSHFlexGrid1.Cols - 1
    End If
End Sub

For better look change the property FocusRect = flexFocusNone

Mahesh
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction In a recent article (http://www.experts-exchange.com/A_7811-A-Better-Concatenate-Function.html) for the Excel community, I showed an improved version of the Excel Concatenate() function.  While writing that article I realized that no o…
Have you ever wanted to restrict the users input in a textbox to numbers, and while doing that make sure that they can't 'cheat' by pasting in non-numeric text? Of course you can do that with code you write yourself but it's tedious and error-prone …
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…

815 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now