Excel for Mac crashes when using Application.InputBox

[mattradtke]

I am running Excel for Mac version 16.11.1 (180319) on macOS High Sierra version 10.13.3. I have written a simple test macro that only does this:

[INDENT]Sub RngTest()
Dim rng As Range

On Error Resume Next
Set rng = Application.InputBox(prompt:="Title", Type:=8)

End Sub[/INDENT]

When I run the RngTest macro, the modal dialog box appears as expected. If I select one cell in my worksheet, that cell's address appears in the edit control, also as expected. However, if I use the mouse to click one cell and then begin to drag the mouse to additional cells, Excel crashes.

Any help would be much appreciated. Rolling back to a different version of Excel or macOS is not really an option, as the application that I am building will be used by hundreds of people around the world.

Thanks,
Matt

 

[Dryver14]

I dont think Mac likes "Prompt"

try

Set rng = Application.InputBox("Title", Type:=8)

 

[mattradtke]

Thanks for the suggestion, but that doesn't change the behavior of this problem. It is true that the Mac version of application.inputbox only displays the Title and not the Prompt, but I can live with that. It's the fact that Excel crashes and exits that I need to resolve.

 

[Dryver14]

I hate to try the obvious but have you tried selecting a range on this sheet without the inputbox?

I'm thinking some sort of range selection issues with a worksheet change event

 

[mattradtke]

My worksheet is empty. In fact the only thing in my XLSM file is the little test macro that I posted. While in the Sheet1 worksheet, I can select multiple cells without issue. I can also select cells while editing a formula, for example I can enter "=Sum(" and then select a range of cells that then becomes part of my Sum formula.

The same behavior is observed on another user's Mac, although it is the same version of Excel. Therefore, I think we can rule out anything specific to my environment.