Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
As a Delphi programmer, I'm sincerely trying to adapt to VBA, I really
am. But, I've got this workbook. I work on it in various versions of Excel, but right now it's Excel 97 SR2. First, I set a break point on the first line of code in a function I wrote. The function is called by referencing it in a cell. E.g., cell A1 contains "=MyUDF(xxx)". If I edit cell A1, then exit editing mode, focus jumps to the VBA environment with execution paused on my break point. Fine. Next I add a watch point. If I add, say, watch expression "Application", then, as lovable Hungarian character actor S. Z. Sakall said in "Christmas in Connecticut" (1945), "Ev'rysing is hunky-dunky". But if I so much as add an expression beginning with "Application.Caller", e.g. "Application.Caller", "Application.Caller.Address" or something like that, it's Bombs Away for Excel 1897. (And if you saw my other recent post, you know I'm having to do my work amid Excel 97's crashing every time two or more merged cells happen to show up on row 2841. No joking.) So, I mean, what's y'all's opinion? Is Excel VBA a stable product, or is it ... an EDSEL? Thanks. *** |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Adding data only if adjacent to cell labeled "male"/"female" | Excel Worksheet Functions | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
=SUM((C2:C7000="Friday")*(F2:F7000="8:00:00 AM")) not adding | Excel Discussion (Misc queries) | |||
Macro crashes "Automation error" during copy of workbook with char | Excel Programming | |||
Adding "New" "Insert" "Delete" into a workbook to change from data 1 to data 2 etc | Excel Programming |