Results 1 to 2 of 2
  1. #1
    Silver Lounger
    Join Date
    Mar 2001
    Springfield, Ohio, USA
    Thanked 2 Times in 2 Posts

    Smart??? Tags (XL 2002)

    In Excel 2002, if you enter '22 into a cell or if you use the Format | Cells | Number tab to format the cell as text and then enter a number into that cell, then you get a little green tag on the left, a tool-tip, and a pop-up menu telling you that you have formatted a number as text. What are these little green tags called? In VBA, how can you select all of the cells on a worksheet that are flagged with the "Error Tag" (that's the name that I made up) set to "number formatted as text." They are not in the new SmartTags collection as I thought that they would be. TIA --Sam
    <font face="Comic Sans MS">Sam Barrett, CACI </font face=comic>
    <small>And the things that you have heard... commit these to faithful men who will be able to teach others also. 2 Timothy 2:2</small>

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Dublin, Ireland, Republic of
    Thanked 0 Times in 0 Posts

    Re: Smart??? Tags (XL 2002)

    Sammy, as you correctly deduced these "inconsistent" or "error" tags do not belong to the Smart Tag feature.

    I do not think that you can selectcells containing the indicators through VBA, but you can set what can be included by using the Application.ErrorCheckingOptions


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts