Change cell value using Radio button

It is not entirely clear to me. Maybe so.

What you need to do is to pick a cell where the chosrn radiobutton is reflected. After that based on the value you do the appropiate action with the CHOOSE function

With an if formula that counts the number of arguments will che k if all columns are filled or not.

See attachment

Originally Posted by Vraag en antwoord

It is not entirely clear to me. Maybe so.

Thanks for the reply.

firstly i expected a VBA solution, since im expecting to share this with file with external users there's a chance of deleting or modifying updated formula fields.
Secondly, i expect the following behaviour as well as i mentioned in the attachment.

"All 3 options should take place only for rows where Column A,B & C are not blank. If certain cells are incomplete in a row then a message box should pop-up"

Originally Posted by Roel Jongman

What you need to do is to pick a cell where the chosrn radiobutton is reflected. After that based on the value you do the appropiate action with the CHOOSE function

With an if formula that counts the number of arguments will che k if all columns are filled or not.

Hi Roel, as i mentioned in my previous post, im expecting a VBA solution. plus following validation should also take place.

"All 3 options should take place only for rows where Column A,B & C are not blank. If certain cells are incomplete in a row then a message box should pop-up"

thanks

Originally Posted by Pepe Le Mokko

Sorry for off-topic interjection:

Although there is no official rule regarding this behavior, we request that wherever possible both the question AND the answer be provided in substantive detail here within the thread. An attached workbook is an excellent aid for posing a question and offering a solution, but solely doing that with no in thread explanation makes it difficult for researchers to understand or consider the Q & A of this thread without downloading what may be a pointless doc to them, if they can do that at all. Doing that also hides the content from search engines so others may never benefit from this.

I'm sure you understand, and we look forward to seeing you post your formulas/macros in your posts for the searching benefit of all.

Thanks again for all your hard work here!

apologies. just modified the original post

noted...

Why with VBA? You can still protect the tab.
I also don't see the usefulness of the notification.