MSFlex Grid Control - Fixed Rows

[Otie]

Hello,

I am using the MSFlexGrd Control in VB5. I have 1 fixed row and one fixed
column. I am trying to do a sort when the user clicks a column in the FIXED
ROW. But when I capture the row number in the click event I get row = 1 if I
click on the FIXED row OR the actual row 1. How can I get the grid control
to tell me when the user has clicked on the FIXED row and not on row 1
(since they both produce row = 1 and I cannot tell them apart when it does
this)?

Thank you.
Otis

[Randy Birch]

????

You say you want to sort when the user clicks a column in the fixed row
(which is the row across the top of the control), then go on to say you are
capturing the row number in the click event which will always be (correctly)
1 because clicking the header selects the entire column and moves the focus
rectangle to the first work row (the row 1 you mention).

If you want to determine the column clicked when a header in the top fixed
row is clicked, all you need is:

Private Sub MSFlexGrid1_MouseDown(...
If MSFlexGrid1.Row = 1 Then
Debug.Print MSFlexGrid1.Col
End If
End Sub
Similarly the reverse holds true for detecting the row clicks when the row
fixed header is clicked:

Private Sub MSFlexGrid1_MouseDown(...
If MSFlexGrid1.Col= 1 Then
Debug.Print MSFlexGrid1.Row
End If
End Sub

--

Randy Birch
MS MVP Visual Basic
http://vbnet.mvps.org/

Please reply to the newsgroups so all can participate.


"Otie" <ot*********@adelphia.net> wrote in message
news:SI********************@adelphia.com...
Hello,

I am using the MSFlexGrd Control in VB5. I have 1 fixed row and one fixed
column. I am trying to do a sort when the user clicks a column in the FIXED
ROW. But when I capture the row number in the click event I get row = 1 if I
click on the FIXED row OR the actual row 1. How can I get the grid control
to tell me when the user has clicked on the FIXED row and not on row 1
(since they both produce row = 1 and I cannot tell them apart when it does
this)?

Thank you.
Otis

[Rick Rothstein [MVP - Visual Basic]]

You can also use the MouseRow and MouseCol properties.

Rick

"Randy Birch" <rg************@mvps.org> wrote in message
news:44**********************@news.astraweb.com...

????

You say you want to sort when the user clicks a column in the fixed row
(which is the row across the top of the control), then go on to say you are capturing the row number in the click event which will always be (correctly) 1 because clicking the header selects the entire column and moves the focus rectangle to the first work row (the row 1 you mention).

If you want to determine the column clicked when a header in the top fixed
row is clicked, all you need is:

Private Sub MSFlexGrid1_MouseDown(...
If MSFlexGrid1.Row = 1 Then
Debug.Print MSFlexGrid1.Col
End If
End Sub
Similarly the reverse holds true for detecting the row clicks when the row
fixed header is clicked:

Private Sub MSFlexGrid1_MouseDown(...
If MSFlexGrid1.Col= 1 Then
Debug.Print MSFlexGrid1.Row
End If
End Sub

--

Randy Birch
MS MVP Visual Basic
http://vbnet.mvps.org/

Please reply to the newsgroups so all can participate.


"Otie" <ot*********@adelphia.net> wrote in message
news:SI********************@adelphia.com...
Hello,

I am using the MSFlexGrd Control in VB5. I have 1 fixed row and one fixed
column. I am trying to do a sort when the user clicks a column in the FIXED ROW. But when I capture the row number in the click event I get row = 1 if I click on the FIXED row OR the actual row 1. How can I get the grid control
to tell me when the user has clicked on the FIXED row and not on row 1
(since they both produce row = 1 and I cannot tell them apart when it does
this)?

Thank you.
Otis

[Otie]

I think you misunderstand.

When I click on column 9 in the fixed row, VB returns row = 1. I want this
click to do a sort on the data in column 9.
But when I click on the CELL in column 9, row 1, or any row, I want to take
that cell value and store it somewhere.
The problem with VB is that if you click on any column in a fixed row it
returns the row number as if you had clicked on the actual row 1, not in the
fixed row. These different clicks (one on the fixed row, column 9 and the
other on the actual row 1 [non-fixed row], column 9) HAVE TO be detected
differently or else I am screwed (I won't be able to detect when the user
wants to sort versus when he wants to capture cell contents.

I hope I am more clear here.

I will try Rick's suggestion about MouseRow.

Thank you.

--

Otis

"Randy Birch" <rg************@mvps.org> wrote in message
news:44**********************@news.astraweb.com...

????

You say you want to sort when the user clicks a column in the fixed row
(which is the row across the top of the control), then go on to say you
are
capturing the row number in the click event which will always be
(correctly)
1 because clicking the header selects the entire column and moves the
focus
rectangle to the first work row (the row 1 you mention).

If you want to determine the column clicked when a header in the top fixed
row is clicked, all you need is:

Private Sub MSFlexGrid1_MouseDown(...
If MSFlexGrid1.Row = 1 Then
Debug.Print MSFlexGrid1.Col
End If
End Sub
Similarly the reverse holds true for detecting the row clicks when the row
fixed header is clicked:

Private Sub MSFlexGrid1_MouseDown(...
If MSFlexGrid1.Col= 1 Then
Debug.Print MSFlexGrid1.Row
End If
End Sub

--

Randy Birch
MS MVP Visual Basic
http://vbnet.mvps.org/

Please reply to the newsgroups so all can participate.


"Otie" <ot*********@adelphia.net> wrote in message
news:SI********************@adelphia.com...
Hello,

I am using the MSFlexGrd Control in VB5. I have 1 fixed row and one fixed
column. I am trying to do a sort when the user clicks a column in the
FIXED
ROW. But when I capture the row number in the click event I get row = 1 if
I
click on the FIXED row OR the actual row 1. How can I get the grid control
to tell me when the user has clicked on the FIXED row and not on row 1
(since they both produce row = 1 and I cannot tell them apart when it does
this)?

Thank you.
Otis

[Otie]

From VB Help (don't know why I didn't see this - have used the grid control
for years - yikes!):
MouseCol, MouseRow Properties

Remarks

Use these properties programmatically to determine the mouse location. These
properties are useful in displaying context-sensitive help for individual
cells and testing whether the user has clicked on a fixed row or column.

This looks like the way to do it.

Thank you so much.


--
Otis

"Rick Rothstein [MVP - Visual Basic]" <ri************@NOSPAMcomcast.net>
wrote in message news:Vp********************@comcast.com...

You can also use the MouseRow and MouseCol properties.

Rick

"Randy Birch" <rg************@mvps.org> wrote in message
news:44**********************@news.astraweb.com...

????

You say you want to sort when the user clicks a column in the fixed row
(which is the row across the top of the control), then go on to say you

are

capturing the row number in the click event which will always be

(correctly)

1 because clicking the header selects the entire column and moves the

focus

rectangle to the first work row (the row 1 you mention).

If you want to determine the column clicked when a header in the top
fixed
row is clicked, all you need is:

Private Sub MSFlexGrid1_MouseDown(...
If MSFlexGrid1.Row = 1 Then
Debug.Print MSFlexGrid1.Col
End If
End Sub
Similarly the reverse holds true for detecting the row clicks when the
row
fixed header is clicked:

Private Sub MSFlexGrid1_MouseDown(...
If MSFlexGrid1.Col= 1 Then
Debug.Print MSFlexGrid1.Row
End If
End Sub

--

Randy Birch
MS MVP Visual Basic
http://vbnet.mvps.org/

Please reply to the newsgroups so all can participate.


"Otie" <ot*********@adelphia.net> wrote in message
news:SI********************@adelphia.com...
Hello,

I am using the MSFlexGrd Control in VB5. I have 1 fixed row and one fixed
column. I am trying to do a sort when the user clicks a column in the

FIXED

ROW. But when I capture the row number in the click event I get row = 1
if

I

click on the FIXED row OR the actual row 1. How can I get the grid
control
to tell me when the user has clicked on the FIXED row and not on row 1
(since they both produce row = 1 and I cannot tell them apart when it
does
this)?

Thank you.
Otis