LinkBack URL
About LinkBacks
Hi,
I am using an inputbox to get a range a data from the user.
This works ok if the user selects a range, however if i select the cancel button i get a Run-time error 424, object required.
Please Login or Register to view this content.
jonnyuk3
Hi,
I am using an inputbox to get a range a data from the user.
This works ok if the user selects a range, however if i select the cancel button i get a Run-time error 424, object required.Please Login or Register to view this content.
jonnyuk3
Good morning jonnyuk3
There isn't a dedicated method to catch cancel from the Application.Inputbox object. Just use Excel's generic error trapping method immediately before calling the input box, and reset it straight after, thus :
HTHPlease Login or Register to view this content.
DominicB
Please familiarise yourself with the rules before posting. You can find them here.
Hi Dominic,
I've tried what you suggested and i still get the same error.
Please Login or Register to view this content.
Hi jonnyuk3
This code runs fine on its own. The error must be that the empty variable is causing a problem further on. Use something like this ...
I can't be any more precise than that with only one line of code to look at.Please Login or Register to view this content.
HTH
DominicB
DominicB,
Thanks for your help, but i still cant get this to work.
Here is the full code for the macro.
The code stops at the Set rngToChart = Application.Inputbox.......... linePlease Login or Register to view this content.
I appreciate your help.
jonnyuk3
Hi jonnyuk3
I'm not sure why you're having this problem - I've worked one of my previous answers in your code and it seems to work OK for me. I can't fully test it as you seem to be making use of a custom function (IsChartSheetPresent) but see if it works for you :
If you're still getting an error you may have to post a cut down version of your file.Please Login or Register to view this content.
HTH
DominicB
DominicB,
I'm still getting the same error, so I've attached a copy of the file.
I also now get the aborted message after creating a chart.
Thanks for this.
jonnyuk3
Hi jonnyuk3
Aaah yes, of course you do. An oversight on my part I'm afraid - I should have added an extra line. The bottom four lines of the macro should have read :Originally Posted by jonnyuk3
Please Login or Register to view this content.I'm afraid with the extra line added the routine works perfectly on my machine running Windows XP and XL2007.
Select a range and click OK a graph is produced.
Select Cancel and an abrupt message reads "Aborted" (as per the attached image).
I'm sorry, but I can't really help any further if I can't reproduce the problem. I'll alert the other moderators and see if any of them can reproduce the error.
DominicB
DominicB,
Thanks for your help.
I'm running on Vista, I wouldn't have thought that would be a problem. I'll try again on Monday.
Thanks again.
jonnyuk3
I'm running xl2007 and Dominics code (with the added lines) worked fine, it created the chart no problem once i entered the range in the inputbox correctly (i used A9:F20).
Not all forums are the same - seek and you shall find
Simon,
Creating the chart is not the problem. As stated in the first post, the error occurs when the user presses the cancel button on the inputbox.
DominicB,
I tried running the macro on an xp machine using xl2007 and it works no problem, the error only occurs on vista.
thanks for your help, i appreciate it.
jonnyuk3
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks