Microsoft KB Archive/58356

{|
 * width="100%"|

INPUT Function Clears the Clipboard in Excel

 * }

-

The information in this article applies to:


 * Microsoft Excel for Windows, versions 2.x, 3.0, 4.0, 5.0
 * Microsoft Excel for OS/2, versions 2.2, 3.0

-

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(&quot;prompt&quot;,type,&quot;title&quot;,default) =PASTE

The correct sequence would be as follows:

  =INPUT(&quot;prompt&quot;,type,&quot;title&quot;,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 :

Technology :