Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.09 seconds.

  1. Replies
    1
    Views
    80

    Re: Rearrange column headers using listbox

    Here is a method to move items up and down in userform listbox

    To test ...
    - create a NEW userform
    - add a Listbox (ListBox1)
    - add a SpinButton (SpinButton1)
    - paste code below into UserForm...
  2. Re: Average groups of numbers within a larger group

    perhaps ...

    Excel 2016 (Windows) 32 bit

    A
    B
    C

    1Numbers ResultFormula in A2 copied down the whole column
  3. Re: Setting Userform textbox value from Worksheet_Change

    You could use a Public Boolean variable that is TRUE when form is loaded and FALSE when it isn't

    Declare at TOP of a MODULE before all subs (in Module1, Module2 etc)

    Option Explicit

    Public...
  4. Replies
    1
    Views
    84

    Re: Combobox Text behaviour

    What is a UDF combobox?
  5. Replies
    1
    Views
    74

    Re: Add blank rows to table

    How is the incorrect number of rows causing a problem with the Helper table ?
    Is the table a structured table (created with INSERT \ TABLE) ?
  6. Replies
    9
    Views
    250

    Re: Sorting Code (alphabetize) stopped working

    Glad that helped :beerchug:


    You do - but on another thread please
  7. Replies
    5
    Views
    158

    Re: File save as location

    I think this answers both your questions
    http://codevba.com/excel/workbook_saveas.htm#.Xam5mmZ7nIU
  8. 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...
  9. Replies
    4
    Views
    89

    Re: Excel VB Textobxes Characters

    glad it helped
    thanks for the feedback
    :beerchug:
  10. Replies
    9
    Views
    250

    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 =...
  11. Replies
    9
    Views
    250

    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...
  12. Replies
    9
    Views
    250

    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...
  13. Re: Delete all defined named ranges from a selection

    been busy - will look at this for you tomorrow
  14. Replies
    4
    Views
    89

    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...
  15. Re: VBA Hide unhide depend on Cell Value where rows are same for different cell value.

    thanks for your feedback :beerchug:
  16. 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)
  17. 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)

    ...
  18. 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...
  19. Replies
    9
    Views
    250

    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 ?
  20. 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...
  21. Replies
    18
    Views
    322

    Re: More =IF formula issues

    Thanks for your feedback :beerchug:
  22. 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



    -
  23. Replies
    9
    Views
    164

    Re: Copy & Paste Cell formats

    so what happens when you simply do this


    rngResult.Copy
    rngTarget.PasteSpecial (xlPasteAll)
  24. 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

    ...
  25. Replies
    9
    Views
    164

    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
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4