Message Boxes

[Kim_J]

I want my message box to pop up a message like "Your ticket number is 1001".

I know how to make a message box that says that exactly, but I want the value to be from an existing table. Is there a way to do that?

Thanks in advance

[mudraker]

Please Login or Register  to view this content.

[Kim_J]

Thanks for the reply.

Currently I have column A pre-filled with unused issue numbers.
I have a user form that adds the data to the first empty row starting with column b.

So the issue number won't always be in the same cell....

Would I be able to do an offset of some sort, like "all my code for finding the first empty row, offset (-1,-1)?

[Kim_J]

Never mind, I figured it out. I didn't make it quite so complicated though...

Please Login or Register  to view this content.

[mudraker]

It is normally best if you avoid using select within you code
Try

Please Login or Register  to view this content.

[Kim_J]

Thanks a bunch!