VBA Input Pop up Boxes: Application.InputBox Method versus VBA.InputBox Function

[DocAElstein]

This is now post 21
It was a Second copy from New post #16, 31 Oct 2024, all done on 31 Oct 2024
#post24890

---

Page 3 Simplified explanation
https://www.excelfox.com/forum/showt...Function/page3
https://www.excelfox.com/forum/showthread.php/2227-VBA-Input-Pop-up-Boxes-Application-InputBox-Method-versus-VBA-InputBox-Function/page3
Post 21 ( Forum Post #post24890 )
https://www.excelfox.com/forum/showt...ll=1#post24890
https://www.excelfox.com/forum/showthread.php/2227-VBA-Input-Pop-up-Boxes-Application-InputBox-Method-versus-VBA-InputBox-Function?p=24890&viewfull=1#post24890
https://www.excelfox.com/forum/showt...age3#post24890
https://www.excelfox.com/forum/showthread.php/2227-VBA-Input-Pop-up-Boxes-Application-InputBox-Method-versus-VBA-InputBox-Function/page3#post24890

---

Simplified Walkthrough coding explanations

The detailed explanations in the last two pages ( https://www.excelfox.com/forum/showt...utBox-Function
https://www.excelfox.com/forum/showt...Function/page2 ] ) are rather rich and intense, such that they need a lot of time and consideration and its easy to get bogged down and miss seeing the wood for the trees

This page 3 ( https://www.excelfox.com/forum/showt...Function/page3 ) will be shorter simplified explanations based : step debug mode *step through the code lines; a brief simple run ; or general short explanation

( * F8 keyboard key from the VBEditor, (after selecting anywhere in the coding you want to step through, which in our case is the main Sub. That will let you step line by line through the coding. In this node a number of other useful tools are available, just one of which is that hovering over a variable, or some simple expressions, may cause a small pop up to appear telling you of the contents. - https://i.postimg.cc/tCf4krzW/Step-d...n-main-Sub.jpg )


Post 22
A debug F8 step mode full walkthrough the codings so far discussed in detail

Post 23
A simple run of the codings so far discussed in detail

Post 24
The issue of ByRef or ByVal is discussed, in terms of changing the typically needed and used ByRef to ByVal

Post 25
A simple run of the codings with the change to ByVal