VBA macro for Excel to load image files into data table

Closed job
no avatar
JacekMo
Employer
Job category:
Desktop/web applications
Expected budget:

Negotiable

Preferable skills:
Published:
Finished

Job description

The task of the macro is to load graphics into the data table after activating the button. The second button is used for deletion.

Graphics must scale to the size of the cell.

The paths to each of the graphic files are specified with are located in the cells, which are hidden.

Each line of data is loaded with 3 graphics - but it must be possible to increase it - this can be done by changing the range of cells in the macro.

The code must be resistant to missing, i.e. graphics that do not exist.

After loading graphics, it must be possible to sort and use filters - specific graphics must remain in their cells.

There is a macro in the attached xlsm file - but it does not work properly. The new macro should be more versatile and error-proof, sorting and filtering.