Building custom solutions that extend, automate, and integrate Microsoft 365 apps.
Vsto conditional formatting
Jonathan Brotto
1,076
Reputation points
Trying to get the VBA conditional code into vb.net but got an error when I progress to attempt to line .FormatConditions.ReverseOrder = False
System.MissingMemberException
HResult=0x80131512
Message=Public member 'ReverseOrder' on type 'FormatConditions' not found.
Source=<Cannot evaluate the exception source>
StackTrace:
<Cannot evaluate the exception stack trace>
'conditional formatting for percent
customerYearRng = Globals.ThisAddIn.Application.Sheets("Territory Summary").Range(Chr(65 + countYearRange) & "4:" & Chr(65 + countYearRange) & "20")
With customerYearRng
.FormatConditions.AddIconSetCondition()
'.FormatConditions(FormatConditions.Count).SetFirstPriority
'.FormatConditions(1)
.FormatConditions.ReverseOrder = False
.FormatConditions.ShowIconOnly = False
.FormatConditions.IconSet.IconSets = "xl3Triangles"
'.FormatConditions(1).IconCriteria(2)
'.Type = xlConditionValueNumber
'.Value = 0
'.Operator = 7
'.FormatConditions(1).IconCriteria(3)
'.Type = xlConditionValueNumber
'.Value = 0
'.Operator = 5
End With
Microsoft 365 and Office | Development | Other
Microsoft 365 and Office | Development | Other
Developer technologies | Visual Basic for Applications
Developer technologies | Visual Basic for Applications
An implementation of Visual Basic that is built into Microsoft products.
Developer technologies | VB
Developer technologies | VB
An object-oriented programming language developed by Microsoft that can be used in .NET.
Sign in to answer