You could assign all your buttons that do this thing to this one macro. It will determine the button that called the macro and reference the cell in the button's top left corner and offset one column to it's right.
Sub Button_Click()
Dim btn As Button
Dim vImgFile
Set btn = ActiveSheet.Buttons(Application.Caller) 'Button that called this macro
vImgFile = Application.GetOpenFilename("Graphics Files (*.tga),*.tga")
If vImgFile <> False Then
btn.TopLeftCell.Offset(, 1).Value = vImgFile
End If
End Sub
Edit: ...just like Leith Ross suggests.
Bookmarks