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.

VBA has an InputBox function, and theres also an InputBox method for the Application object. Are these the same?

April 26, 2017application function method object VBA

0

Posted

VBA has an InputBox function, and theres also an InputBox method for the Application object. Are these the same?

1 Answer

0

Posted

No. Excel’s InputBox method is more versatile since it allows validation of the user’s entry. The preceding example uses 1 (which represents a numeric value) for the last argument of the InputBox method. This ensures that the user enters a value into the input box.