disable command button once data is recorded

hi everyone,

I am new with using excel vba and I need your expertise on this one. I am making a timesheet which has a UserForm with textbox and 3 command buttons namely Search, IN and OUT. The program works like this, user type his id no., then clicks on search, once id match command buttons for IN and OUT are enabled. User clicks on IN button then current time which tags as NOW() will be pasted on the worksheet. Same goes with the OUT button. I was able to make them work that way. The problem here now is, the data being entered are vulnerable for data-re entry. What I mean is, if a certain user has already a recorded IN time, if he clicks on the IN time again, the data will be overwritten. Is there a way that once the user has already a recorded IN time, the IN button will be disabled for that user since he has already a recorded IN data?

I appreciate your assistance.


Cheers,

Stoey

hi,

I appreciate your immediately reply. I tried your code on the IN button, it work for the first user but, when the next user will use it, the IN button is disabled same goes to succeeding users. What I want to do is that once a specific user click the IN button and his time in was recorded or pasted on the worksheet, then the IN button will be disabled since he has already entered his time IN. But for other users who dont have time in record yet on the worksheet, the IN button should be enabled for them. Same goes for them OUT button.

Any other ideas?

cheers,

Stoey

Hi roy,

thanks for the idea but how am I suppose to do that? I am new with excel vba. Can you show me how? Thanks


Cheers,

Stoey