Re: $$Excel-Macros$$ popup comments using vlookup or lookup UDF IN VB

2017-04-15 Thread 'Margareta Tolliver' via MS EXCEL AND VBA MACROS 


On Sat, 4/15/17, 'Kenyatta Freed' via MS EXCEL AND VBA MACROS 
<excel-macros@googlegroups.com> wrote:

 Subject: Re: $$Excel-Macros$$ popup comments using vlookup or lookup UDF IN VB
 To: excel-macros@googlegroups.com
 Date: Saturday, April 15, 2017, 9:57 AM
 
 
 
 On Fri, 4/14/17, 'Storey Thomas' via MS
 EXCEL AND VBA MACROS <excel-macros@googlegroups.com>
 wrote:
 
  Subject: Re: $$Excel-Macros$$ popup
 comments using vlookup or lookup UDF IN VB
  To: excel-macros@googlegroups.com
  Date: Friday, April 14, 2017, 9:07 PM
  
  
 
 
  On Fri, 4/14/17, 'Regine Silvers' via
  MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com>
  wrote:
  
   Subject: Re: $$Excel-Macros$$
 popup
  comments using vlookup or lookup UDF
 IN VB
   To: excel-macros@googlegroups.com
   Date: Friday, April 14, 2017,
 6:25 PM
   
   
  
 
 
   On Fri, 4/14/17, 'Yu Spain' via
 MS
   EXCEL AND VBA MACROS <excel-macros@googlegroups.com>
   wrote:
   
    Subject: Re: $$Excel-Macros$$
  popup
   comments using vlookup or lookup
 UDF
  IN VB
    To: excel-macros@googlegroups.com
    Date: Friday, April 14, 2017,
  1:00 PM
    
    
   
  
 
 
    On Thu, 4/13/17, 'Hopkins Ruben'
  via
   MS
    EXCEL AND VBA MACROS <excel-macros@googlegroups.com>
    wrote:
    
     Subject: Re:
 $$Excel-Macros$$
   popup
    comments using vlookup or lookup
  UDF
   IN VB
     To: excel-macros@googlegroups.com
     Date: Thursday, April 13,
 2017,
   7:02
    PM
     
     
    
   
  
 
 
     On Thu, 4/13/17, 'Liberty
   Stringer'
    via
     MS EXCEL AND VBA MACROS
 <excel-macros@googlegroups.com>
     wrote:
     
      Subject: Re:
  $$Excel-Macros$$
    popup
     comments using vlookup or
 lookup
   UDF
    IN VB
      To: excel-macros@googlegroups.com
      Date: Thursday, April 13,
  2017,
    4:49
     PM
      
      
     
    
   
  
 
 
      On Thu, 4/13/17, Paul
  Schreiner
    <schreiner_p...@att.net>
      wrote:
      
       Subject: Re:
   $$Excel-Macros$$
     popup
      comments using vlookup or
  lookup
    UDF
     IN VB
       To: "excel-macros@googlegroups.com"
      <excel-macros@googlegroups.com>
       Date: Thursday, April 13,
   2017,
     2:49
      PM
       
       Here's
       the approach I took:I
       defined a "public"
   Dictionary
     object
      called
       Dict_Category.I
       created a function to
 load
   the
      Dict_Category with the
       category listing from the
     "DATA"
      sheet.
       Being
       a "public" variable, the
   values
     are
      retained while
       the workbook is open.
       I
       created two worksheet
     
    
   
  
 
 events:Worksheet_SelectionChangeWorksheet_Change
       I
       created two events so
 that
   the
      Comments update when the
  cell
       is selected, and also if
 you
     were to
      copy/paste several
       cells into column "A".
       Personally,
       I think the Change event
 is
   the
     only
      one that is
       required.
       The
       Update_Comments function
   does
     things
      like:-
       Clears the comments from
   cells
     that
      are blank-
       Shows a message if a
 value
   is
     entered
      that is not in the
       Dictionary
       hope this gives you
 something
   to
     work
       from.
       
      
     
    
   
  
 
 Paul-
       “Do
       all the good you can,
       By all the means you can,
       In all the ways you can,
       In all the places you
 can,
       At all the times you can,
       To all the people you
 can,
       As long as ever you
 can.”
   -
     John
      Wesley
      
     
    
   
  
 
 -
       
       
        
         On Thursday, April 13,
    2017
      5:26 AM,
       sunil lobo <christl...@gmail.com>
      wrote:
         
       
        hi [U][SIZE=5]just want
  to
       have comments populate
 when
   the
     cell
      is selected based on
       the lookup/vlookup
 function
     through
       VB[/SIZE][/U]two sheet 1)
     master_sheet
       2
       )data sheet masters
 sheet
     being
       dynamic data sheet is
       staticmaster sheet
   continuosly
       changing now when  a
     particular cell
      is
       activated by using mouse
 or
       keyboard comments should
     pop-up
      getting
        the value from the next
   data
      sheet 
       eg: master sheet , cell
 a2=
   1 
                      
               cell a3=2 
                      
               cell a4=4so
 on
   and
     so
       forth 
       i

Re: $$Excel-Macros$$ popup comments using vlookup or lookup UDF IN VB

2017-04-15 Thread 'Kenyatta Freed' via MS EXCEL AND VBA MACROS 


On Fri, 4/14/17, 'Storey Thomas' via MS EXCEL AND VBA MACROS 
<excel-macros@googlegroups.com> wrote:

 Subject: Re: $$Excel-Macros$$ popup comments using vlookup or lookup UDF IN VB
 To: excel-macros@googlegroups.com
 Date: Friday, April 14, 2017, 9:07 PM
 
 
 
 On Fri, 4/14/17, 'Regine Silvers' via
 MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com>
 wrote:
 
  Subject: Re: $$Excel-Macros$$ popup
 comments using vlookup or lookup UDF IN VB
  To: excel-macros@googlegroups.com
  Date: Friday, April 14, 2017, 6:25 PM
  
  
 
 
  On Fri, 4/14/17, 'Yu Spain' via MS
  EXCEL AND VBA MACROS <excel-macros@googlegroups.com>
  wrote:
  
   Subject: Re: $$Excel-Macros$$
 popup
  comments using vlookup or lookup UDF
 IN VB
   To: excel-macros@googlegroups.com
   Date: Friday, April 14, 2017,
 1:00 PM
   
   
  
 
 
   On Thu, 4/13/17, 'Hopkins Ruben'
 via
  MS
   EXCEL AND VBA MACROS <excel-macros@googlegroups.com>
   wrote:
   
    Subject: Re: $$Excel-Macros$$
  popup
   comments using vlookup or lookup
 UDF
  IN VB
    To: excel-macros@googlegroups.com
    Date: Thursday, April 13, 2017,
  7:02
   PM
    
    
   
  
 
 
    On Thu, 4/13/17, 'Liberty
  Stringer'
   via
    MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com>
    wrote:
    
     Subject: Re:
 $$Excel-Macros$$
   popup
    comments using vlookup or lookup
  UDF
   IN VB
     To: excel-macros@googlegroups.com
     Date: Thursday, April 13,
 2017,
   4:49
    PM
     
     
    
   
  
 
 
     On Thu, 4/13/17, Paul
 Schreiner
   <schreiner_p...@att.net>
     wrote:
     
      Subject: Re:
  $$Excel-Macros$$
    popup
     comments using vlookup or
 lookup
   UDF
    IN VB
      To: "excel-macros@googlegroups.com"
     <excel-macros@googlegroups.com>
      Date: Thursday, April 13,
  2017,
    2:49
     PM
      
      Here's
      the approach I took:I
      defined a "public"
  Dictionary
    object
     called
      Dict_Category.I
      created a function to load
  the
     Dict_Category with the
      category listing from the
    "DATA"
     sheet.
      Being
      a "public" variable, the
  values
    are
     retained while
      the workbook is open.
      I
      created two worksheet
    
   
  
 
 events:Worksheet_SelectionChangeWorksheet_Change
      I
      created two events so that
  the
     Comments update when the
 cell
      is selected, and also if you
    were to
     copy/paste several
      cells into column "A".
      Personally,
      I think the Change event is
  the
    only
     one that is
      required.
      The
      Update_Comments function
  does
    things
     like:-
      Clears the comments from
  cells
    that
     are blank-
      Shows a message if a value
  is
    entered
     that is not in the
      Dictionary
      hope this gives you something
  to
    work
      from.
      
     
    
   
  
 
 Paul-
      “Do
      all the good you can,
      By all the means you can,
      In all the ways you can,
      In all the places you can,
      At all the times you can,
      To all the people you can,
      As long as ever you can.”
  -
    John
     Wesley
     
    
   
  
 
 -
      
      
       
        On Thursday, April 13,
   2017
     5:26 AM,
      sunil lobo <christl...@gmail.com>
     wrote:
        
      
       hi [U][SIZE=5]just want
 to
      have comments populate when
  the
    cell
     is selected based on
      the lookup/vlookup function
    through
      VB[/SIZE][/U]two sheet 1)
    master_sheet
      2
      )data sheet masters sheet
    being
      dynamic data sheet is
      staticmaster sheet
  continuosly
      changing now when  a
    particular cell
     is
      activated by using mouse or
      keyboard comments should
    pop-up
     getting
       the value from the next
  data
     sheet 
      eg: master sheet , cell a2=
  1 
                     
              cell a3=2 
                     
              cell a4=4so on
  and
    so
      forth 
      in data sheet , cell a2= 5 ,
    cell b2=
      present           
                    a3=2,
  cell
      b3= absent         
                      a4=
      3,cell b4= leave      
   
                     
          a5= 1, cell b5=
  leftnow
    when i
      select a3 cell in
  master_sheet i
    need
     to populate a comment
      as [B]absent[/B], when the
  cell
    a3
     changes to value [B]1[/B]
      i should get a comment
  display
    of
     value
      [B]left[/B]also when the
  cell
    value
     changes it
      chsould clear the previous
     commen

Re: $$Excel-Macros$$ popup comments using vlookup or lookup UDF IN VB

2017-04-14 Thread 'Storey Thomas' via MS EXCEL AND VBA MACROS 


On Fri, 4/14/17, 'Regine Silvers' via MS EXCEL AND VBA MACROS 
<excel-macros@googlegroups.com> wrote:

 Subject: Re: $$Excel-Macros$$ popup comments using vlookup or lookup UDF IN VB
 To: excel-macros@googlegroups.com
 Date: Friday, April 14, 2017, 6:25 PM
 
 
 
 On Fri, 4/14/17, 'Yu Spain' via MS
 EXCEL AND VBA MACROS <excel-macros@googlegroups.com>
 wrote:
 
  Subject: Re: $$Excel-Macros$$ popup
 comments using vlookup or lookup UDF IN VB
  To: excel-macros@googlegroups.com
  Date: Friday, April 14, 2017, 1:00 PM
  
  
 
 
  On Thu, 4/13/17, 'Hopkins Ruben' via
 MS
  EXCEL AND VBA MACROS <excel-macros@googlegroups.com>
  wrote:
  
   Subject: Re: $$Excel-Macros$$
 popup
  comments using vlookup or lookup UDF
 IN VB
   To: excel-macros@googlegroups.com
   Date: Thursday, April 13, 2017,
 7:02
  PM
   
   
  
 
 
   On Thu, 4/13/17, 'Liberty
 Stringer'
  via
   MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com>
   wrote:
   
    Subject: Re: $$Excel-Macros$$
  popup
   comments using vlookup or lookup
 UDF
  IN VB
    To: excel-macros@googlegroups.com
    Date: Thursday, April 13, 2017,
  4:49
   PM
    
    
   
  
 
 
    On Thu, 4/13/17, Paul Schreiner
  <schreiner_p...@att.net>
    wrote:
    
     Subject: Re:
 $$Excel-Macros$$
   popup
    comments using vlookup or lookup
  UDF
   IN VB
     To: "excel-macros@googlegroups.com"
    <excel-macros@googlegroups.com>
     Date: Thursday, April 13,
 2017,
   2:49
    PM
     
     Here's
     the approach I took:I
     defined a "public"
 Dictionary
   object
    called
     Dict_Category.I
     created a function to load
 the
    Dict_Category with the
     category listing from the
   "DATA"
    sheet.
     Being
     a "public" variable, the
 values
   are
    retained while
     the workbook is open.
     I
     created two worksheet
   
  
 
 events:Worksheet_SelectionChangeWorksheet_Change
     I
     created two events so that
 the
    Comments update when the cell
     is selected, and also if you
   were to
    copy/paste several
     cells into column "A".
     Personally,
     I think the Change event is
 the
   only
    one that is
     required.
     The
     Update_Comments function
 does
   things
    like:-
     Clears the comments from
 cells
   that
    are blank-
     Shows a message if a value
 is
   entered
    that is not in the
     Dictionary
     hope this gives you something
 to
   work
     from.
     
    
   
  
 
 Paul-
     “Do
     all the good you can,
     By all the means you can,
     In all the ways you can,
     In all the places you can,
     At all the times you can,
     To all the people you can,
     As long as ever you can.”
 -
   John
    Wesley
    
   
  
 
 -
     
     
      
       On Thursday, April 13,
  2017
    5:26 AM,
     sunil lobo <christl...@gmail.com>
    wrote:
       
     
      hi [U][SIZE=5]just want to
     have comments populate when
 the
   cell
    is selected based on
     the lookup/vlookup function
   through
     VB[/SIZE][/U]two sheet 1)
   master_sheet
     2
     )data sheet masters sheet
   being
     dynamic data sheet is
     staticmaster sheet
 continuosly
     changing now when  a
   particular cell
    is
     activated by using mouse or
     keyboard comments should
   pop-up
    getting
      the value from the next
 data
    sheet 
     eg: master sheet , cell a2=
 1 
                    
             cell a3=2 
                    
             cell a4=4so on
 and
   so
     forth 
     in data sheet , cell a2= 5 ,
   cell b2=
     present           
                   a3=2,
 cell
     b3= absent         
                     a4=
     3,cell b4= leave      
  
                    
         a5= 1, cell b5=
 leftnow
   when i
     select a3 cell in
 master_sheet i
   need
    to populate a comment
     as [B]absent[/B], when the
 cell
   a3
    changes to value [B]1[/B]
     i should get a comment
 display
   of
    value
     [B]left[/B]also when the
 cell
   value
    changes it
     chsould clear the previous
    comment basically
     it should popup comments
 based
   on the
    value from the data
     sheet !:)
     attaching herewith the
 sample
   data for
    ur
     reference
     
     
     
     -- 
     
     Are you =EXP(E:RT) or
   =NOT(EXP(E:RT))
    in Excel? And do you
     wanna be? It’s
   =TIME(2,DO:IT,N:OW) !
    Join official
     Facebook page of this forum @
 https://www.facebook.com/discussexcel
     
      
     
     FORUM RULES
     
      
     
     1) Use concise, accurate
 thread
    titles. Poor thread titles,
     like Please Help, Urg

Re: $$Excel-Macros$$ popup comments using vlookup or lookup UDF IN VB

2017-04-14 Thread 'Regine Silvers' via MS EXCEL AND VBA MACROS 


On Fri, 4/14/17, 'Yu Spain' via MS EXCEL AND VBA MACROS 
<excel-macros@googlegroups.com> wrote:

 Subject: Re: $$Excel-Macros$$ popup comments using vlookup or lookup UDF IN VB
 To: excel-macros@googlegroups.com
 Date: Friday, April 14, 2017, 1:00 PM
 
 
 
 On Thu, 4/13/17, 'Hopkins Ruben' via MS
 EXCEL AND VBA MACROS <excel-macros@googlegroups.com>
 wrote:
 
  Subject: Re: $$Excel-Macros$$ popup
 comments using vlookup or lookup UDF IN VB
  To: excel-macros@googlegroups.com
  Date: Thursday, April 13, 2017, 7:02
 PM
  
  
 
 
  On Thu, 4/13/17, 'Liberty Stringer'
 via
  MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com>
  wrote:
  
   Subject: Re: $$Excel-Macros$$
 popup
  comments using vlookup or lookup UDF
 IN VB
   To: excel-macros@googlegroups.com
   Date: Thursday, April 13, 2017,
 4:49
  PM
   
   
  
 
 
   On Thu, 4/13/17, Paul Schreiner
 <schreiner_p...@att.net>
   wrote:
   
    Subject: Re: $$Excel-Macros$$
  popup
   comments using vlookup or lookup
 UDF
  IN VB
    To: "excel-macros@googlegroups.com"
   <excel-macros@googlegroups.com>
    Date: Thursday, April 13, 2017,
  2:49
   PM
    
    Here's
    the approach I took:I
    defined a "public" Dictionary
  object
   called
    Dict_Category.I
    created a function to load the
   Dict_Category with the
    category listing from the
  "DATA"
   sheet.
    Being
    a "public" variable, the values
  are
   retained while
    the workbook is open.
    I
    created two worksheet
  
 
 events:Worksheet_SelectionChangeWorksheet_Change
    I
    created two events so that the
   Comments update when the cell
    is selected, and also if you
  were to
   copy/paste several
    cells into column "A".
    Personally,
    I think the Change event is the
  only
   one that is
    required.
    The
    Update_Comments function does
  things
   like:-
    Clears the comments from cells
  that
   are blank-
    Shows a message if a value is
  entered
   that is not in the
    Dictionary
    hope this gives you something to
  work
    from.
    
   
  
 
 Paul-
    “Do
    all the good you can,
    By all the means you can,
    In all the ways you can,
    In all the places you can,
    At all the times you can,
    To all the people you can,
    As long as ever you can.” -
  John
   Wesley
   
  
 
 -
    
    
     
      On Thursday, April 13,
 2017
   5:26 AM,
    sunil lobo <christl...@gmail.com>
   wrote:
      
    
     hi [U][SIZE=5]just want to
    have comments populate when the
  cell
   is selected based on
    the lookup/vlookup function
  through
    VB[/SIZE][/U]two sheet 1)
  master_sheet
    2
    )data sheet masters sheet
  being
    dynamic data sheet is
    staticmaster sheet continuosly
    changing now when  a
  particular cell
   is
    activated by using mouse or
    keyboard comments should
  pop-up
   getting
     the value from the next data
   sheet 
    eg: master sheet , cell a2= 1 
                   
            cell a3=2 
                   
            cell a4=4so on and
  so
    forth 
    in data sheet , cell a2= 5 ,
  cell b2=
    present           
                  a3=2, cell
    b3= absent         
                    a4=
    3,cell b4= leave        
                   
        a5= 1, cell b5= leftnow
  when i
    select a3 cell in master_sheet i
  need
   to populate a comment
    as [B]absent[/B], when the cell
  a3
   changes to value [B]1[/B]
    i should get a comment display
  of
   value
    [B]left[/B]also when the cell
  value
   changes it
    chsould clear the previous
   comment basically
    it should popup comments based
  on the
   value from the data
    sheet !:)
    attaching herewith the sample
  data for
   ur
    reference
    
    
    
    -- 
    
    Are you =EXP(E:RT) or
  =NOT(EXP(E:RT))
   in Excel? And do you
    wanna be? It’s
  =TIME(2,DO:IT,N:OW) !
   Join official
    Facebook page of this forum @ https://www.facebook.com/discussexcel
    
     
    
    FORUM RULES
    
     
    
    1) Use concise, accurate thread
   titles. Poor thread titles,
    like Please Help, Urgent, Need
  Help,
   Formula Problem, Code
    Problem, and Need Advice will
  not get
   quick attention or may
    not be answered.
    
    2) Don't post a question in the
  thread
   of another
    member.
    
    3) Don't post questions
  regarding
   breaking or bypassing
    any security measure.
    
    4) Acknowledge the responses
  you
   receive, good or bad.
    
    5) Jobs posting is not allowed.
    
    6) Sharing copyrighted material
  and
   their links is not
    allowed.
    
     
    
    NOTE  : Don't ever post
   confidential d

Re: $$Excel-Macros$$ popup comments using vlookup or lookup UDF IN VB

2017-04-14 Thread 'Keisha Fry' via MS EXCEL AND VBA MACROS 


On Fri, 4/14/17, 'Yu Spain' via MS EXCEL AND VBA MACROS 
<excel-macros@googlegroups.com> wrote:

 Subject: Re: $$Excel-Macros$$ popup comments using vlookup or lookup UDF IN VB
 To: excel-macros@googlegroups.com
 Date: Friday, April 14, 2017, 1:00 PM
 
 
 
 On Thu, 4/13/17, 'Hopkins Ruben' via MS
 EXCEL AND VBA MACROS <excel-macros@googlegroups.com>
 wrote:
 
  Subject: Re: $$Excel-Macros$$ popup
 comments using vlookup or lookup UDF IN VB
  To: excel-macros@googlegroups.com
  Date: Thursday, April 13, 2017, 7:02
 PM
  
  
 
 
  On Thu, 4/13/17, 'Liberty Stringer'
 via
  MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com>
  wrote:
  
   Subject: Re: $$Excel-Macros$$
 popup
  comments using vlookup or lookup UDF
 IN VB
   To: excel-macros@googlegroups.com
   Date: Thursday, April 13, 2017,
 4:49
  PM
   
   
  
 
 
   On Thu, 4/13/17, Paul Schreiner
 <schreiner_p...@att.net>
   wrote:
   
    Subject: Re: $$Excel-Macros$$
  popup
   comments using vlookup or lookup
 UDF
  IN VB
    To: "excel-macros@googlegroups.com"
   <excel-macros@googlegroups.com>
    Date: Thursday, April 13, 2017,
  2:49
   PM
    
    Here's
    the approach I took:I
    defined a "public" Dictionary
  object
   called
    Dict_Category.I
    created a function to load the
   Dict_Category with the
    category listing from the
  "DATA"
   sheet.
    Being
    a "public" variable, the values
  are
   retained while
    the workbook is open.
    I
    created two worksheet
  
 
 events:Worksheet_SelectionChangeWorksheet_Change
    I
    created two events so that the
   Comments update when the cell
    is selected, and also if you
  were to
   copy/paste several
    cells into column "A".
    Personally,
    I think the Change event is the
  only
   one that is
    required.
    The
    Update_Comments function does
  things
   like:-
    Clears the comments from cells
  that
   are blank-
    Shows a message if a value is
  entered
   that is not in the
    Dictionary
    hope this gives you something to
  work
    from.
    
   
  
 
 Paul-
    “Do
    all the good you can,
    By all the means you can,
    In all the ways you can,
    In all the places you can,
    At all the times you can,
    To all the people you can,
    As long as ever you can.” -
  John
   Wesley
   
  
 
 -
    
    
     
      On Thursday, April 13,
 2017
   5:26 AM,
    sunil lobo <christl...@gmail.com>
   wrote:
      
    
     hi [U][SIZE=5]just want to
    have comments populate when the
  cell
   is selected based on
    the lookup/vlookup function
  through
    VB[/SIZE][/U]two sheet 1)
  master_sheet
    2
    )data sheet masters sheet
  being
    dynamic data sheet is
    staticmaster sheet continuosly
    changing now when  a
  particular cell
   is
    activated by using mouse or
    keyboard comments should
  pop-up
   getting
     the value from the next data
   sheet 
    eg: master sheet , cell a2= 1 
                   
            cell a3=2 
                   
            cell a4=4so on and
  so
    forth 
    in data sheet , cell a2= 5 ,
  cell b2=
    present           
                  a3=2, cell
    b3= absent         
                    a4=
    3,cell b4= leave        
                   
        a5= 1, cell b5= leftnow
  when i
    select a3 cell in master_sheet i
  need
   to populate a comment
    as [B]absent[/B], when the cell
  a3
   changes to value [B]1[/B]
    i should get a comment display
  of
   value
    [B]left[/B]also when the cell
  value
   changes it
    chsould clear the previous
   comment basically
    it should popup comments based
  on the
   value from the data
    sheet !:)
    attaching herewith the sample
  data for
   ur
    reference
    
    
    
    -- 
    
    Are you =EXP(E:RT) or
  =NOT(EXP(E:RT))
   in Excel? And do you
    wanna be? It’s
  =TIME(2,DO:IT,N:OW) !
   Join official
    Facebook page of this forum @ https://www.facebook.com/discussexcel
    
     
    
    FORUM RULES
    
     
    
    1) Use concise, accurate thread
   titles. Poor thread titles,
    like Please Help, Urgent, Need
  Help,
   Formula Problem, Code
    Problem, and Need Advice will
  not get
   quick attention or may
    not be answered.
    
    2) Don't post a question in the
  thread
   of another
    member.
    
    3) Don't post questions
  regarding
   breaking or bypassing
    any security measure.
    
    4) Acknowledge the responses
  you
   receive, good or bad.
    
    5) Jobs posting is not allowed.
    
    6) Sharing copyrighted material
  and
   their links is not
    allowed.
    
     
    
    NOTE  : Don't ever post
   confidential d

Re: $$Excel-Macros$$ popup comments using vlookup or lookup UDF IN VB

2017-04-14 Thread 'Yu Spain' via MS EXCEL AND VBA MACROS 


On Thu, 4/13/17, 'Hopkins Ruben' via MS EXCEL AND VBA MACROS 
<excel-macros@googlegroups.com> wrote:

 Subject: Re: $$Excel-Macros$$ popup comments using vlookup or lookup UDF IN VB
 To: excel-macros@googlegroups.com
 Date: Thursday, April 13, 2017, 7:02 PM
 
 
 
 On Thu, 4/13/17, 'Liberty Stringer' via
 MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com>
 wrote:
 
  Subject: Re: $$Excel-Macros$$ popup
 comments using vlookup or lookup UDF IN VB
  To: excel-macros@googlegroups.com
  Date: Thursday, April 13, 2017, 4:49
 PM
  
  
 
 
  On Thu, 4/13/17, Paul Schreiner <schreiner_p...@att.net>
  wrote:
  
   Subject: Re: $$Excel-Macros$$
 popup
  comments using vlookup or lookup UDF
 IN VB
   To: "excel-macros@googlegroups.com"
  <excel-macros@googlegroups.com>
   Date: Thursday, April 13, 2017,
 2:49
  PM
   
   Here's
   the approach I took:I
   defined a "public" Dictionary
 object
  called
   Dict_Category.I
   created a function to load the
  Dict_Category with the
   category listing from the
 "DATA"
  sheet.
   Being
   a "public" variable, the values
 are
  retained while
   the workbook is open.
   I
   created two worksheet
 
 events:Worksheet_SelectionChangeWorksheet_Change
   I
   created two events so that the
  Comments update when the cell
   is selected, and also if you
 were to
  copy/paste several
   cells into column "A".
   Personally,
   I think the Change event is the
 only
  one that is
   required.
   The
   Update_Comments function does
 things
  like:-
   Clears the comments from cells
 that
  are blank-
   Shows a message if a value is
 entered
  that is not in the
   Dictionary
   hope this gives you something to
 work
   from.
   
  
 
 Paul-
   “Do
   all the good you can,
   By all the means you can,
   In all the ways you can,
   In all the places you can,
   At all the times you can,
   To all the people you can,
   As long as ever you can.” -
 John
  Wesley
  
 
 -
   
   
    
     On Thursday, April 13, 2017
  5:26 AM,
   sunil lobo <christl...@gmail.com>
  wrote:
     
   
    hi [U][SIZE=5]just want to
   have comments populate when the
 cell
  is selected based on
   the lookup/vlookup function
 through
   VB[/SIZE][/U]two sheet 1)
 master_sheet
   2
   )data sheet masters sheet
 being
   dynamic data sheet is
   staticmaster sheet continuosly
   changing now when  a
 particular cell
  is
   activated by using mouse or
   keyboard comments should
 pop-up
  getting
    the value from the next data
  sheet 
   eg: master sheet , cell a2= 1 
                  
           cell a3=2 
                  
           cell a4=4so on and
 so
   forth 
   in data sheet , cell a2= 5 ,
 cell b2=
   present           
                 a3=2, cell
   b3= absent         
                   a4=
   3,cell b4= leave        
                  
       a5= 1, cell b5= leftnow
 when i
   select a3 cell in master_sheet i
 need
  to populate a comment
   as [B]absent[/B], when the cell
 a3
  changes to value [B]1[/B]
   i should get a comment display
 of
  value
   [B]left[/B]also when the cell
 value
  changes it
   chsould clear the previous
  comment basically
   it should popup comments based
 on the
  value from the data
   sheet !:)
   attaching herewith the sample
 data for
  ur
   reference
   
   
   
   -- 
   
   Are you =EXP(E:RT) or
 =NOT(EXP(E:RT))
  in Excel? And do you
   wanna be? It’s
 =TIME(2,DO:IT,N:OW) !
  Join official
   Facebook page of this forum @ https://www.facebook.com/discussexcel
   
    
   
   FORUM RULES
   
    
   
   1) Use concise, accurate thread
  titles. Poor thread titles,
   like Please Help, Urgent, Need
 Help,
  Formula Problem, Code
   Problem, and Need Advice will
 not get
  quick attention or may
   not be answered.
   
   2) Don't post a question in the
 thread
  of another
   member.
   
   3) Don't post questions
 regarding
  breaking or bypassing
   any security measure.
   
   4) Acknowledge the responses
 you
  receive, good or bad.
   
   5) Jobs posting is not allowed.
   
   6) Sharing copyrighted material
 and
  their links is not
   allowed.
   
    
   
   NOTE  : Don't ever post
  confidential data in a workbook.
   Forum owners and members are
 not
  responsible for any loss.
   
   --- 
   
   You received this message
 because you
  are subscribed to the
   Google Groups "MS EXCEL AND VBA
  MACROS" group.
   
   To unsubscribe from this group
 and
  stop receiving emails
   from it, send an email to
  excel-macros+unsubscr...@googlegroups.com.
   
   To post to this group, send
 email to
  excel-macros@googlegroups.com.
   
   Visit this group at
 
 https://groups.google.com/group/excel-macros.
   
   For more options, visi

Re: $$Excel-Macros$$ popup comments using vlookup or lookup UDF IN VB

2017-04-13 Thread 'Hopkins Ruben' via MS EXCEL AND VBA MACROS 


On Thu, 4/13/17, 'Liberty Stringer' via MS EXCEL AND VBA MACROS 
<excel-macros@googlegroups.com> wrote:

 Subject: Re: $$Excel-Macros$$ popup comments using vlookup or lookup UDF IN VB
 To: excel-macros@googlegroups.com
 Date: Thursday, April 13, 2017, 4:49 PM
 
 
 
 On Thu, 4/13/17, Paul Schreiner <schreiner_p...@att.net>
 wrote:
 
  Subject: Re: $$Excel-Macros$$ popup
 comments using vlookup or lookup UDF IN VB
  To: "excel-macros@googlegroups.com"
 <excel-macros@googlegroups.com>
  Date: Thursday, April 13, 2017, 2:49
 PM
  
  Here's
  the approach I took:I
  defined a "public" Dictionary object
 called
  Dict_Category.I
  created a function to load the
 Dict_Category with the
  category listing from the "DATA"
 sheet.
  Being
  a "public" variable, the values are
 retained while
  the workbook is open.
  I
  created two worksheet
 events:Worksheet_SelectionChangeWorksheet_Change
  I
  created two events so that the
 Comments update when the cell
  is selected, and also if you were to
 copy/paste several
  cells into column "A".
  Personally,
  I think the Change event is the only
 one that is
  required.
  The
  Update_Comments function does things
 like:-
  Clears the comments from cells that
 are blank-
  Shows a message if a value is entered
 that is not in the
  Dictionary
  hope this gives you something to work
  from.
  
 
 Paul-
  “Do
  all the good you can,
  By all the means you can,
  In all the ways you can,
  In all the places you can,
  At all the times you can,
  To all the people you can,
  As long as ever you can.” - John
 Wesley
 
 -
  
  
   
    On Thursday, April 13, 2017
 5:26 AM,
  sunil lobo <christl...@gmail.com>
 wrote:
    
  
   hi [U][SIZE=5]just want to
  have comments populate when the cell
 is selected based on
  the lookup/vlookup function through
  VB[/SIZE][/U]two sheet 1) master_sheet
  2
  )data sheet masters sheet being
  dynamic data sheet is
  staticmaster sheet continuosly
  changing now when  a particular cell
 is
  activated by using mouse or
  keyboard comments should pop-up
 getting
   the value from the next data
 sheet 
  eg: master sheet , cell a2= 1 
                 
          cell a3=2 
                 
          cell a4=4so on and so
  forth 
  in data sheet , cell a2= 5 , cell b2=
  present           
                a3=2, cell
  b3= absent         
                  a4=
  3,cell b4= leave        
                 
      a5= 1, cell b5= leftnow when i
  select a3 cell in master_sheet i need
 to populate a comment
  as [B]absent[/B], when the cell a3
 changes to value [B]1[/B]
  i should get a comment display of
 value
  [B]left[/B]also when the cell value
 changes it
  chsould clear the previous
 comment basically
  it should popup comments based on the
 value from the data
  sheet !:)
  attaching herewith the sample data for
 ur
  reference
  
  
  
  -- 
  
  Are you =EXP(E:RT) or =NOT(EXP(E:RT))
 in Excel? And do you
  wanna be? It’s =TIME(2,DO:IT,N:OW) !
 Join official
  Facebook page of this forum @ https://www.facebook.com/discussexcel
  
   
  
  FORUM RULES
  
   
  
  1) Use concise, accurate thread
 titles. Poor thread titles,
  like Please Help, Urgent, Need Help,
 Formula Problem, Code
  Problem, and Need Advice will not get
 quick attention or may
  not be answered.
  
  2) Don't post a question in the thread
 of another
  member.
  
  3) Don't post questions regarding
 breaking or bypassing
  any security measure.
  
  4) Acknowledge the responses you
 receive, good or bad.
  
  5) Jobs posting is not allowed.
  
  6) Sharing copyrighted material and
 their links is not
  allowed.
  
   
  
  NOTE  : Don't ever post
 confidential data in a workbook.
  Forum owners and members are not
 responsible for any loss.
  
  --- 
  
  You received this message because you
 are subscribed to the
  Google Groups "MS EXCEL AND VBA
 MACROS" group.
  
  To unsubscribe from this group and
 stop receiving emails
  from it, send an email to
 excel-macros+unsubscr...@googlegroups.com.
  
  To post to this group, send email to
 excel-macros@googlegroups.com.
  
  Visit this group at
 https://groups.google.com/group/excel-macros.
  
  For more options, visit
 https://groups.google.com/d/optout.
  
  
       
  
  
  
  -- 
  
  Are you =EXP(E:RT) or =NOT(EXP(E:RT))
 in Excel? And do you
  wanna be? It’s =TIME(2,DO:IT,N:OW) !
 Join official
  Facebook page of this forum @ https://www.facebook.com/discussexcel
  
   
  
  FORUM RULES
  
   
  
  1) Use concise, accurate thread
 titles. Poor thread titles,
  like Please Help, Urgent, Need Help,
 Formula Problem, Code
  Problem, and Need Advice will not get
 quick attention or may
  not be answered.
  
  2) Don't post a question in the thread
 of a

Re: $$Excel-Macros$$ popup comments using vlookup or lookup UDF IN VB

2017-04-13 Thread 'Liberty Stringer' via MS EXCEL AND VBA MACROS 


On Thu, 4/13/17, Paul Schreiner <schreiner_p...@att.net> wrote:

 Subject: Re: $$Excel-Macros$$ popup comments using vlookup or lookup UDF IN VB
 To: "excel-macros@googlegroups.com" <excel-macros@googlegroups.com>
 Date: Thursday, April 13, 2017, 2:49 PM
 
 Here's
 the approach I took:I
 defined a "public" Dictionary object called
 Dict_Category.I
 created a function to load the Dict_Category with the
 category listing from the "DATA" sheet.
 Being
 a "public" variable, the values are retained while
 the workbook is open.
 I
 created two worksheet events:Worksheet_SelectionChangeWorksheet_Change
 I
 created two events so that the Comments update when the cell
 is selected, and also if you were to copy/paste several
 cells into column "A".
 Personally,
 I think the Change event is the only one that is
 required.
 The
 Update_Comments function does things like:-
 Clears the comments from cells that are blank-
 Shows a message if a value is entered that is not in the
 Dictionary
 hope this gives you something to work
 from.
 
 Paul-
 “Do
 all the good you can,
 By all the means you can,
 In all the ways you can,
 In all the places you can,
 At all the times you can,
 To all the people you can,
 As long as ever you can.” - John Wesley
 -
 
 
  
   On Thursday, April 13, 2017 5:26 AM,
 sunil lobo <christl...@gmail.com> wrote:
   
 
  hi [U][SIZE=5]just want to
 have comments populate when the cell is selected based on
 the lookup/vlookup function through
 VB[/SIZE][/U]two sheet 1) master_sheet  2
 )data sheet masters sheet being
 dynamic data sheet is
 staticmaster sheet continuosly
 changing now when  a particular cell is
 activated by using mouse or
 keyboard comments should pop-up getting
  the value from the next data sheet 
 eg: master sheet , cell a2= 1 
                
         cell a3=2 
                
         cell a4=4so on and so
 forth 
 in data sheet , cell a2= 5 , cell b2=
 present           
               a3=2, cell
 b3= absent         
                 a4=
 3,cell b4= leave        
                
     a5= 1, cell b5= leftnow when i
 select a3 cell in master_sheet i need to populate a comment
 as [B]absent[/B], when the cell a3 changes to value [B]1[/B]
 i should get a comment display of value
 [B]left[/B]also when the cell value changes it
 chsould clear the previous comment basically
 it should popup comments based on the value from the data
 sheet !:)
 attaching herewith the sample data for ur
 reference
 
 
 
 -- 
 
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you
 wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official
 Facebook page of this forum @ https://www.facebook.com/discussexcel
 
  
 
 FORUM RULES
 
  
 
 1) Use concise, accurate thread titles. Poor thread titles,
 like Please Help, Urgent, Need Help, Formula Problem, Code
 Problem, and Need Advice will not get quick attention or may
 not be answered.
 
 2) Don't post a question in the thread of another
 member.
 
 3) Don't post questions regarding breaking or bypassing
 any security measure.
 
 4) Acknowledge the responses you receive, good or bad.
 
 5) Jobs posting is not allowed.
 
 6) Sharing copyrighted material and their links is not
 allowed.
 
  
 
 NOTE  : Don't ever post confidential data in a workbook.
 Forum owners and members are not responsible for any loss.
 
 --- 
 
 You received this message because you are subscribed to the
 Google Groups "MS EXCEL AND VBA MACROS" group.
 
 To unsubscribe from this group and stop receiving emails
 from it, send an email to excel-macros+unsubscr...@googlegroups.com.
 
 To post to this group, send email to excel-macros@googlegroups.com.
 
 Visit this group at https://groups.google.com/group/excel-macros.
 
 For more options, visit https://groups.google.com/d/optout.
 
 
  
 
 
 
 -- 
 
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you
 wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official
 Facebook page of this forum @ https://www.facebook.com/discussexcel
 
  
 
 FORUM RULES
 
  
 
 1) Use concise, accurate thread titles. Poor thread titles,
 like Please Help, Urgent, Need Help, Formula Problem, Code
 Problem, and Need Advice will not get quick attention or may
 not be answered.
 
 2) Don't post a question in the thread of another
 member.
 
 3) Don't post questions regarding breaking or bypassing
 any security measure.
 
 4) Acknowledge the responses you receive, good or bad.
 
 5) Jobs posting is not allowed.
 
 6) Sharing copyrighted material and their links is not
 allowed.
 
  
 
 NOTE  : Don't ever post confidential data in a workbook.
 Forum owners and members are not responsible for any loss.
 
 --- 
 
 You received this message because you are subscribed to the
 Google Groups "MS EXCEL AND VBA MACROS" group.
 
 To unsubscribe fr

Re: $$Excel-Macros$$ popup comments using vlookup or lookup UDF IN VB

2017-04-13 Thread Paul Schreiner 
Here's the approach I took:I defined a "public" Dictionary object called 
Dict_Category.I created a function to load the Dict_Category with the category 
listing from the "DATA" sheet.
Being a "public" variable, the values are retained while the workbook is open.
I created two worksheet events:Worksheet_SelectionChangeWorksheet_Change
I created two events so that the Comments update when the cell is selected, and 
also if you were to copy/paste several cells into column "A".
Personally, I think the Change event is the only one that is required.
The Update_Comments function does things like:- Clears the comments from cells 
that are blank- Shows a message if a value is entered that is not in the 
Dictionary
hope this gives you something to work from.

Paul-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
- 

On Thursday, April 13, 2017 5:26 AM, sunil lobo  
wrote:
 

 hi [U][SIZE=5]just want to have comments populate when the cell is selected 
based on the lookup/vlookup function through VB[/SIZE][/U]two sheet 1) 
master_sheet  2 )data sheet masters sheet being dynamic data sheet is 
staticmaster sheet continuosly changing now when  a particular cell is 
activated by using mouse or keyboard comments should pop-up getting  the value 
from the next data sheet 
eg: master sheet , cell a2= 1                          cell a3=2                
          cell a4=4so on and so forth 
in data sheet , cell a2= 5 , cell b2= present                          a3=2, 
cell b3= absent                          a4= 3,cell b4= leave                   
          a5= 1, cell b5= leftnow when i select a3 cell in master_sheet i need 
to populate a comment as [B]absent[/B], when the cell a3 changes to value 
[B]1[/B] i should get a comment display of value [B]left[/B]also when the cell 
value changes it chsould clear the previous comment basically it should popup 
comments based on the value from the data sheet !:)
attaching herewith the sample data for ur reference-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel
 
FORUM RULES
 
1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
 
NOTE : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


   

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


Sample file.xlsb
Description: application/vnd.ms-excel.sheet.binary.macroenabled.12

$$Excel-Macros$$ popup comments using vlookup or lookup UDF IN VB

2017-04-13 Thread sunil lobo 
hi
[U][SIZE=5]just want to have comments populate when the cell is selected
based on the lookup/vlookup function through VB[/SIZE][/U]
two sheet 1) master_sheet  2 )data sheet
masters sheet being dynamic
data sheet is static
master sheet continuosly changing
now when  a particular cell is activated by using mouse or keyboard
comments should pop-up getting  the value from the next data sheet

eg: master sheet , cell a2= 1
  cell a3=2
  cell a4=4
so on and so forth

in data sheet , cell a2= 5 , cell b2= present
  a3=2, cell b3= absent
  a4= 3,cell b4= leave
  a5= 1, cell b5= left
now when i select a3 cell in master_sheet i need to populate a comment as
[B]absent[/B], when the cell a3 changes to value [B]1[/B] i should get a
comment display of value [B]left[/B]
also when the cell value changes it chsould clear the previous comment
basically it should popup comments based on the value from the data sheet
!:)

attaching herewith the sample data for ur reference

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


Sample file.xls
Description: MS-Excel spreadsheet