Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
shortcut key versus F5
My macro - containing 4 inputboxes and generating 2 tables and corresponding
charts - is running very well by F5, but gives a 424 object error when I use the designated short cut key. It is clear that it jumps over the second inputbox and that it - further on but probably not in relation to the first problem - does not identify a certain dataset, although it is dimensioned and set. What solution do you suggest? I also tried "i = DoEvents" but it doesn't seem to work. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
shortcut key versus F5
have you tried creating a button to run the code? If that doesn't work, try
posting the code. "Wim VL" wrote: My macro - containing 4 inputboxes and generating 2 tables and corresponding charts - is running very well by F5, but gives a 424 object error when I use the designated short cut key. It is clear that it jumps over the second inputbox and that it - further on but probably not in relation to the first problem - does not identify a certain dataset, although it is dimensioned and set. What solution do you suggest? I also tried "i = DoEvents" but it doesn't seem to work. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
shortcut key versus F5
Thank you JNW. I could solve the problem by changing the order of some of my
codes. "JNW" wrote: have you tried creating a button to run the code? If that doesn't work, try posting the code. "Wim VL" wrote: My macro - containing 4 inputboxes and generating 2 tables and corresponding charts - is running very well by F5, but gives a 424 object error when I use the designated short cut key. It is clear that it jumps over the second inputbox and that it - further on but probably not in relation to the first problem - does not identify a certain dataset, although it is dimensioned and set. What solution do you suggest? I also tried "i = DoEvents" but it doesn't seem to work. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
shortcut has change or move so this shortcut can not open | Excel Worksheet Functions | |||
$ versus None | Excel Discussion (Misc queries) | |||
R1C1 versus A1 | New Users to Excel | |||
XLA versus Reference versus Nothing | Excel Programming | |||
vb versus cf | Excel Programming |