My name is Harish..

I am very new to VBA

I have a quick.. and hopefully simple question.

I have a worksheet that is public (in our workplace).. anyone can open it and log entries.. but only two users are allowed to "close" the entries (individual lines)

I have a column called "Closed by" that has a Data Validation range.. the range has two usernames. (the names of the two that are allowed to close the entries)

I have a function that can call the username of the current session ( =username()) and return that user name

What I need to do is, if some one selects a user from the drop down for the "closed by" column, I want to check if the current user is the user from the drop down... if it is.. then allow the selection.. else pop up a message box to say that they are not authorised to complete that entry.

I hope my question makes sense..

Look forward to your reply.

Kind regards

Harish