![]() ![]() ![]() I'm hoping adding it to the code will fix the issue since I haven't been able to find another workaround, but I'm a bit of a newbie and am not sure where to start. Since the file will be transferred around the pictures are kept in a "Pictures" tab within the file. Can anyone help me with the code to add to my VBA in order to get the pictures to change dynamically based on the cell value pulled from the VBA? I have attached a sample of the workbook. Unfortunately my client is also using a Mac so I'm looking for a workaround. That leads me to believe it is a Mac related issue. I posted last night for some help and on a PC someone had no issues getting it to change the picture. The vlookup changes, but in order to get the picture to change I have to click the "Calculate Now" button or double click on a cell and hit enter. I have even added worksheet.calculate to my VBA. Everything works, but the picture will not change just by clicking my button. Steps: Open a folder (which contains images) using Scripting.FileSystemObject. ![]() There is a vlookup that also puts a full description to that letter code. This is done with a defined name and using the indirect() function. I also have a dynamic picture based on a cell value letter code pulled in from the VBA. I can type in a search value, click the button and it brings up my information. I have a file that uses VBA to look up information on a data point. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |