Posts by Lectric

    Re: spinButton problem

    Problem solved.
    Found the following code on MrExcel

    Can anyone shed some light on what I might be doing wrong. I have a user form with several fields and I'm trying to use spin buttons where possible to alleviate too much validation. With the code posted below the Date SpinButton works fine but I can't get either of the Time ones to work.

    Evening all,
    I have downloaded the workbook with advanced filter with criteria but I'm stuck with one modification.
    I have got it to do look ups on my own database in excel but for some reason I can't seem to get it to show
    all the relevant rows. I have changed the number of rows it copies from 100 to 500 but it refuses to copy more than 20 records.
    Any enlightenment would be much appreciated as apart from this it does everything I need.