Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.39 seconds.

  1. Re: Userform - add new item to combobox drop down list

    If the answer to my previous question is yes then add this script to your UserForm

    Private Sub UserForm_Initialize()
    'Modified 7/16/2019 6:05:20 PM EDT
    Dim Lastrow As Long
    Lastrow =...
  2. Re: Userform - add new item to combobox drop down list

    Please never use the term "Other Sheet" when asking for help

    Please give the name of the sheet.
    Please give the name of the ComboBox on your UserForm

    So are you saying you want to see all the...
  3. Re: Automatically take rows from one sheet to various anothers based on 2 criteria

    Well that could be done if there is something on that row which is unique that could identify that row.
    And this could get more complicated. If user enters Old into column O row is copied to both...
  4. Re: Automatically take rows from one sheet to various anothers based on 2 criterial

    It would add another row.
    My question is. Why do you not run the script by entering one of those values like Old New or Complete into column O of the Master sheet and you will see how it works.
    I...
  5. Re: Automatically take rows from one sheet to various anothers based on 2 criterial

    It will be added as a new row.

    You must have not used the script yet or you would have seen how it works.
    Have you not used it yet?
    Is this not what you want?
  6. Re: Automatically take rows from one sheet to various anothers based on 2 criterial

    So assuming it now works.
    Glad I was able to help you.
    Come back here to Mr. Excel next time you need additional assistance.
  7. Re: Automatically take rows from one sheet to various anothers based on 2 criterial

    So tell me what happened when you ran the script.
    Did you get a error code?

    So to run the script you needed to enter Old New or Complete in column O
  8. Re: VBA Macro shortcut to "paste special formula"

    So you have code that does not work and you want us to incorporate our code into your code?
    And you have not shown us your formula. That would be hard for me to do.
  9. Re: VBA Macro shortcut to "paste special formula"

    My question would be:
    What Range do you want to sum and where do you want the results entered.

    If your going to use Vba why copy the formula?

    Vba can just put the results of the formula in a...
  10. Re: Automatically take rows from one sheet to various anothers based on 2 criterial

    Try this:

    This is an auto sheet event script
    Your Workbook must be Macro enabled
    To install this code:
    Right-click on the Master sheet tab
    Select View Code from the pop-up context menu
    Paste...
  11. Re: Automatically take rows from one sheet to various anothers based on 2 criterial

    In your original post you said:

    Each time we add a new row to the master the row of data needs to be moved to 1 or multiple sheets depending on criteria.

    But in your last posting you said:
    And...
  12. Re: Automatically take rows from one sheet to various anothers based on 2 criterial

    Please provide exact specific sheet names.

    Are you saying if in Column O you enter:
    "New" you want this entire row copied to sheet named "New"

    Or if you enter: "Old" in column O you want this...
  13. Re: Use lookup to enter value in the adjacent cell

    This may work:

    SearchRange.Resize(,4).ClearContents
  14. Re: Use lookup to enter value in the adjacent cell

    Show me the script your now using with your modifications.

    And how can you find the value in:

    the record was found on AA19:AD19

    The script only looks in column AA

    And then you said:
  15. Re: Use lookup to enter value in the adjacent cell

    Glad I was able to help you.
    Come back here to Mr. Excel next time you need additional assistance.
  16. Re: Use lookup to enter value in the adjacent cell

    You left out a lot of details.
    Like the name of the Userform Label.
    What value you want entered in Column AB

    This script assumes your label is named label1

    And you want the value 3 entered...
  17. Replies
    5
    Views
    207

    Re: Copy Similar Heading Sheet

    I asked for specifics. I see none in your last posting

    Your original post said:

    How can i copy the same heading row from multiple sheet to one sheet.
  18. Replies
    5
    Views
    207

    Re: Copy Similar Heading Sheet

    Can I assume the heading row is row One

    And you want to copy row(1) from Multiple sheets to one sheet.

    We need to know from what sheets do we copy from and what sheet do we copy to.

    We need...
  19. Re: How to Overlay a User Button on a Worksheet to activate a macro when clicked?

    You said:

    Tried a User Form with a Control Button: can't get it to overlay om my Worksheet.

    I do not understand what overlay means.
  20. Replies
    13
    Views
    414

    Re: Need help with userform vba

    You said:

    Hi, i need opt_BookOut when selected to minus the value from textbox5

    I see no line of code that refers to:
    opt_BookOut
    <strike>
    </strike>
  21. Replies
    13
    Views
    414

    Re: Need help with userform vba

    You said in previous post:

    As you can see in the code below when i select opt_In it adds the value.

    But then when I said show me where that line of code is you said:


    Not quite sure which...
  22. Replies
    13
    Views
    414

    Re: Need help with userform vba

    There is a lot of code here. Show me the specific lines of code you want modified.
  23. Replies
    13
    Views
    414

    Re: Need help with userform vba

    I never open Links on this Forum.
    If you need some help I may be able to help you if you provide specific details about what you want to accomplish.

    Please provide sheet names and ranges.

    Say...
  24. Replies
    6
    Views
    193

    Re: Locking a Checkbox to a line

    I'm not sure what your wanting.

    Tell me when you click om the checkbox what do you want to happen?

    For example say when I click on checkbox I want Range("C2"). value to say "Yes"

    And when...
  25. Replies
    6
    Views
    193

    Re: Locking a Checkbox to a line

    I never believe it's a good practice to use a lot of Checkboxes like this:

    When you click on the Checkbox what do you expect to happen?

    Why not use something like double click on B1 and do...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4