How to make an error come up as a msgbox

[Lee_wwfc]

Hi
I am making a seating plan which first you have to select a row A-L then you need to select
a seat but there are different numbers of seats within the rows so when i book a seat in row A
and select seat 20 it comes up as an error as it doesn't exist but how do i enable a message box to appear instead
saying 'sorry this seat does not exist' If you know how to do this please would you tell me.
Thankyou :D

[Sean Thomas]

you could try this

Please Login or Register  to view this content.

[Lee_wwfc]

Hi i will try this thankyou

[Sean Thomas]

what line comes up as the error?

[Lee_wwfc]

Thankyou this has worked well although i already have a message box already set up in the same
command button saying this button is sold if the cell says a 1 and this always appears after the
new message box is there a way to stop this :D thankyou very much :D

[Sean Thomas]

if you can upload your code i will take a look

[Lee_wwfc]

Hi it is no problem now you have solved it thankyou
i have added you a reputation

[Lee_wwfc]

Another question please if you dont mind is do you know how to print tickets by collecting data and then adding it to a ticket once you press book
Thankyou,
Lee

[Richard Buttrey]

Lee,

You're obviously very busy at the moment (10 posts in a few hours), but would you abide by the forum standards and raise a new thread for a new topic instead of just adding a new question in a pre-existing thread. This is not only for the benefit of others who might search the forum many months later, it's also more likely to get you a response.

I'll close this thread and you should start a new one