Re: $$Excel-Macros$$ Need help with Run Time Error 424 Object required

2014-12-16 Thread Rob Flott
Vabz...Thank you very much for the explanation and fix...it works... Rob On Friday, December 12, 2014 12:53:25 AM UTC-8, Vabz wrote: hi You will get error if no value is added in list box. add line on error resume next in beginning to avoid this error.. cheers + *I did not do

Re: $$Excel-Macros$$ Need help with Run Time Error 424 Object required

2014-12-16 Thread Vaibhav Joshi
cheers!! + *I did not do this for you. God is here working through me for you.* On Tue, Dec 16, 2014 at 11:09 PM, Rob Flott robfl...@gmail.com wrote: Vabz...Thank you very much for the explanation and fix...it works... Rob On Friday, December 12, 2014 12:53:25 AM UTC-8, Vabz wrote: hi

Re: $$Excel-Macros$$ Need help with Run Time Error 424 Object required

2014-12-12 Thread Vaibhav Joshi
hi You will get error if no value is added in list box. add line on error resume next in beginning to avoid this error.. cheers + *I did not do this for you. God is here working through me for you.* On Fri, Dec 12, 2014 at 1:03 AM, Rob Flott robfl...@gmail.com wrote: On a worksheet I

$$Excel-Macros$$ Need help with Run Time Error 424 Object required

2014-12-11 Thread Rob Flott
On a worksheet I have two listboxes; ListBox1 and ListBox3. Dependant upon what is selected in ListBox1...it will automatically enter the appropriate range into the ListFillRange of ListBox3: Private Sub ListBox1_Click() With ListBox3 .ListFillRange = Sheets(2).Range(T30)