Posts by lucassantos • 1 point

• 0

  votes

  1

  answer

  83

  views

  Q: Option "Cancel" Getopenfilename(Multiselect:= True)

  i have the following doubt, I want to use the code with the property Multiselect = True which returns a Variant() as a result, however when I click "cancel" it returns False, resulting in the…

  vba excel-vba

  asked 4 years, 6 months ago lucassantos 1

• -2

  votes

  1

  answer

  41

  views

  Q: How do I write this formula in . formula?

  How I write the formula below in . formula in vba? =SE(J5="OK";"Realizado";SE(E(J5="NOK";I5>0);"Não realizado";SE( E(J5="NOK";I5<0); "Não realizado")

  vba

  asked 4 years, 7 months ago lucassantos 1