Re: $$Excel-Macros$$ Re: ListFillRange Property of ActiveX ListBox

2014-01-26 Thread Anoop K Sharma
Sorry, I din't see the mail.. I hope it worked well.. Thanks Ricardo.. On Sun, Jan 26, 2014 at 10:10 PM, Rob Flott wrote: > Ricardo, > > Thank you very much, I really appreciate your help. > > Rob > > On Fri, Jan 24, 2014 at 7:15 PM, Ricardo® wrote: > >> Hi Rob, >> To solve the problem of er

Re: $$Excel-Macros$$ Re: ListFillRange Property of ActiveX ListBox

2014-01-26 Thread Rob Flott
Ricardo, Thank you very much, I really appreciate your help. Rob On Fri, Jan 24, 2014 at 7:15 PM, Ricardo® wrote: > Hi Rob, > To solve the problem of error, you can delete this ( > Sheets("List3").Select ), it will not affect the main macro. > > Basole > > > > > 2014/1/24 Rob Flott > >> Anoo

Re: $$Excel-Macros$$ Re: ListFillRange Property of ActiveX ListBox

2014-01-24 Thread Ricardo®
Hi Rob, To solve the problem of error, you can delete this ( Sheets("List3").Select ), it will not affect the main macro. Basole 2014/1/24 Rob Flott > Anoop, > > When I opened the file I got run time error '57121' > "Application-defined or object-defined error" > And when I clicked Debug it

Re: $$Excel-Macros$$ Re: ListFillRange Property of ActiveX ListBox

2014-01-24 Thread Rob Flott
Anoop, When I opened the file I got run time error '57121' "Application-defined or object-defined error" And when I clicked Debug it took me to the Sub Workbook Open() and highlighted the line Sheets.("List").select Any ideas as to why I'd get that error message? Thank you for your help with thi

Re: $$Excel-Macros$$ Re: ListFillRange Property of ActiveX ListBox

2014-01-22 Thread Anoop K Sharma
Hi Rob, Please have look at attached one... On Thu, Jan 23, 2014 at 6:48 AM, Rob Flott wrote: > > > On Wednesday, January 22, 2014 3:36:19 PM UTC-8, Rob Flott wrote: >> >> Using MS Excel 2010 I have an ActiveX ListBox and want to load a range of >> names. This range will vary, and I have a Na

$$Excel-Macros$$ Re: ListFillRange Property of ActiveX ListBox

2014-01-22 Thread Rob Flott
On Wednesday, January 22, 2014 3:36:19 PM UTC-8, Rob Flott wrote: > > Using MS Excel 2010 I have an ActiveX ListBox and want to load a range of > names. This range will vary, and I have a Named Cell that identifies the > range. For example the range of names in one example is A3:A8. But in

$$Excel-Macros$$ Re: ListFillRange Property of ActiveX ListBox

2014-01-22 Thread Rob Flott
On Wednesday, January 22, 2014 3:36:19 PM UTC-8, Rob Flott wrote: > > Using MS Excel 2010 I have an ActiveX ListBox and want to load a range of > names. This range will vary, and I have a Named Cell that identifies the > range. For example the range of names in one example is A3:A8. But in