+ Reply to Thread
Results 1 to 5 of 5

Remove input boxes in working code

  1. #1
    Forum Contributor
    Join Date
    07-28-2012
    Location
    madrid
    MS-Off Ver
    Excel 2010 at work excel 2016
    Posts
    1,102

    Remove input boxes in working code

    Hi I need some to help me to remove the 2 input boxes in below code.
    Myval have to be :21:*
    MyCol the range have to be from A2 to last used row(will be blanks between, but shall not change them.)

    Please have a look. If its possible to make so Myval can be with 3 inputs like this, it will be optimal. If so they have to run one by one in below order.So the code first run with :21:* and then further on

    :21:*
    :61:*
    :86:NUMBER*

    Please have a look have been clumcy around in this some timem, so would like some help.

    thanks in advance

    Abjac

    Please Login or Register  to view this content.
    Last edited by abjac; 02-15-2013 at 07:18 AM.

  2. #2
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Remove input boxes in working code

    You can put Myval in to an array

    Please Login or Register  to view this content.
    MyCol:You could also use Usedrange, instead of looping through specific rows
    Last edited by AB33; 02-15-2013 at 07:34 AM.

  3. #3
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Remove input boxes in working code

    Abjac,
    I am making few assumptions. You want to search more than one value. You can change these on the array it self. I have not touched the rest of the code. I can not test it as I do not have any data.

    The site has been very slow and keep crashing, so, I am going to Siesta until the site is back, but you can play around with the code and see it can be further be improved.


    Please Login or Register  to view this content.

  4. #4
    Forum Contributor
    Join Date
    07-28-2012
    Location
    madrid
    MS-Off Ver
    Excel 2010 at work excel 2016
    Posts
    1,102

    Re: Remove input boxes in working code

    HI AB33. It did insert blank rows but only first time. But dont there miss any range for the column. In my code there is a inputbox also for the range. I would like it to search from A2 to last cell(can be blanks between)
    the number it have to look in is like this below.

    Please inut this in a sheet column A from A2 with a header. I search after :21:* the star is the wild card

    Sincerely

    Abjac


    Please Login or Register  to view this content.

  5. #5
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Remove input boxes in working code

    Abjac,
    Try this one. Unless you want to search in a specific column, it is faster to use usedrange so that the code will only search the required range. I have tested it and insert a code when it finds the 3 values. If you just want to search in column A starting from row 2, you can change this line

    Please Login or Register  to view this content.
    INTO

    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    Last edited by AB33; 02-15-2013 at 04:55 PM.

  6. #6
    Forum Contributor
    Join Date
    07-28-2012
    Location
    madrid
    MS-Off Ver
    Excel 2010 at work excel 2016
    Posts
    1,102

    Re: Remove input boxes in working code

    Hi AB33. This code works like a charm really good and your right much more fast. Thanks allot.

    Have a nice day

    Have another similar code, where i really would like to be able to use the arrey. Have tried but so far no luck.

    Could you have a look at my new thread about that one, its very similar to this onewith the same numbers.
    its called " Put arrey function into working code"
    And it have to work with the same numbers in column A

    Sincerely
    Abjac
    Last edited by abjac; 02-15-2013 at 08:11 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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