Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.40 seconds.

  1. Replies
    8
    Views
    165

    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.
  2. Replies
    8
    Views
    165

    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...
  3. 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...
  4. 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 ?
  5. 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
  6. Re: Userform Checkboxes - Select All/Unselect

    I will see. Check back in a hour or two.
  7. 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 ?
  8. Replies
    8
    Views
    165

    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"))...
  9. Replies
    8
    Views
    165

    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?
  10. Replies
    3
    Views
    78

    Re: VBA - ActiveX button

    I think you should show us the script.
  11. Replies
    3
    Views
    51

    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.
  12. Replies
    3
    Views
    51

    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...
  13. Re: Userform Checkboxes - Select All/Unselect

    Replace these two Double click scripts:


    Private Sub ListboxHidden_DblClick(ByVal Cancel As MSForms.ReturnBoolean)
    'Modified 10/14/2019 4:24:10 PM EDT
    Application.ScreenUpdating = False
    On...
  14. Re: Automatically name worksheets based on cell values from master sheet

    In your original post you did not say you had not created the sheets.

    I need to know what is the sheet name of the sheet with the names in range("A3:A30")

    So you want the script to create a new...
  15. Re: Automatically name worksheets based on cell values from master sheet

    Try this:

    Sub Sheet_Names()
    'Modified 10/14/2019 9:14:55 AM EDT
    On Error GoTo M
    Application.ScreenUpdating = False
    Dim i As Long
    For i = 3 To 30
    Sheets(i - 1).Name = Sheets(1).Cells(i,...
  16. Re: Defining a name for more than one range

    Why got:
    Give the Range in Sheet(1) the Name "Apple"

    Give the Range in Sheet(2) the Name "Pie"

    Then use the formula:

    =Sum(Apple)+Sum(Pie)
  17. Re: Search sheet for name and return row value

    I do not believe a formula can do this.
    I believe you would need to use Vba

    And any time you need help it's always necessary to provide specific details

    1. You said search a column but did not...
  18. Replies
    7
    Views
    207

    Re: Scroll to last cell with date

    Glad we were able to help you.
    Come back here to Mr. Excel next time you need additional assistance.
  19. Re: Upon opening worksheet check value is present in userform

    I test my scripts and some values can be obtained from a closed UserForm.
  20. Re: Upon opening worksheet check value is present in userform

    You would need it like this:
    If answer = vbYes And PostageTransferSheet.NameForDateEntryBox.Text = "" Then

    You must provide the UserForm Name also
  21. Re: Upon opening worksheet check value is present in userform

    What is:

    NameForDateEntryBox

    Is this a Activex TextBox on the active sheet?
  22. Thread: Vba?

    by My Aswer Is This
    Replies
    5
    Views
    150

    Re: Vba?

    I would need more details.
    You said:

    I have a column of number values

    You did not say what column

    You said:

    need to find a give amount
  23. Re: Hide combobox entry options please

    Not sure this will help you but:

    If you want to enter a ListBox item into column A of the active sheet.
    And then remove that value from the Listbox

    I would put this script into a Button
    ...
  24. Re: Hide combobox entry options please

    The code you showed is not my code.
  25. Re: Hide combobox entry options please

    You asked a similar question a few moments ago about a Msgbox when list=2. Did that answer not help you.
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4