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 wrote: Subject: Re: $$Excel-Macros$$ popup comments using vlookup or lookup UDF IN VB To: excel-macros@googlegroups.com Date: Thursday, April 13, 2017,

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 wrote: Subject: Re: $$Excel-Macros$$ popup comments using vlookup or lookup UDF IN VB To: "excel-macros@googlegroups.com" Date: Thursday, April 13, 2017, 2:49

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

$$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