+ Reply to Thread
Results 1 to 1 of 1

Macros with buttons, spin buttons, scroll buttons, etc.

  1. #1
    Registered User
    Join Date
    12-12-2013
    Location
    Lithuania
    MS-Off Ver
    MS Office 2013
    Posts
    1

    Macros with buttons, spin buttons, scroll buttons, etc.

    Hello folks, new member here looking for your wisdom to get my information technology exam done!

    First things first, I'd like to apologize for my non-fluent English.

    Now for my problems:
    1) I have a table with >100 entries that is scrollable using Form Controls Scroll Bar. Also, I have a button called 'Filter' which is supposed to work like this: from a data validation list I can select laptop manufacturer, laptops processor, video card, memory, disk drive, price, etc. and when I assign a macro to that button using advanced filter, it filters only those records that I can see. Lets say I have 25 Asus laptops in my list, but table is showing only 20 of them, so advanced filter will filter only those 20 records with multiple criteria. Is there a solution that it would filter all those records including those that are at the end of the table and are not visible?


    2) It would be great if you guys could help me to make a filter for that same button from 1) question, that could filter price from 999 to 9599.

    3) Here comes a really tough one. In the same table I've made a shopping cart icon which should work like this: table has 20 records (with scrollable bar) and 20 icons. If I click on an icon it would copy required information to the other sheet. I've made it to do only for the first record, but how could I make it that it would copy those records sliding down the table? Lets say I need to copy 31st record, so I scroll down by 11 points and click the shopping cart icon. It should copy exactly 31st record in that table, but in my case it copies 20th record, since the button was made to copy 20th line...

    4) Just like in 3) question the same icon should work like this: in the next sheet is a table where I want to copy all my records from previous table. If row 10 is not filled with data, it should copy the data from previous table to the 1st row. If 1st row has data, it should copy data to the next row, until 10th row is filled. Any ideas? Would appreciate it ALOT!

    5) I've made a spin button disappear based on cell value. If a table does not have data in 1st row, spin button in 1st row which calculates quantity disappears (becomes invisible). Is there a way to modify the code I'm attaching to hide other 9 spin buttons according to their row data? If row 2 does not have any data, spin button 2 would become invisible and so on?
    http://pastebin.com/GK8Mx1mr <--- worksheet VBA code.

    6) Will this code for a printer icon work? It has to print a page where that icon is. Cannot test it, since I don't have a printer...
    http://pastebin.com/X7BGVZrp <--- printer icon VBA code.

    Once again, any help would be appreciated,
    Best regards,
    David.

    Also posted:
    http://www.mrexcel.com/forum/excel-q...ttons-etc.html
    http://www.ozgrid.com/forum/showthre...84744&p=694963
    http://www.vbaexpress.com/forum/show...s-etc&p=301600
    Attached Files Attached Files
    Last edited by qqbbppdd; 12-12-2013 at 10:55 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. How to insert and user of Buttons, Radio buttons, check boxes in excel sheet.
    By krishco in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-03-2013, 02:52 AM
  2. How can I insert multiple sets of option buttons (radio buttons) in Excel 2010?
    By mickwooduclan in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-25-2013, 10:01 AM
  3. [SOLVED] Reset spin buttons to zero
    By Aland2929 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-06-2011, 05:55 AM
  4. spin buttons
    By svay in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-01-2008, 01:48 PM
  5. Replies: 2
    Last Post: 08-05-2005, 05:05 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1