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