I've written a macro importing data from a external source with a message box reading "This will affect your data, Continue?" with a ok & cancel option. Its great when I click ok but a cancel hit returns a VB error as does a cancel on the confirm import when I continue with the import, any ideas on how to add a rule to the cancel option??
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Messgae Box yes and no options
- Thread starter mike1971
- Start date
Hi
Not sure if I follow your question exactly, is it error 2501, you are getting?, if yes, this is normal, you trap (and ignore) it with ON Error GoTo type code in VBA Regards
Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now - UK
Not sure if I follow your question exactly, is it error 2501, you are getting?, if yes, this is normal, you trap (and ignore) it with ON Error GoTo type code in VBA Regards
Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now - UK
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question