Prev: Adding a dropdownlist programmatically to a ASP.NET webpage
Next: Excel 2007: Return rownumber when text data on 3 columns match exa
From: Ian Digby Ian on 22 Jan 2010 04:05
Here's a weird thing:

1. Inexplicably, after running some farily standard VBA code, my Excel
application was left in DataEntryMode , thus disabling various menu options.

2. The last line of my code was:
MsgBox "Update Complete.", vbInformation

3. Tried turning off DataEntryMode - problem persisted.
2. Tried issuing an escape keystroke, after the MsgBox:
SendKeys "{ESC}", True
Problem persisted.

3. Moved the SendKeys line to run before the MsgBox, and it works fine.

Comments?

Ian Digby, Meggitt
 | 
Pages: 1
Prev: Adding a dropdownlist programmatically to a ASP.NET webpage
Next: Excel 2007: Return rownumber when text data on 3 columns match exa