Hello,
I am trying to design something with the same concept as a bingo let's say..
The player has 42 choices (1 to 42), which are in Range("B5:C25")
He has to pick 6 numbers (one at a time) out of the 42 numbers.
When a number is chosen (with a mouse-click on the number), I want it to appear in the Range("E5:E10") in chronological order (i.e if the player picks 40,30,8,3,20 ; these number should appear as 3,8,20,30,40 in the Range("B5:C25"). The cells of the 6 chosen numbers should also appear in red after being picked.
Any help would be greatly appreciated !! <!-- / message --><!-- BEGIN TEMPLATE: ad_showthread_firstpost_sig --><!-- END TEMPLATE: ad_showthread_firstpost_sig -->
I am trying to design something with the same concept as a bingo let's say..
The player has 42 choices (1 to 42), which are in Range("B5:C25")
He has to pick 6 numbers (one at a time) out of the 42 numbers.
When a number is chosen (with a mouse-click on the number), I want it to appear in the Range("E5:E10") in chronological order (i.e if the player picks 40,30,8,3,20 ; these number should appear as 3,8,20,30,40 in the Range("B5:C25"). The cells of the 6 chosen numbers should also appear in red after being picked.
Any help would be greatly appreciated !! <!-- / message --><!-- BEGIN TEMPLATE: ad_showthread_firstpost_sig --><!-- END TEMPLATE: ad_showthread_firstpost_sig -->