I have a cell whos value is changed when a button is clicked. This cell is B9 and the value is 1 if the German button is clicked and 2 if the English button is clicked
I have several cells that the user inputs a value into. This value is in inches if the English button is clicked and mm if the German Button is clicked
I would like a code that would do the following.
If Cell B9 changes from 1-2 then divide cells C1, C2, D3, D5 by 25.4
If Cell B9 changes from 2-1 then multiply cells C1, C2, D3, D5 by 25.4
I want the cell number to change but only when cell B9 changes value
I was going to use the Application.WorksheetFunction.Convert(c.Value, "in", "mm") to do this conversion but don't know how to create an array that includes non-contiguous cells and to only do this if the cell B9 changes from one value to the other.
There are probably 40 cells throughout the sheet that I need to put into the array but they never change location.
Any help would be greatly appreciated as I do this for length, weight and temperature values
I have several cells that the user inputs a value into. This value is in inches if the English button is clicked and mm if the German Button is clicked
I would like a code that would do the following.
If Cell B9 changes from 1-2 then divide cells C1, C2, D3, D5 by 25.4
If Cell B9 changes from 2-1 then multiply cells C1, C2, D3, D5 by 25.4
I want the cell number to change but only when cell B9 changes value
I was going to use the Application.WorksheetFunction.Convert(c.Value, "in", "mm") to do this conversion but don't know how to create an array that includes non-contiguous cells and to only do this if the cell B9 changes from one value to the other.
There are probably 40 cells throughout the sheet that I need to put into the array but they never change location.
Any help would be greatly appreciated as I do this for length, weight and temperature values