On Monday, August 13, 2012 4:03:04 PM UTC-7, Howard wrote:
Excel 2010



I have had no problems using Ctrl-c and Ctrl-v to do a number of copy/paste’s whilst developing stuff on a worksheet.. I have three macros that do stuff on that sheet. One of the macros produces an input box for an entry on the sheet, you type a letter in the box and hit OK. The input box goes away and the letter appears in the designated cell on the sheet. This is all fine and good. However, out of the blue, now if I try to do a Ctrl-c on a cell on the sheet the screen reverts to the VB editor and I get Error Message 400 . So, I look up error 400 in help and this is what it says…



Form already displayed; can't show modally (Error 400)

This page is specific to the Visual Basic for Applications (VBA) Language Reference for Office 2010.

You can't use the Show method to display a visible form as modal. This error has the following cause and solution:

• You tried to use Show, with the styleargument set to 1 -vbModal, on an already visible form. Use either the Unload statement or the Hide method on the form before trying to show it as a modal form.



I have no idea how to proceed from here. I can only presume it has something to do with the input box, but what??



I can Copy on the sheet by selecting "Home" click "Copy", select the destination cell and Ctrl-v.

Can someone steer me through this?



Thanks



Regards,

Howard

I did indeed assign Ctrl-c to a macro... I had it a short-cut to a "Clear" macro. Fixed that and iit works fine.

Thanks
Regards,Howard