VBA to Browse insert an Object in excel in specific cell

  • Hi,

    I am looking for an VBA code to browse and insert an object in a specific cell as follows in the attached excel.


    1.If i click browse G3, it shoud open a file explorer to choose a file.

    2. Then if i select a file and attach, it shoud attach in cell F3 in centre.

    3.The attached file should be with the same name of the file and with the same icon (For Eg.If the attached filr is PDF, then the icon shold be PDF, if fie is excel then the file icon should be excel and so on)

    4.In the same way if i browse G4, file should be attached in F4 and so on.


    Experts, pls help to create a VBA code in the attached Excel.