CommandButton Dynamic Caption and Case Sorting
This is a new post because I am uncertain how to expand my previous post asking the same question, I have new updated code that doesn’t error, but it doesn’t work either. Column C is fiber 1-864, Column G is Distance, Column E is a Stat column, and some entries say “Live”, so I’m hoping to sort the live ones to the top with the E sort. I’ve yet to see the CommandButton update it’s caption, and i’ve yet to see anything Sort. The Fiber is already sorted from before importing to this sheet, so, I don’t know if that isn’t working.