Hi, I try to link the text with the picture for example when I type apple, the apple picture pops up. I have finished that with the name manager function but still have a problem.
My problem is the number of pictures must be exactly the same as the number of pictures that I link. In my file, I have three pictures; apple, banana, and pineapple. If there are only 3 cells in column (G,H), it would work perfectly fine, but if i add more cells such as 4 or 5, it does not work for picture 4 and 5.
My solution to this is adding random pictures in the source in order to have more number of pictures in the source and it will work with the limitation of number of pictures in the source.
But I want to have a better solution to this problem, my solution will take me a lot of time. What should I do.
Thank you
Bookmarks