mypict

Hello all, I am new to coding VBA and I am stuck on two aspects of the code. I am trying to insert an image under data that is on the excel sheet(the image is coming from a file on my computer), automatically delete the previous image without deleting a logo that is on the worksheet, and...

Hi there, I have the following code but I need for it to keep going until the last cell that has data. I have no idea how to do this could anybody point me in the right direction? (code)Private Sub Worksheet_Change(ByVal Target As Range) Dim myPict As Picture Dim PictureLoc As String If...

Hi I am a novice on VBA. But I wish to modify this formula below so that it can size the pics displayed proportionally. The macro currently only show a pic based on cell value. Pls help. Private Sub Worksheet_Change(ByVal Target As Range) Dim myPict As Picture Dim PictureLoc As String If...

So, I want to be able to click a button that will open a window and let me Navigate to a location where pictures are located, then when I select the picture I want, I want it to insert it in to an excel worksheet and resize it at the same time. It does not have to be a certain cell that it puts...