Home |
Search |
Today's Posts |
#10
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
No it is the perennial Google problem.
Try this version http://support.microsoft.com/kb/q155051/ -- HTH Bob Phillips "William Benson" wrote in message ... the page link does not work for me Bob, can you test it once more? maybe a problem with my IE. "Bob Phillips" wrote in message ... Are yhou using Excel 97? XL97: "Can't Enter Break Mode" Stepping Through a Macro http://support.microsoft.com/s*uppor...Q155/0/51.a*sp -- HTH Bob Phillips "William Benson" wrote in message ... This may be irrelevant, but I have run in to the same error message and found I needed to write the code in VB Editor, but test it from another location (Excel). I never bothered to figure out why, just dealt with it. "Richard Buttrey" wrote in message ... Hi, I have some VBA code which opens up a .txt file, hacks the formatting around a bit deleting superfluous stuff, and leaves the user with a nice neat database. I recorded the following code to add a command button to the worksheet, with the intention of adding some further code behind the button. Sub AddButton ActiveSheet.OLEObjects.Add(ClassType:="Forms.Comma ndButton.1", _ Link:=False, DisplayAsIcon:=False, Left:=237.75, Top:=21, Width:=93, _ Height:=22.5).Select Range("a1").Select End Sub When I test this by playing it back in the VBA window, it halts with the error message "Can't enter break mode at this time", Continue End Help and the usual Debug button is greyed out. If I select 'End', the button appears on the worksheet in Edit Mode, but I can't procede with any more code in the subroutine First of all can someone tell me what's wrong with the code, and then secondly, assuming I can succesfully place a button on the worksheet, how can I add some code programatically to the button object - or indeed any other control? Usual TIA __ Richard Buttrey Grappenhall, Cheshire, UK __________________________ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to programatically control a 3D-sum? | Excel Worksheet Functions | |||
Programatically control picture property of Image control | Excel Programming | |||
default references or adding programatically | Excel Programming | |||
Changing what is displayed in an image control programatically | Excel Programming | |||
Adding components to multipage programatically | Excel Programming |