Help about an automation i want to create

[damav78]

Hi, I would like your help in an issue that i cannot find a way to solve.
I have 2 cells.
The first one has a dropdown list with one option only available.
The second one is a formula cell that collects multiple data from other cells and its dynamic. It means that when i change values to other cells this cell is affected.
So what i would like to do is:
When the first cell is blank the values on second cell to change as normally do (dynamically).
If from the first cell i choose the predefined value from my dropdown list then the second cell to actually "lock" the current value that has at that moment and dosen't be affected anymore from any changes.
Thank you in advance

 

[damav78]

Does the formula work properly when it is manually entered into Q7?

Yes. the the previous code working fine. The only thing was that if i wanted to go back and delete the text so the Q7 was back in formula i had to do it manually by selectin the cell and the green arrow over it, and select the restore to calculated column formula.

 

[mumps]

Try replacing the semicolumn in the formula with a comma.

 

[damav78]

Try replacing the semicolumn in the formula with a comma.

In the formula or in the code window where you add the formula of the cell? Because if you refer to the cell formula i always use semicolon because comma doesn't work for my formulas

 

[mumps]

In what country are you located?

 

[Fluff]

if you refer to the cell formula i always use semicolon because comma doesn't work for my formulas

As VBA is US centric, you need to use a comma, regardless of how you would enter it in a cell.

 

[damav78]

In what country are you located?

Greece

 

[mumps]

Please see Post #15 by @Fluff.

 

[damav78]

In what country are you located?

Yes!!! It's working great!!! Replacing semicolon with comma in the code solve the problem.
So now i have save my file as xlsm do i have to worry about anything else or not? I mean this file has multiple sheets tables etc. so i am asking if it affects my sheets or my table in anyway

 

[mumps]

It should have no effect on any other sheet.

 

[damav78]

Please see Post #15 by @Fluff.

Yes. I did. Thank you also very much @Fluff !!!