Need help creating a pop-up window with specific cell data

[touyets]

hi there, first time I'm using this forum. Hope you can help me.

I'm basically creating a file where a userform comes up when you open the workbook, blocks the access to the actual workspace so that no manual entry can be done. What the userform allows you to do is add a new entry to the database (the userform has some text boxes where we type in stuff like location and name or age) after having found the next empty row in the enormous database (3.000 lines)

I have done this and I need help resolving a stupid issue I can't get over (some of you may laugh ).

After having clicked the OK button in the userform and added the data to the database, I would like the userform to have a pop-up message box with specified text like:

"The number assigned to this entry is:" and then I would like to add a variable with excel using the cell in column D of the same row of the new entry. So the end result would be :

The number assigned to this entry is: 01

I've being trying several things but nothing worked (not even close to be honest).

Cheers,

Simon

 

[touyets]

Didn't see the last 2 posts, will try that...

 

[touyets]

AH! crap I tried both your methods and still, I get the message box with the text but no number

Any more ideas? Must say, you know what you're doing with VBA

 

[touyets]

little bit of a flood here but..... sorry.

Anyways, was stupid enough not to change the "Sheet1" code idiot, i know.

Thanks a lot guys

 

[StephenR]

No problem. We've all been there!