Reference information: https://support.microsoft.com/en-us/...8-f1a89e210877
Sample screenshot attached, below is sample code.
Question: I would like to check if the cell has company or not, in sample screenshot, the IF statement should return False, but it runs into error --- Type mismatched.
How to fix my code?
To make my question clearer: how to determine if a cell has stock data -- Company ?
Thanks
Stock Data.JPG
Please Login or Register to view this content.
Last edited by VAer; 12-11-2021 at 09:43 PM.
ArtikPlease Login or Register to view this content.
Thanks, it works for my program. But technically, it seems that Stock Data is subset of RichDataType. Sounds that they are not same, there must be other types of RichDataType.
I don't think you will find this type of detail in VBA. This may be because types are handled by third-party add-ins.
One solution may be an intermediate check on the content in the cell. In the case of the Stocks type, the stock symbol and company symbol are required, e.g. (XNAS:MSFT), (XNAS:AAPL), (XNYS:TSN). You can check if the content of the cell matches the pattern, e.g.ArtikPlease Login or Register to view this content.
Thanks. I learn one more thing from your post, checking Cell.Formula . I did not know that before. I only know checking cell value Cell.Value
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks