Hi,
I recently added a macro published online from Contextures (Select Multiple Items from Excel Data Validation List | Contextures Blog) that allows multiple items to be selected from a dropdown menu into one cell, however I specified this was only to be applied to one column. Now when I enter a formula in any other column the formula disappears after a value is calculated.
I am not familiar with macros/vba and do not know how to recognise the component of the coding that is causing this. Any ideas?
Best,
Kerri
I recently added a macro published online from Contextures (Select Multiple Items from Excel Data Validation List | Contextures Blog) that allows multiple items to be selected from a dropdown menu into one cell, however I specified this was only to be applied to one column. Now when I enter a formula in any other column the formula disappears after a value is calculated.
I am not familiar with macros/vba and do not know how to recognise the component of the coding that is causing this. Any ideas?
Best,
Kerri