What Excel products support Picture in Cell?

Question

I have an Excel application created using Excel 365 and in 2023 (I believe) Microsoft Excel began to support inserting an image in a cell. Whereas prior to that, one could place an image on sheet but the image would remain over the cells. With the image inside a cell, one can sort and filter a table and the relationship of the image would remain with the rows. A handy feature.

My question is that it appears that this function of inserting an image inside a cell is available in all products that identify themselves as Version 16 of Excel. It is my understanding that this applies to Excel 2016, 2019, 2021, 2024 and 365. But the caveat is that the product must be build number 16529 or later. Further, it is my understanding that with the stand-alone versions of Excel (not 365) the feature of inserting an image inside a cell would only be available if it was available at the time of purchase. In other words, if the feature was not available at time of purchase, then it would never become available as only security updates will be applied. Whereas with Excel 365, additional functional updates are applied as they become available.

If I were to interpret all of this, my assumption is that Excel 2016, 2019 and 2021 would never support placing an image inside a cell as the build number would not be correct.

But all of this is quite confusing as I have seen build numbers for Excel 2021 that occur in the year 2024. So what is going on?

Can someone please explain the following:

When one checks the version number using the VBA command "Application.Version", the derived result is 16.0. But version 16.0 applies to all Excel after Excel 2016 including Excel 365. If one uses the VBA command, "Application.Build" the derirved result will be something like "xxxxxx.nnnnn" that one can interprest as the build number followed by some undefined number.

My question ... Using VBA, how can one determine if the installed version of Excel supports the feature to insert a picture inside a cell ?

Thanks,

Steve

Answer 1

Hi @Steve Bisel

Please check whether the following code is helpful to you:

Sub CheckPictureInCellSupport()
    Dim buildNumber As String
    buildNumber = Application.Build
    
    ' Check whether the Version number is newer than16529
    If Val(Split(buildNumber, ".")(0)) >= 16529 Then
        MsgBox "Does not support."
    Else
        MsgBox "Yes, it's support."
    End If
End Sub

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

---