Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Excel VBA help on Spinner
Name: Matt Shaw Date: January 24, 2009 at 04:01:14 Pacific OS: Windows XP CPU/Ram: Pentium 4, 1Gb Product: Dell / 8000 Subcategory: Microsoft Office
Comment:
I have an excel sheet containing a list of items by country, region and then town. I have given the user the ability to filter the list (using form drop downs) and this just isolates a part of the list (e.g. lines 120-150) then I have a spinner that allows them to step through these lines. My problem is that I can't dynamically alter the max, min of the spinner so in the example above I can set the value to 120 but if they click down it will go to 119. I've read there is a way to change the max/min of the spinner using VBA but I can't seem to connect to that property in the form spinner. Suggestions?
Summary: Hello, I am looking for an excel VBA script that scans my worksheet and will combine rows based on a duplicate value of a field. I have a customer spreadsheet with about 2000 customers that I export...
Summary: Hello, I am having problems with excel VBA. I have a spreadsheet which will return a cell value of "Over Due" via a formula when certain information is entered into another cell. The VBA will identif...
Summary: You have to open an instance of Access from Excel VBA and then open the database to make your changes. You should get a book on VBA if you don't have one already. John Walkenbach and John Green both ...
Excel formula
