Office VBA教程:Condition属性

本主题中的某些内容可能不适用于某些语言。

返回指定搜索条件的状态。MsoCondition 类型,只读。

MsoCondition 可为以下 MsoCondition 常量之一:
msoConditionAnyNumberBetween
msoConditionAnytime
msoConditionAnytimeBetween
msoConditionAtLeast
msoConditionAtMost
msoConditionBeginsWith
msoConditionDoesNotEqual
msoConditionEndsWith
msoConditionEquals
msoConditionFileTypeAllFiles
msoConditionFileTypeBinders
msoConditionFileTypeCalendarItem
msoConditionFileTypeContactItem
msoConditionFileTypeDatabases
msoConditionFileTypeDataConnectionFiles
msoConditionFileTypeDesignerFiles
msoConditionFileTypeEPaperFiles
msoConditionFileTypeExcelWorkbooks
msoConditionFileTypeJournalItem
msoConditionFileTypeMailItem
msoConditionFileTypeNoteItem
msoConditionFileTypeOfficeFiles
msoConditionFileTypeOutlookItems
msoConditionFileTypePhotoDrawFiles
msoConditionFileTypePowerPointPresentations
msoConditionFileTypeProjectFiles
msoConditionFileTypePublisherFiles
msoConditionFileTypeTaskItem
msoConditionFileTypeTemplates
msoConditionFileTypeVisioDocuments
msoConditionFileTypeWebPages
msoConditionFileTypeWordDocuments
msoConditionFreeText
msoConditionIncludes
msoConditionIncludesFormsOf
msoConditionIncludesNearEachOther
msoConditionIncludesPhrase
msoConditionInTheLast
msoConditionInTheNext
msoConditionIsExactly
msoConditionIsNo
msoConditionIsNot
msoConditionIsYes
msoConditionLastMonth
msoConditionLastWeek
msoConditionLessThan
msoConditionMoreThan
msoConditionNextMonth
msoConditionNextWeek
msoConditionOn
msoConditionOnOrAfter
msoConditionOnOrBefore
msoConditionThisMonth
msoConditionThisWeek
msoConditionToday
msoConditionTomorrow
msoConditionYesterday

VBA示例

本示例可实现的功能为:返回第一个属性测试中搜索条件的状态值。


With Application.FileSearch.PropertyTests(1)
    MsgBox "The condition you've set is: " & .Condition
End With

上页:Office VBA教程:Comparison属性 下页:Office VBA教程:Conjunction属性

Office VBA教程:Condition属性

Office VBA教程:Conjunction属性 Office VBA教程:Connect属性
Office VBA教程:Connector属性 Office VBA教程:ConnectString属性
Office VBA教程:Context属性 Office VBA教程:Controls属性
Office VBA教程:Count属性 Office VBA教程:Creator属性
Office VBA教程:DataSource属性 Office VBA教程:Description属性
Office VBA教程:DescriptionText属性 Office VBA教程:DialogType属性
Office VBA教程:DisableAskAQuestionDropdown属性 Office VBA教程:DisableCustomize属性
Office VBA教程:DisplayFonts属性 Office VBA教程:DisplayKeysInTooltips属性
Office VBA教程:DisplayTooltips属性 Office VBA教程:DropDownLines属性
Office VBA教程:DropDownWidth属性 Office VBA教程:Enabled属性
版权所有 © 中山市飞娥软件工作室 证书:粤ICP备09170368号