Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

I have lots of experience with Excel 4 (XLM) macros, but Im trying to learn VBA. How can I find the equivalent VBA command for an XLM macro function?

April 26, 2017equivalent Excel experience learn lots macros VBA xlm

0

Posted

I have lots of experience with Excel 4 (XLM) macros, but Im trying to learn VBA. How can I find the equivalent VBA command for an XLM macro function?

1 Answer

0

Posted

Excel’s on-line help system contains a cross-reference of VBA equivalents for XLM macro functions. Access the Contents tab of the Excel help window. Click on Microsoft Excel Visual Basic Reference, then click on More Visual Basic Information, and finally click on the help topic labeled Visual Basic Equivalents for Macro Functions and Commands. To see the VBA statement that is equivalent to an XLM macro function, click the first letter of the macro function and scroll through the list to find the macro function you’re interested in.