Hi BMV
I agree with you.
A Form would be my choice, but the original poster did ask about positioning an InputBox, and I found that interesting.
During my testing I also tested with the activecell completely 'off the screen' (by scrolling the window), and yes, the InputBox was placed there but could not be seen at all. I clicked [Esc] to cancel that InputBox (it was waiting for my response).
..so I included in my vba code a method to specify the cell to be used, regardless of where the activecell was..
'Set zCell = [G8] '<< define anchor-cell to be used for position of InputBox
..just uncomment that line, and specify the cell you want, e.g. [H12] , [M15], [K9] etc etc etc
zeddy
Bookmarks