INPUT() Function Clears the Clipboard in Excel

ID: Q58356


The information in this article applies to:


SUMMARY

The INPUT() function in Microsoft Excel clears the Clipboard as soon as it is executed. The following sequence of statements, for example, would cause a macro error at the PASTE() command:


   =COPY()
   =INPUT("prompt",type,"title",default)
   =PASTE() 


The correct sequence would be as follows:


   =INPUT("prompt",type,"title",default)
   =COPY()
   =PASTE() 


Note: the information above applies to version 5.0 when you use Microsoft Excel version 4.0 macro language.

Additional query words: 2.0 2.00 2.01 2.1 2.10 2.2 2.20 2.21 3.0 4.0 4.0a 4.00a 5.0


Keywords          : 
Version           : 
Platform          : 
Issue type        : 

Last Reviewed: March 15, 1999