• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

VBA applicationInput box and error '424' message

D

dmcnab

New Member
Hi all...I need some help...I am attaching a workbook that has 2 pages....on the "Schedules" page, you dble-click a cell in the columns shown and it will jump to the Data Sheet...you then select a dat item and it will copy into the cell on Schedules....everything seems to work fine, unless you scroll to part of the Data Sheet that isn't shown on your screen (eg: cell AY282)....if you scroll and then select an item, it throws an error ('424').....any ideas about why this is happening?


http://www.speedyshare.com/files/29866187/Misfire_sample.xls for the sample file....thank you
 
When you say "unless you scroll to part of the Data Sheet that isn't shown on your screen"

what do you mean?

As when I went to AY282 it returned "30-Dec-11 @ 3:15--#1208"

as it should


Do you have the screen split or use scroll lock as I can't replicate the problem ?

I am using Excel 2010.
 
I don't have the screen split and I don't have scroll lock on.,....but, I am using Excel 2003....could that be the issue? Here is a screen shot of the error message and highlighted code


http://www.speedyshare.com/files/29881087/Glitch_screen_shots.doc
 
You must log in or register to reply here.
Back
Top