Share via

Excel 2016 VBA String Format Function Is Not Available

Anonymous
2015-09-27T14:20:42+00:00

I have recently purchased Office and the Excel 2016 VBA doesn't recognize the Format function for formatting strings in the VBA code.

Does anyone know what to use in place of this or if this can be corrected such that it recognizes the Format function in the VBA code?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

6 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2016-11-14T14:27:59+00:00

    So i face the same problem after spending one day i found solution....

    In Excel go to File => Parameters=>addons => Excel addons 

    there choose all of them and pres ok

    Should work

    Since i have Russian excel i add some picks in case i miss translation

    step1

    https://drive.google.com/file/d/0B4hk\_xvm14tvWm4yelg4V3ZGQUE/view?usp=sharing

    step 2

    https://drive.google.com/file/d/0B4hk\_xvm14tvelZGQl94M3A1T2s/view?usp=sharing

    0 comments