I’d like to ask for some excel VB help.
I have a column B in the range B1:B31. The text contains the words “Enabled”, or “Disabled”. My goal is that when a button is clicked, the code would loop through all the values in the range B1:B31, and if it finds the text “Enabled”, it will replace the next column (same row) over with a value. I believe this is offset (0,1).
Example. So as the code is scanning the range, it comes across cell B3, if it find the word “Enabled” in this cell, then it will insert ] the value from the default time estimate into cell C3.