Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.19 seconds.

  1. Replies
    3
    Views
    86

    Re: VBA or Conditional Formatting

    I never open files posted to this forum.

    I gave you a suggested way. But I guess that did not work for you.
    Having the script always work at exactly midnight is not something I know how to do.
    ...
  2. Re: individual cell date modified will be marked in another cell

    I explained in earlier post but here it is again:

    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...
  3. Re: individual cell date modified will be marked in another cell

    You will not need to do as you said:
    I will need to repeat the formula, code or whatever about 30 times for 30 different rows.

    This script performs the same task for all cells in column 4

    When...
  4. Re: individual cell date modified will be marked in another cell

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

    Re: VBA or Conditional Formatting

    Using Vba this could be done.
    But instead of Midnight how about when you enter the value Red into Range("A1")
    After that the script starts running

    Using Midnight would mean Excel must be running...
  6. Re: How to tab to a specific control automatically once an option button inside a frame is selected

    Glad I was able to help you.
    Come back here to Mr. Excel next time you need additional assistance.
  7. Re: How to tab to a specific control automatically once an option button inside a frame is selected

    Put these three scripts in your UserForm
    You may need more depending on number of Option Buttons


    Private Sub OptionButton2_Click()
    Call SetMyFocus
    End Sub
    Private Sub OptionButton3_Click()...
  8. Re: How to tab to a specific control automatically once an option button inside a frame is selected

    I thought you said you wanted script to run when you clicked on Frame.

    Then I would suggest you use Mumps suggestion
  9. Re: How to tab to a specific control automatically once an option button inside a frame is selected

    That is because the script looks to see if any Option Button is clicked. If no option button is true then their is no message to report.
  10. Re: How to tab to a specific control automatically once an option button inside a frame is selected

    Try this for your test of controls:
    Since you want script to run when you click on Frame:


    Private Sub Frame1_Click()
    'Modified 7/20/2019 5:04:38 PM EDT
    Dim c As Control
    For Each c In...
  11. Replies
    2
    Views
    95

    Re: VBA Not working help improve

    I would think it should be If Target.value=

    Or is this a actual named range?

    I do not believe that is a proper named Range.
  12. Re: Insert Rows Based on criteria (or CountIf?)

    Glad I was able to help you.
    Come back here to Mr. Excel next time you need additional assistance.
  13. Re: Insert Rows Based on criteria (or CountIf?)

    Try this:
    I test all my scripts and it worked for me but try this:

    Sub Insert_Rows()
    'Modified 7/19/2019 7:25:22 PM EDT
    Application.ScreenUpdating = False
    Dim lastrow As Long
    lastrow = 300...
  14. Re: Insert Rows Based on criteria (or CountIf?)

    If you see on line 5 of the code it says Sheets("Data") activate

    So the count is coming from column E of sheet named Data

    So your saying it's not working properly?

    It looks down column E on...
  15. Re: Insert Rows Based on criteria (or CountIf?)

    Try this:

    Sub Insert_Rows()
    'Modified 7/19/2019 5:33:32 PM EDT
    Application.ScreenUpdating = False
    Dim lastrow As Long
    Sheets("Data").Activate
    lastrow = Cells(Rows.Count, "E").End(xlUp).Row...
  16. Re: Insert Rows Based on criteria (or CountIf?)

    Or try this using Filter:

    Sub Filter_Me_Please()
    'Modified 7/19/2019 7:38:46 AM EDT
    Application.ScreenUpdating = False
    Dim lastrow As Long
    Sheets("Data").Activate
    Dim c As Long
    Dim s As...
  17. Re: Insert Rows Based on criteria (or CountIf?)

    Try this:

    Sub Copy_Me_Maybe()
    'Modified 7/19/2019 6:49:38 AM EDT
    Application.ScreenUpdating = False
    Dim i As Long
    Dim Lastrowa As Long
    Dim Lastrow As Long
    Sheets("Data").Activate
    Lastrow...
  18. Replies
    5
    Views
    159

    Re: Copying non-blank rows

    Glad to hear that.

    Maybe you would like to show me the code you wrote.
  19. Replies
    2
    Views
    114

    Re: VBA Loop if then

    I'm confused.
    You said:

    A2 in sheet Raw

    if Sheet Raw Cell B2

    Why do you say A2 then B2 ?

    And are we suppose to repeat this process all the way down to last cell in sheet raw column A...
  20. Re: How can I edit this recorded macro to include all sheets?

    Now that your saying the number of rows will not always be the same.
    Try this:

    Sub All_Sheets()
    'Modified 7/18/2019 11:57:43 PM EDT
    Application.ScreenUpdating = False
    Dim i As Long
    Dim...
  21. Re: How can I edit this recorded macro to include all sheets?

    To do all sheets try this:

    Sub All_Sheets()
    'Modified 7/18/2019 11:46:30 PM EDT
    Application.ScreenUpdating = False
    Dim i As Long
    For i = 1 To Sheets.Count
    ...
  22. Re: VBA code to copy X amount of rows from all sheets and paste to new sheet

    I was one. I had trouble running scripts with the name MM1. Running Excel 2013. I just changed the script name.
  23. Re: Excel Userform - Multiple Checkbox comments populate textbox upon clicking

    What is a CheckBox Value ??
  24. Re: Excel Userform - Multiple Checkbox comments populate textbox upon clicking

    You said:


    So there are 2 text boxes. 1 textbox would need to collect the "comments" from 4 checkboxes. Then the other textbox would need to collect the comments from the other 4 checkboxes.
    ...
  25. Re: Excel Userform - Multiple Checkbox comments populate textbox upon clicking

    So if I understand correctly.

    You want to click on one checkbox which will result in entering the same value into a section of textboxes.

    The key word here is section.

    Excel has no such...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4