I need a master of VBA to code me a macro or UDF
Here is what I want :
I see too possibilities :
Option 1- a macro that automatically insert and resize a picture name with the value of the active cell ....
Ex:
Value of cell C30 = C:/path/image.jpg
I want to insert picture C:/path/image.jpg in that cell and resize it to fit the entire cell
Option 2 : a function
Ex :
If value of cell A1 = C:/path/image.jpg
I want to call in cell C30 a UDF like : =INSERTPIC(A30)
So it has to load C:/path/image.jpg and resize it too
Please Help Me
Thx
Here is what I want :
I see too possibilities :
Option 1- a macro that automatically insert and resize a picture name with the value of the active cell ....
Ex:
Value of cell C30 = C:/path/image.jpg
I want to insert picture C:/path/image.jpg in that cell and resize it to fit the entire cell
Option 2 : a function
Ex :
If value of cell A1 = C:/path/image.jpg
I want to call in cell C30 a UDF like : =INSERTPIC(A30)
So it has to load C:/path/image.jpg and resize it too
Please Help Me
Thx