PritishS
Board Regular
- Joined
- Dec 29, 2015
- Messages
- 119
- Office Version
- 2007
- Platform
- Windows
Dear Sir/Madam,
I'm having a Simple yet difficult problem which I can't figure out. I'm still a self learner of macro.
My doubt:
I have a Table where 5 column and many rows are there. All row of Col-A have a CheckBox (I added it from Developer Tab). Col-B, Col-C, Col-D and Col-E has value till many rows.
[TABLE="width: 500"]
<tbody>[TR]
[TD]Col-A[/TD]
[TD]COL-B[/TD]
[TD]COL-C[/TD]
[TD]COL-D[/TD]
[TD]COL-E[/TD]
[/TR]
[TR]
[TD]Chkbox[/TD]
[TD]XYZ[/TD]
[TD]XSE[/TD]
[TD]ASD[/TD]
[TD]WER[/TD]
[/TR]
[TR]
[TD]Chkbox[/TD]
[TD]QWE[/TD]
[TD]QQW[/TD]
[TD]QQW[/TD]
[TD]WEE[/TD]
[/TR]
[TR]
[TD]Chkbox[/TD]
[TD]FGT[/TD]
[TD]RTY[/TD]
[TD]WQA[/TD]
[TD]LKK[/TD]
[/TR]
</tbody>[/TABLE]
Now If I click on Chkbox in Col A-1, then data of Col-B,C,D & E will be selected
I recorded a macro and assigned it to Chkbox in Col A-1
But my requirement is, if I select checkbox in Col-A-2, then it should select Col-B2,C2,D2 & E2 and so on....
Problem 1:
Problem is I have many rows and I can not write that above code for each rows and assign it to particular checkbox.
Is there any possible way to do the above method with a single code which will be assigned to all checkbox?
Problem 2:
I want to select multiple checkbox and multiple row should be selected (as we manually select by pressing CTRL Key and Mouseover cells). Is it possible?
Please help me. I trying my best to find the solution but seems that's not enough.
Thanks & Regards,
PritishS
I'm having a Simple yet difficult problem which I can't figure out. I'm still a self learner of macro.
My doubt:
I have a Table where 5 column and many rows are there. All row of Col-A have a CheckBox (I added it from Developer Tab). Col-B, Col-C, Col-D and Col-E has value till many rows.
[TABLE="width: 500"]
<tbody>[TR]
[TD]Col-A[/TD]
[TD]COL-B[/TD]
[TD]COL-C[/TD]
[TD]COL-D[/TD]
[TD]COL-E[/TD]
[/TR]
[TR]
[TD]Chkbox[/TD]
[TD]XYZ[/TD]
[TD]XSE[/TD]
[TD]ASD[/TD]
[TD]WER[/TD]
[/TR]
[TR]
[TD]Chkbox[/TD]
[TD]QWE[/TD]
[TD]QQW[/TD]
[TD]QQW[/TD]
[TD]WEE[/TD]
[/TR]
[TR]
[TD]Chkbox[/TD]
[TD]FGT[/TD]
[TD]RTY[/TD]
[TD]WQA[/TD]
[TD]LKK[/TD]
[/TR]
</tbody>[/TABLE]
Now If I click on Chkbox in Col A-1, then data of Col-B,C,D & E will be selected
I recorded a macro and assigned it to Chkbox in Col A-1
Code:
Sub Select_Data()
Range("B1:E1").Select
End Sub
But my requirement is, if I select checkbox in Col-A-2, then it should select Col-B2,C2,D2 & E2 and so on....
Problem 1:
Problem is I have many rows and I can not write that above code for each rows and assign it to particular checkbox.
Is there any possible way to do the above method with a single code which will be assigned to all checkbox?
Problem 2:
I want to select multiple checkbox and multiple row should be selected (as we manually select by pressing CTRL Key and Mouseover cells). Is it possible?
Please help me. I trying my best to find the solution but seems that's not enough.
Thanks & Regards,
PritishS