excel vba‎ > ‎

VBA - uppercase

posted May 17, 2011, 2:27 PM by Roberto Felicini
        Version = StrConv(Sheets("home").Range("MF_version").Value, vbUpperCase)
        Market = StrConv(Sheets("home").Range("MF_market").Value, vbUpperCase)
        Flowname = StrConv(Sheets("home").Range("MF_flowname").Value, vbUpperCase)
' setup the correct mandatory field with capital letter
        Sheets("home").Range("MF_version").Value = Version
        Sheets("home").Range("MF_market").Value = Market
        Sheets("home").Range("MF_flowname").Value = Flowname
Comments