We have a new software at work and I am trying to define certain parameters of the appearance. What I would like to do is if (s5) below returns the desired code, then the neighboring box would be empty. s5 = tlead1.text / the box I want emptied under the condition of s5 is labeled tweek.text
Here is the code that took me all day to figure out. I don't really have another day to work on it to try to get the right thing to happen.
When s5 = "0": tlead1.Value = "In Stock";
This works great! However, the value is lead time and when it is not "0" it needs to say Week(s) in the neighboring text box.