This is a problem when selection a range with an inputbox. Excel returns an error before the range is returned, and it carries this error on when you press cancel. You should therefore actively handle this error. If you don’t want anything to happen when you press cancel, you can just use the code like … Read more
In addition to using Microsoft.VisualBasic; add the reference, too. Here’s a visual answer: Then
the standard InputBox returns empty fields and cancel the same way No it does not. It returns a null pointer (vbNullString) on cancel and an empty string (“”) for empty input. Dim s As String s = InputBox(“Test”) If StrPtr(s) = 0 Then ‘Cancel pressed Else ‘Ok pressed End If Because InputBoxDK returns the InputBox‘s … Read more