![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(150.4, 63%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHG%3C/text%3E%3C/svg%3E)
I use Excel extensively but I have not changed menus as I tend to use worksheets for financial and statistical analysis etc
I use VBA when formula are too complex for the = method, ut in practice this is rare
Excel VBA, StrPtr
Steve B
1
Reputation point
Hi all.
I guess it's been a while since I've been here.... everything has seriously changed.
A long time ago, an Excel MVP had helped me with the 2007 changes to the Ribbon, and working with his code, I'd created a gallery for my Excel Ribbon. It worked all the way up to at least 2016, and then I'd stepped away from using Excel for several years, and now I'm back, and want to get some of my code working again.
This ribbon code for my gallery being one of them.
https://jkp-ads.com/rdb/win/s2/win011.htm
Since this is the item that threw the error, I figure I better start here.
this throws a mismatch error.
StrPtr
Does anyone remember these? Does anyone know how to update the code to work in the present day form of VBA?
Your help would be appreciated.
TYIA.
Developer technologies | Visual Basic for Applications
{count} votes
-
Viorel 123.6K Reputation points2025-07-29T18:59:31.3966667+00:00 Alternatively, perhaps the problem related to VBA and Ribbon could be formulated in clearer terms.
Sign in to comment