Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.37 seconds.

  1. Replies
    4
    Views
    102

    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"))...
  2. Replies
    4
    Views
    102

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

    Re: VBA - ActiveX button

    I think you should show us the script.
  4. Replies
    3
    Views
    47

    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.
  5. Replies
    3
    Views
    47

    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...
  6. 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...
  7. 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...
  8. 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,...
  9. 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)
  10. 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...
  11. Replies
    7
    Views
    205

    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.
  12. Re: Upon opening worksheet check value is present in userform

    I test my scripts and some values can be obtained from a closed UserForm.
  13. 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
  14. Re: Upon opening worksheet check value is present in userform

    What is:

    NameForDateEntryBox

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

    by My Aswer Is This
    Replies
    5
    Views
    148

    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
  16. 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
    ...
  17. Re: Hide combobox entry options please

    The code you showed is not my code.
  18. 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.
  19. Re: Hide combobox entry options please

    Show us how your loading these values into your ComboBox
  20. Re: Show msgbox when combobox entries = 2

    Or this:

    If ComboBox2.ListCount = 2 Then MsgBox "Hello"
  21. Re: Show msgbox when combobox entries = 2

    Try this:

    If ComboBox2.ListCount < 3 Then MsgBox "Hello"
  22. Re: Userform Checkboxes - Select All/Unselect

    Well in case you wanted to see my plan here is the Code you need to put into your Userform
    Just in case you want to see how it works create a New Userform and install:
    One ListBox named:...
  23. Re: Display message based on cell value

    Try this:

    Private Sub Worksheet_Change(ByVal Target As Range)
    'Modified 10/10/2019 2:19:44 AM EDT
    On Error GoTo M
    Application.EnableEvents = False
    If Target.CountLarge > 1 Then Exit Sub
    If...
  24. Re: Userform Checkboxes - Select All/Unselect

    So you tell me.

    What do you want to do?
    Are you now wanting to use the ListBox Ideal?
    And you want all the values in Row(7) loaded into both Listboxes when the userform is Opened?

    If this is...
  25. Re: Copy Paste Data in different sheet

    Try this:

    Private Sub Worksheet_Change(ByVal Target As Range)
    'Modified 10/9/2019 9:07:36 AM EDT
    If Target.Cells.CountLarge > 1 Or IsEmpty(Target) Then Exit Sub
    Application.EnableEvents =...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4