straw
12-15-2011, 07:06 AM
Dear all,
I am trying to write a VBA code for statistics purpose in EXCEL. For example:
(Given)---space---(Count by VBA)
Statistics---space---Binomial Times
1 <<Box A1---space--- 3 (means there are "1" X 3) <<BOX B2
1 -------space---------1<<in red text (means there is "0" X 1) <<BOX B3
1 -------space---------1 (means there is "1" X 1) <<BOX B4
0 -------space---------4 <<in red text (means there are "0" X 4)
1 -------space---------2 (means there are "2" X 2)
0 -------space---------and so on
0
0
0
1
1
and so on
=================================================
List (BOX D2) = all "1" Times ( black text in colume B)
List (BOX E3) = all "0" Times (red text in colume B)
I know it's too complicated and I don't know if it is possible to do this redundant steps by VBA code. Since I am still at the very beginning level of VBA and I have no idea of how I can do this, could someone please help me at this problem?
Thank you very much.
I am trying to write a VBA code for statistics purpose in EXCEL. For example:
(Given)---space---(Count by VBA)
Statistics---space---Binomial Times
1 <<Box A1---space--- 3 (means there are "1" X 3) <<BOX B2
1 -------space---------1<<in red text (means there is "0" X 1) <<BOX B3
1 -------space---------1 (means there is "1" X 1) <<BOX B4
0 -------space---------4 <<in red text (means there are "0" X 4)
1 -------space---------2 (means there are "2" X 2)
0 -------space---------and so on
0
0
0
1
1
and so on
=================================================
List (BOX D2) = all "1" Times ( black text in colume B)
List (BOX E3) = all "0" Times (red text in colume B)
I know it's too complicated and I don't know if it is possible to do this redundant steps by VBA code. Since I am still at the very beginning level of VBA and I have no idea of how I can do this, could someone please help me at this problem?
Thank you very much.