- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report
By using:
If iProp.Value is Nothing
If iProp.Value = ""
If iProp.Value.IsNullOrEmpty
All 3 of these work by just checking the contents of the String Type Variable and any one would work for this case. If they have writing in them, but its not what you want, you have to compare the format then.
Ie; if your part number is supposed to be like 123-4567 we could check for the format usingthe like operator from vb.net (google "vb.net msdn like operator" for more info)
iProp.Value Like "###-####" ' # is a number wildcard; just means it's a digit, - is the symbol itself.
Or something simpler like:
iProp.Value Like "*-*" '* is a wildcard when using the like operator; can be any char(number/letter/symbol) and any number of chars
(https://msdn.microsoft.com/en-us/library/swf8kaxw.aspx)
--------------------------------------
Did you find this reply helpful ? If so please use the 'Accept as Solution' or 'Like' button below.
Inventor 2018.2.3, Build 227 | Excel 2013+ VBA
ERP/CAD Communication | Custom Scripting
Machine Design | Process Optimization
iLogic/Inventor API: Autodesk Online Help | API Shortcut In Google Chrome | iLogic API Documentation
Vb.Net/VBA Programming: MSDN | Stackoverflow | Excel Object Model
Inventor API/VBA/Vb.Net Learning Resources: Forum Thread
Sample Solutions:Debugging in iLogic ( and Batch PDF Export Sample ) | API HasSaveCopyAs Issues |
BOM Export & Column Reorder | Reorient Skewed Part | Add Internal Profile Dogbones |
Run iLogic From VBA | Batch File Renaming| Continuous Pick/Rename Objects
Local Help: %PUBLIC%\Documents\Autodesk\Inventor 2018\Local Help
Ideas: Dockable/Customizable Property Browser | Section Line API/Thread Feature in Assembly/PartsList API Static Cells | Fourth BOM Type