print a selected range to be printed

Fuzzy lookup for Mac

It would be great to have fuzzy lookup add-in for Mac.

ActiveWorkbook.Connections("ConnectionName").ODBCConnection is broken. Please fix this single command. It is a blocking issue. All other ODBC commands are working as expected. Please fix this one so everything is working. Thanks

In previous versions of Mac Excel you could create a Form/Dialog using VBA (called a VBA UserForm). In Mac Excel 2016, you can no longer do this. Please bring that functionality back. Note that this is different than the "Form" option on the Data menu. There's a separate suggestion on UserVoice for that.

(March-2018: MS updated the Title and Description to avoid confusion with the Data Form request)

In Mac XL 2011 You had ability to create Macros that made use of Relative References in a addition to absolute references. In the Excel Mac 2016 Answers forum this is vitally important.

Any possibility of returning this to Excel Mac 2016

[10/22/2015 - Dan [MS]: Added image to show where this feature used to exist in older versions of Mac XL]

Bring VBA on Excel for Mac to parity with Excel for Windows.
Currently, there are too many missing VBA elements missing. It is a major problem for those of us with mixed environments. Many things that worked under Excel 2011 no longer work in 2016.

Why is the not being addressed?

Excel for Mac's macro cannot record my operations when I use data analysis tools(e.g. using random number generation),but when I do the same steps on windows it can be done.
Could please fix that
Details pls follow the link
https://www.youtube.com/watch?v=x0vygE2JN4o

Need to fix a bug with mac Excel. After running a macro, the mouse cursor disappears. It reappears after typing in another program and coming back to Excel. This fix works sometimes but not all. This gets frustrating. The same macro runs fine in Windows Excel.

At present if you want to use Forms in VBA you cannot in the latest version of Excel for Mac one has to stay with 2011

Include the Windows shortcuts for Fill commands

See file attached quite explanatory

screenupdating = false fails in excel 16.13 again

add the same items in the developer bar as in windows. Many VBA commands are missing, such as insert form

If you select Tools - Macros - Macros... you get a list of macros. Select a macro and click Options... You're then presented with a box that allows you to set a Shortcut key. Either Option+Cmd (for a lower case letter) or Ctrl+Shift (for an upper case letter).

It doesn't matter what I enter into the little box. Nothing works. No letter, upper or lower case, seems to work.

Since generally keyboard shortcuts seem to be an issue has this ever worked?

Hi. Thanks for providing a new VBA editor for Office 2016. I have a vba add-in I've been working on that shortly after some recent updates started having errors pop-up. Please fix Mac Office 2016 so in vba I can close open xlam files.

In the attached add-in, I install statprogo.xlam, then in the ribbon, I can select, eg, Regression Analysis->Multiple... and then press cancel on the user form to get the error. The workbooks().close call is causing the error when it did not previously.

Add the link to the "msdn.microsoft.com/en-us/vba/excel-vba/articles..." which is available in the Windows version of Excel while using the VBA editor by pressing the F1 key to Mac Excel 2016.

Thank you.

I developed an Excel Add-in that is coupled to a Fortran code in Excel 2016 for Mac. This works perfectly. However, it would be nice if the list of (user defined) functions could be visualised in a separate category or visualised anyway in the "Formula Builder" pane on the right side of the screen (in between the already existing categories and functions). I tried to use

Sub AddUDFToCustomCategory()
Application.MacroOptions Macro:="MyFunction", Category:="MyCat"
End Sub

but that does not work, nor in my develop Add-in, nor in a very simple Add-In with only one simple function.

Looking forward to an answer!

Teus