Wilder1626
asked on
VB6 number of the row dbclick
Hello all
I have this macro below that transfer data into my form 8 when i double click in a specific cell in my MSHFlexgrid.
Now, i would like to add in a TEXT13 the row number from the grid.
Ex:
I f i double click in the 3rd row, it will put 3 in my TEXT13.
How can i do that?
Thanks again for your help
I have this macro below that transfer data into my form 8 when i double click in a specific cell in my MSHFlexgrid.
Now, i would like to add in a TEXT13 the row number from the grid.
Ex:
I f i double click in the 3rd row, it will put 3 in my TEXT13.
How can i do that?
Thanks again for your help
On Error GoTo handler
Form8.Show
Form8.Text0 = Trim(Form3.MSHFlexGrid1.TextMatrix(MSHFlexGrid1.Row, 3))
Form8.Text00 = Trim(Form3.MSHFlexGrid1.TextMatrix(MSHFlexGrid1.Row, 4))
Form8.Text3 = Trim(Form3.MSHFlexGrid1.TextMatrix(MSHFlexGrid1.Row, 9))
Form8.Text4 = Trim(Form3.MSHFlexGrid1.TextMatrix(MSHFlexGrid1.Row, 11))
Form8.Text5 = Trim(Form3.MSHFlexGrid1.TextMatrix(MSHFlexGrid1.Row, 12))
Form8.Text6 = Trim(Form3.MSHFlexGrid1.TextMatrix(MSHFlexGrid1.Row, 13))
Form8.Text7 = Trim(Form3.MSHFlexGrid1.TextMatrix(MSHFlexGrid1.Row, 15))
Form8.Text8 = Trim(Form3.MSHFlexGrid1.TextMatrix(MSHFlexGrid1.Row, 16))
Form8.Text9 = Trim(Form3.MSHFlexGrid1.TextMatrix(MSHFlexGrid1.Row, 17))
Form8.Text10 = Trim(Form3.MSHFlexGrid1.TextMatrix(MSHFlexGrid1.Row, 20)) '
Form8.Text11 = Trim(Form3.MSHFlexGrid1.TextMatrix(MSHFlexGrid1.Row, 21))
Form8.Text12 = Trim(Form3.MSHFlexGrid1.TextMatrix(MSHFlexGrid1.Row, 23))
Exit Sub
handler:
MsgBox "Try again"
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi,
this is perfect. Actually i will only use this and it work:
Form8.row_num = Form3.MSHFlexGrid1.Row
Thanks again
this is perfect. Actually i will only use this and it work:
Form8.row_num = Form3.MSHFlexGrid1.Row
Thanks again
You're welcome and I'm glad I was able to help.
Select the 'About Me' tab in my profile and you'll find links to some articles I've written that may interest you.
Marty - MVP 2009 to 2013
Select the 'About Me' tab in my profile and you'll find links to some articles I've written that may interest you.
Marty - MVP 2009 to 2013
http://vbcity.com/forums/t/23153.aspx
Open in new window