Hi There
I am working on a calender. Now I want to to put small pictures that shows the size of the moon. So how can I use VBA to input pictures in specified cells??
I also want to know how I can get VBA to delete the pictures when I change the year of the calander.
I do hope that it's possible to do these things.
Thank you in advance.
Re: Macro to input picture in cell and also delete picture
Hi,
Did you get an answer to your question? I need to know how to get the picture in the cell. I'm not worried about using a macro to do it.
Any help will be appreciated.
Re: Macro to input picture in cell and also delete picture
Can you post a sample workbook?
Re: Macro to input picture in cell and also delete picture
Hi Fendore
Thank you for your reply. The picture have to be put in a cell that have been decribe in the macro.
Also when we start a new year then the picture have to be deleted again.
To explain a little bit more. Is't the pictures of the moon I want to put in the calender. Pictures that show if the moon is full or new.
Alring
Re: Macro to input picture in cell and also delete picture
ActiveSheet.Pictures.Insert("C:\test.JPG").Select
with selection
.width = activecell.width
.height = activecell.height
'you may have to adjust the picture size or the cell size or the formula to get
'it to fit correctly without stretching the photo too much.
' I am assuming the photo is square and the active cell is square for this to
'work
.top = activecell.top
.left = activecell.left
end withDon’t have an account yet? Register yourself now and be a part of our community!