I will add that to my list and try to make a video about it. But meanwhile, you can have a look at the blog post and download the file to see the code. Basically, you need to copy the picture/shape (instead of getting the number) as follows: Sheets("Logos").Range("B" & r).Copy TargetCell where Logos is the sheet with logo pictures in column B, r is the row for the corresponding logo, and TargetCell is the cell in the main sheet where you want to copy the picture (most likely just ActiveCell if is selected/active).
Everytime i press play excel stops responding and its says there is a bug in this code ( If WorksheetFunction.CountIf(Sheet12.Range("B4:E7"), num) < 2 Then cell.Value = num ) help me please
I suggest you download the file and see the code there, you may have miss-type something. You have the simplified version and the full version in this post: excelmacrofun.blogspot.com/2022/06/excel-match-pairs-game.html Also, try debugging your code. There is a good tutorial about that in the training for beginners here: th-cam.com/video/Rg-gXg8MYKc/w-d-xo.htmlsi=D5I5jcOKxS_arh2t
Please download the file from the blog post - link in the description. You need to make sure you clear the contents in the range first (make sure you target the right sheet). Then, if your range has 16 cells, make sure you aim for a random number between 1 and 8: num = Int((Rnd * 8) + 1) Number of cells in range must be exactly the double, and CountIf checks if number occurs less than twice to add. When using the CountIf function, make sure you target the range in the right sheet.
Not sure why that happens. The variable controlling the click is public (CardOne), check the status, maybe there's a problem around that, depending on your version of Excel. Read more in the post: excelmacrofun.blogspot.com/2022/06/excel-match-pairs-game.html
It worked. Can u upload the video how to create this with the pictures as shown in the cover page
I will add that to my list and try to make a video about it. But meanwhile, you can have a look at the blog post and download the file to see the code.
Basically, you need to copy the picture/shape (instead of getting the number) as follows:
Sheets("Logos").Range("B" & r).Copy TargetCell
where Logos is the sheet with logo pictures in column B, r is the row for the corresponding logo, and TargetCell is the cell in the main sheet where you want to copy the picture (most likely just ActiveCell if is selected/active).
Everytime i press play excel stops responding and its says there is a bug in this code ( If WorksheetFunction.CountIf(Sheet12.Range("B4:E7"), num) < 2 Then
cell.Value = num ) help me please
I suggest you download the file and see the code there, you may have miss-type something. You have the simplified version and the full version in this post: excelmacrofun.blogspot.com/2022/06/excel-match-pairs-game.html
Also, try debugging your code. There is a good tutorial about that in the training for beginners here: th-cam.com/video/Rg-gXg8MYKc/w-d-xo.htmlsi=D5I5jcOKxS_arh2t
The number generator doesnt work
Please download the file from the blog post - link in the description.
You need to make sure you clear the contents in the range first (make sure you target the right sheet). Then, if your range has 16 cells, make sure you aim for a random number between 1 and 8:
num = Int((Rnd * 8) + 1)
Number of cells in range must be exactly the double, and CountIf checks if number occurs less than twice to add.
When using the CountIf function, make sure you target the range in the right sheet.
bro legit when i clik on it only one shows
Not sure why that happens. The variable controlling the click is public (CardOne), check the status, maybe there's a problem around that, depending on your version of Excel. Read more in the post: excelmacrofun.blogspot.com/2022/06/excel-match-pairs-game.html