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 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
>>
>> You
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
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 wrote:
>
> On a worksheet I have two listboxe
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")
.S
