ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Why does the error pop up- can't enter command mode? (https://www.excelbanter.com/excel-programming/326967-why-does-error-pop-up-cant-enter-command-mode.html)

Thief_

Why does the error pop up- can't enter command mode?
 
I have this code:

Sub test()
Range("A3").Select
ActiveSheet.OLEObjects.Add(ClassType:="Forms.TextB ox.1", Link:=False, _
DisplayAsIcon:=False, Left:=100.8, Top:=119.930434782609, Width:= _
204.104347826087, Height:=104.55652173913).Select

End Sub

It inserts a textbox onto a worksheet. when I step thru the code, I get to
the Add command, and get the error "Can't enter break mode at this time.".
However when i run the code F5- it works OK??

XL2002 SP2

--
|
+--Thief_
|





All times are GMT +1. The time now is 12:32 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com