Search:

Type: Posts; User: My Aswer Is This; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.38 seconds.

  1. Replies
    3
    Views
    104

    Re: One table multiple sheets ?

    I have no real answer other then writing a Vba script to hide certain columns.

    But then your wanting those columns arranged in a exact order that is not the standard order

    I'm sure someone else...
  2. Replies
    18
    Views
    261

    Re: VBA UserForm with Check Box

    You said:

    selection = 'string generated by cmd button

    What is selection?

    Do you mean active cell.

    And your putting this in the initialize script which runs during the open Userform
    This...
  3. Replies
    3
    Views
    104

    Re: One table multiple sheets ?

    I would suggest this:

    I assume your saying you want to work on column 20 to 30 sometimes but do not really need to see column 1 to 19

    So you would like to see column 20 where column 1 now is so...
  4. Replies
    18
    Views
    261

    Re: VBA UserForm with Check Box

    If your willing to use a UserForm Listbox.

    For this example place a Listbox on your Userform
    My script assumes your listbox will be named ListBox1

    Then install a button on your Userform and...
  5. Replies
    18
    Views
    261

    Re: VBA UserForm with Check Box

    My original thought also.
  6. Replies
    18
    Views
    261

    Re: VBA UserForm with Check Box

    After looking at this:

    1. A checkbox cannot be named 5644 Elm Street
    CheckBoxes can only be given charter names like Alpha Bravo Charlie
    So we would have to use the caption value.

    And I...
  7. Replies
    18
    Views
    261

    Re: VBA UserForm with Check Box

    So the script needs to look at all CheckBoxes on the Userform.

    And if they are checked then add the name of the checkbox to the string?

    If that true?
  8. Re: Expand rows based on cell value in VBA - multiple in worksheet

    Which script worked. There were two solutions provided?
  9. Replies
    18
    Views
    261

    Re: VBA UserForm with Check Box

    A UserForm Checkbox only has a true or false value.
    If the checkbox is checked it returns a value of true
    If not checked it returns a value of False.

    Now a Checkbox does have a name such as...
  10. Replies
    18
    Views
    261

    Re: VBA UserForm with Check Box

    Lets talk about this first:

    I am trying to create a pretty simple UserForm that will contain 4-10 choices that I want end users to select all that apply and then create a text string based on...
  11. Replies
    3
    Views
    123

    Re: Where to Start?

    I do not understand what move on means.
    You said:

    'if the customer has invoices prior to 2019 then ignore them and move on to the next customer. Basically creating a list of new customers for...
  12. Re: Expand rows based on cell value in VBA - multiple in worksheet

    You said:

    I've been trolling this forum on how to expand grouped rows

    So I assume this means Group or Ungrop

    Not Hidden or Unhidden.
  13. Re: Expand rows based on cell value in VBA - multiple in worksheet

    Try this:
    This is an auto sheet event script
    Your Workbook must be Macro enabled
    To install this code:
    Right-click on the sheet tab
    Select View Code from the pop-up context menu
    Paste the code...
  14. Replies
    8
    Views
    229

    Re: VBA: Hide rows based on column A

    Oh. I guess I forgot to Dim i
    Glad I was able to help you.
    Come back here to Mr. Excel next time you need additional assistance.
  15. Replies
    8
    Views
    229

    Re: VBA: Hide rows based on column A

    I like it when users tell me their ultimate goal and let me suggest how it should be done

    If I understand your question correctly then here is what you want.

    If Range("B2") value="In" and if...
  16. Re: userform listbox - using find to populate

    I would prefer you tell me what your wanting to do.

    Showing us a script which you have but which is not doing what you want is not helpful to me.

    So please provide specific details about what...
  17. Re: VBA to search a column for the first instance of a date within a designated month

    Why did you not answer the question in Post 2 ?
  18. Re: Userform Checkboxes - Select All/Unselect

    I really do not know how you could do this.
    We could have another listbox and you could copy the items to it.

    Like right click on Listbox1 value and that value could be added the ListBox3
  19. Re: Userform Checkboxes - Select All/Unselect

    I will see. Check back in a hour or two.
  20. Re: Userform Checkboxes - Select All/Unselect

    You said:

    mimics the order that I arranged them in on the Userform.

    How do you plan to arrange them?

    You want to some how arrange them by dragging them around in the userform ?
  21. Replies
    8
    Views
    229

    Re: VBA: Hide rows based on column A

    Try this:

    Private Sub Worksheet_Change(ByVal Target As Range)
    'Modified 10/17/2019 4:52:50 PM EDT
    Me.Cells.EntireRow.Hidden = False

    If Not Intersect(Target, Me.Range("B2"))...
  22. Replies
    8
    Views
    229

    Re: VBA: Hide rows based on column A

    I read this question but was not sure about the numbers in column A

    If we unhide the rows do the 1's and 2's need to be removed?
  23. Replies
    3
    Views
    90

    Re: VBA - ActiveX button

    I think you should show us the script.
  24. Replies
    3
    Views
    56

    Re: Delete row based on value

    Glad I was able to help you.
    Come back here to Mr. Excel next time you need additional assistance.
  25. Replies
    3
    Views
    56

    Re: Delete row based on value

    Try this:

    Sub Filter_Me_Please()
    'Modified 10/16/2019 12:06:52 PM EDT
    Application.ScreenUpdating = False
    Dim lastrow As Long
    Dim c As Long
    Dim s As Variant
    c = 1 ' Column Number Modify...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4