I used to encourage people to convert their macros to VBA, however there are some inconsistencies in the conversion process. So I would advise against it now.
One problem is the Tempvars, they don't convert properly.
The issue I noticed was that trying to assign the value from a control to a Tempvar failed because the Tempvar thought that the control was a control.
The solution was to explicitly add ".value" to the end of the name of the control (usually a textbox) to make sure that the Tempvar was assigned the value from the textbox and not assigned the actual object "textbox" ...
Sent from my Pixel 3a using Tapatalk