Userform Command Buttons needing certain coding

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

It's a little pointless attaching a workbook with a password protected project...

Regardless, while you have a sub to open the userform

Please Login or Register  to view this content.

please explain how/when that is executed and which row is to be updated.

Hi cytop,

Sorry I thought I'd removed the password. The password is "motorola"

I've been searching the internet for answers about the coding I require and I put that in on my first search thinking I needed it. I realise now its not needed.

Kind Regards
Dan

What you need it to get a result from the user and update accordingly...

Skeleton code for the userform as below

Please Login or Register  to view this content.

Note the userform is only hidden when a button is clicked - it needs to be still loaded so the calling procedure can check which button was clicked.. The calling procedure (or at least the part dealing with Col E) changes like so:

Please Login or Register  to view this content.

Your logic to check the actual input to the cells not tested...

Hi cytop,

that's worked brilliantly, thank you so much.

Kind Regards
Dan

Hi cytop,

I was wondering if you could help a little more with your/my coding please?

Everything you've done is perfect but what I've realised is if an operator selects the "MES_ASA Unavailable" button by mistake and then deletes what's in cell E via the keyboard, it leaves "MES_ASA Unavailable" in cell L.

Is there some coding that can be added so if cell E is deleted via the keyboard it also deletes whats in cell L?

Thanks again for your help.

Kind Regards

Dan

Just add an 'ElseIF' in the Worksheet_Change event handler checking if cel is blank and clearing Col L on the same row if it is...

Please Login or Register  to view this content.

perfect again cytop, thank you.

Just as a minor update, move the lines Disabling & Enabling Events outside the For ... Next loop.

Not that it matters, but clearing the cell in column L will cause the Change event to fire again - there's nothing there that will execute for a change in L but there's no point executing code needlessly.