Hi,
I was wondering if someone could help me please?
I'm just trying to setup a new userform (MES_ASA) but I am struggling with codes for 2 of the command buttons.
What I've managed to do so far is when the operator selects either Azera, L, M and N in column E the userform appears and if they press "Yes" the userform closes.
What I would like to happen with the 2 commands I'm struggling with is:
Command button 2 "No" - I would like when pressed, to clear the contents of cells E and K and the exit the userform.
Command Button 3 "Unavailable" - I would like when pressed, is to enter the words "MES_ASA Unavailable" in column L and then exit the userform.
Any help would be much appreciated.
Kind Regards
Dan
Bookmarks