Search:

Type: Posts; User: ColdBore

Search: Search took 0.03 seconds.

  1. Re: [RESOLVED] Application ScreenUpdating=false not working on userfrom_activate

    Vbfbryce , that was the solution, no need to unhide the sheet. Thank you everyone for the help!!!
  2. Re: Application ScreenUpdating=false not working on userfrom_activate

    No that didn't work either westconn1. I moved screenupdating around to various lines in "Private Sub PartListTrans_Click() "Private Sub UserForm_Activate()" I also moved some of the lines of...
  3. Re: Application ScreenUpdating=false not working on userfrom_activate

    That's correct the sheet is VeryHidden when Workbook opens. I only need it open for this single userform. It needs to remain VeryHidden after the routine is complete.
  4. [RESOLVED] Application ScreenUpdating=false not working on userfrom_activate

    Gurus

    My problem:When the "Transer" userform is activated the user can view actions being performed on the sheet "Stored" (xlVeryHidden) which I do not want visible.

    I have a userform...
  5. Re: Autofiltering one column based on multiple true falses from checkbox

    Thanks westconn1

    I couldn't get the recordsets concept to work, just wasn't able to wrap my head around the process(4 days of trying). I was able to find a piece of code that worked though. I used...
  6. [RESOLVED] Autofiltering one column based on multiple true falses from checkbox

    Good Evening

    I have a userform were the user selects from one to four checkboxes to see whom is in charge of a project. The various projects are in column 1.I want the user to be able to select...
  7. Re: Excel extract list of ranges from columns of numbers based on critera

    Thank You wetconn1.
    It works!!
    This is the final code.
    --------------------------------------------------------------------------------------------------------------------------------------

    Sub...
  8. Re: Excel extract list of ranges from columns of numbers based on critera

    westconn1

    Thanks for the help already. I have issues getting results, can you have a look at my attempt?
    Here's my feeble attempt at getting the results to display (or print)from the union with...
  9. [RESOLVED] Excel extract list of ranges from columns of numbers based on critera

    I've been looking for a way to retrieve a list of ranges from columns of sequential and none sequential numbers. The results would go to a new sheet - same workbook. I've achieved this before with...
Results 1 to 9 of 9



Click Here to Expand Forum to Full Width