Hi
I have a code, which works, but I want msgbox appear after the code executes. But it does not. Why?
Please Login or Register to view this content.
Hi
I have a code, which works, but I want msgbox appear after the code executes. But it does not. Why?
Please Login or Register to view this content.
Last edited by contaminated; 01-05-2010 at 07:51 AM.
Люди, питающие благие намерения, как раз и становятся чудовищами.
Regards, ?Born in USSR?
Vusal M Dadashev
Baku, Azerbaijan
Just a wild stab in the dark, but do you need Screenupdating turned on to display a messgae box?
Dave
Listboxes are zero based.
You are trying to access item 40, which does not exists.
Always a good idea when code with Error trapping is not working is to remove the error trapping in order to see the actual error. Put it back when reason is understood and resolved.Please Login or Register to view this content.
Is your code ever getting to that line or is it erroring out thus skipping to your Unload Me line? Just plonk a message box after oops indicating if an error was made:
Please Login or Register to view this content.
Richard Schollar
Microsoft MVP - Excel
Hi sweep
Thx for responce
Actually I dont need screenupdating at all.
Thank u for all your responces
RichardSchollar
Workde like a charm!!!!!!!!!!!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks