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. 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...
  2. Replies
    1
    Views
    44

    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...
  3. 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.
  4. 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()...
  5. 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
  6. 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.
  7. 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...
  8. Replies
    2
    Views
    93

    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.
  9. 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.
  10. 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...
  11. 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...
  12. 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...
  13. 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...
  14. 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...
  15. Replies
    5
    Views
    152

    Re: Copying non-blank rows

    Glad to hear that.

    Maybe you would like to show me the code you wrote.
  16. Replies
    2
    Views
    109

    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...
  17. 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...
  18. 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
    ...
  19. 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.
  20. Re: Excel Userform - Multiple Checkbox comments populate textbox upon clicking

    What is a CheckBox Value ??
  21. 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.
    ...
  22. 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...
  23. Replies
    5
    Views
    152

    Re: Copying non-blank rows

    I hope you figured it out on your own and did not get the results from another online help forum.
  24. Re: Need a VBA Macro to hide/ unhide rows based on a string in a cell value

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

    Re: Copying non-blank rows

    You asked that the row be copied. But did not say where to copy it to.
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4