VBA macro for Excel to load image files into data table

Employer
no avatar
JacekMo
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.

Published
on 2022-12-01
Skills
File description 1
Plik z makro. Makro jest z gotowca znalezionego w sieci - nie jestem programista. Dzialalo, ale przestalo. Byly tez problemy z sortowaniem i filtrowaniem.
File description 2
Plik z grafikami

Offers sent (8)

no avatar
GBART
0 deals
on 2022-12-29
AutoCAD
AutoCAD software
excel
+ 2 more
Budget
Negotiable
Copyright
-
Expires in
30 days