0 Replies Latest reply: Jan 24, 2013 12:00 PM by stysmness RSS

    Macro to catch user-entered string ('Searchable' field)

      Hi all,

      This seems a bit tough to me as I am not very good at VBS. Basically I have been trying to catch a string the user enters to the Search field - and it is getting more complex, because I need to have the values of that tiny 'Searchable' field users may open on certain objects. In the screenshot below, for instance, I would need to get the value '>77' as a string.

       

      catchfield.png

       

      A good try was a code like this:

      currentSearchString = ActiveDocument.Evaluate("GetFieldSelections(Suppliers)")
      

      which, however, only returns the Supplier names, not the filter expression.

       

      The next big thing I am trying to figure out is where to 'listen' for the event of users typing in values.

       

      Thanks.