Excel的InputBox方法中有缺陷部分的替代解决方案

摘要

Using the techniques of " concurrent" execution of user-defined functions, UserForms and events handling as well as data transfer in Excel 2003, we design a VBA ( Visual Basic for Applications) macro, which meets the programming requirement of VBA that it can return to citation of user-selected range in any condition. The purpose of designing the macro is to replace the defective part in Application InputBox method of Excel 2003. And it can also run on WPS 2012 professional plus version which providing VBA environment but lacking a method for interactive selection of a range.%运用Excel 2003中自定义函数、用户窗体与事件处理的“并发”运行和数据传递技术,设计一个VBA宏程序,它满足了在任何条件下都能返回用户选定区域引用的VBA编程需求.设计该宏的目的是为了替代Excel 2003 Application.InputBox方法中有缺陷的部分.程序亦能运行在提供VBA环境、但缺少交互式选择区域方法的WPS 2012专业增强版上.