Search:

Type: Posts; User: Yongle; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.09 seconds.

  1. Replies
    9
    Views
    241

    Re: Sorting Code (alphabetize) stopped working

    Glad that helped :beerchug:


    You do - but on another thread please
  2. Replies
    5
    Views
    147

    Re: File save as location

    I think this answers both your questions
    http://codevba.com/excel/workbook_saveas.htm#.Xam5mmZ7nIU
  3. Re: Runtime error 91 Object Variable or with block variable not set

    In my case

    - a lot of trial and error

    - google can help as a good starting point - but NEVER simply copy and use code found (after initial testing to confirm it works) without deconstructing...
  4. Replies
    4
    Views
    80

    Re: Excel VB Textobxes Characters

    glad it helped
    thanks for the feedback
    :beerchug:
  5. Replies
    9
    Views
    241

    Re: Sorting Code (alphabetize) stopped working

    Is the worksheet protected :confused::confused:

    If so ...

    Sub SortDataWithoutHeader()
    Const pWord = "password"
    Dim rng As Range
    Set rng =...
  6. Replies
    9
    Views
    241

    Re: Sorting Code (alphabetize) stopped working

    Sub SortDataWithoutHeader()
    Dim rng As Range
    Set rng = ActiveWorkbook.Worksheets("Ports").Range("B3:K102")
    rng.Sort Key1:=Range("B3"), Order1:=xlAscending, Header:=xlNo
    End...
  7. Replies
    9
    Views
    241

    Re: Sorting Code (alphabetize) stopped working

    Range B3:K102 is referred to in the code but selected cells are not used so the line is of no consequence
    Delete the line below

    Range("B3:K102").Select

    and run the code again to see if the...
  8. Re: Delete all defined named ranges from a selection

    been busy - will look at this for you tomorrow
  9. Replies
    4
    Views
    80

    Re: Excel VB Textobxes Characters

    Enter all text in TextBoxComments and then run the code

    Code below written for active-x textboxes embedded in a worksheet
    Code simplified to make it easy to follow
    Place code in SHEET module...
  10. Re: VBA Hide unhide depend on Cell Value where rows are same for different cell value.

    thanks for your feedback :beerchug:
  11. Re: VBA Hide unhide depend on Cell Value where rows are same for different cell value.

    Screamer_87
    To test the method provided by dmt32 paste the code into the SHEET module (not Module1, Module2 etc)
  12. Re: Runtime error 91 Object Variable or with block variable not set

    OR...

    Load both columns into the Combobox (display either or both columns in userfom) and use the value in the 2nd column to populate the label
    (zero based so Column(0) is the first column)

    ...
  13. Re: VBA Hide unhide depend on Cell Value where rows are same for different cell value.

    What I do is to HIDE every row in each range first and then unhide ONLY the ones I want visible

    This may not be what you want, but it provides a method that you can adapt to your needs


    Sub...
  14. Replies
    9
    Views
    241

    Re: Sorting Code (alphabetize) stopped working

    Sub ThisLineIsGood()
    Range("B3:K102").Select
    End Sub

    The above line works without issue for me but what is happening in your code before that line ?
  15. Re: Runtime error 91 Object Variable or with block variable not set

    I notice that you have now amended the sheet name from SD to SD_Employee_List when populating the combobox
    So the sheet names (for populating and searching) should be consistent
    In which case...
  16. Replies
    18
    Views
    317

    Re: More =IF formula issues

    Thanks for your feedback :beerchug:
  17. Re: Delete all defined named ranges from a selection

    Can you explain further by providing one example

    1. what is the NAME of the named range in cell immediately above Competitor_one
    2. what is the RefersTo formula for that named range



    -
  18. Replies
    9
    Views
    161

    Re: Copy & Paste Cell formats

    so what happens when you simply do this


    rngResult.Copy
    rngTarget.PasteSpecial (xlPasteAll)
  19. Re: Delete all defined named ranges from a selection

    Perhaps I misunderstood what you want the code to do ..

    Your code below selects the ROW above CompOverviewTable starting in cell above header Competitor_one

    ...
  20. Replies
    9
    Views
    161

    Re: Copy & Paste Cell formats

    Is there no other info in the message?
    At a guess it would be PasteSpecial method of Range class failed
  21. Re: Calculating multiple text boxes on a user form

    One method
    - prevent calculation if either textbox is empty

    Use se something like this as first line of TextBox9_Enter

    If Len(TextBox4.Text) = 0 Or Len(TextBox8.Text) = 0 Then Exit Sub
  22. Replies
    9
    Views
    161

    Re: Copy & Paste Cell formats

    try replacing ...

    rngResult.Copy Destination:=rngTarget

    with this ...

    rngResult.Copy
    With rngTarget
    .PasteSpecial (xlPasteFormats)
    .PasteSpecial (xlPasteValues)
  23. Replies
    3
    Views
    109

    Re: Checkbox editing

    thanks for your feedback :beerchug:
  24. Re: Cell recognize positive or negative value then adds certain texts to the 2 possibilities

    :oops::oops: My previous post should have been ...
    =IF(D1=0,"Spot on",IF(D1>0,"Underestimate "&TEXT(D1,"0%"),"overestimate "&TEXT(D1,"0%")))
  25. Re: Cell recognize positive or negative value then adds certain texts to the 2 possibilities

    if you performed the percentage calculation in another cell (D1 in my example) first, then the formula could be simplified

    =IF(D1=0,"Spot on",IF(D1,"Underestimate "&TEXT(D1,"0%"),"overestimate...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4