1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

    Yours,
    Chandoo
  2. Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  3. When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Recent Activity

Activity stream for all registered members at Chandoo.org Excel Forums - Become Awesome in Excel.

  1. Rediska replied to the thread Count Unique values from a list with conditional filter from another list.

    Thanks a lot NARAYANK991, it works perfectly! Of course my syntax was wrong, plus second filter was pointed to a wrong column, Thanks a...

    Oct 17, 2017 at 3:41 PM
  2. Octofez2 replied to the thread Average Formula With Variables.

    Chihiro, Just a followup. It's perfect. Thanks again.

    Oct 17, 2017 at 3:35 PM
  3. NARAYANK991 replied to the thread Count Unique values from a list with conditional filter from another list.

    Hi , Does this not work ?...

    Oct 17, 2017 at 3:33 PM
  4. Belleke replied to the thread Percentage in userform listbox and combobox.

    Hi Narayan, I found a solution, so the problem is solved. this is the code With LB_02 .List = [Lijst].Value .ColumnCount =...

    Oct 17, 2017 at 3:25 PM
  5. Rediska attached a file to the thread Count Unique values from a list with conditional filter from another list.

    Thanks a lot John, it works perfectly now!!! Sorry, but.... another question: how can I add additional filter from another column based on...

    Oct 17, 2017 at 3:16 PM
  6. claudia80 replied to the thread hyperlink and other.

    I just started the macro with the new instructions. I would like to ask you something. I noticed that while the macro is working on the...

    Oct 17, 2017 at 3:16 PM
  7. NARAYANK991 replied to the thread Percentage in userform listbox and combobox.

    Hi , Can you upload your workbook with the listbox and the data in it ? Narayan

    Oct 17, 2017 at 3:08 PM
  8. Belleke replied to the thread Percentage in userform listbox and combobox.

    Hi Narayank, thank you for your response:) I will give your code a try, i found a solution tha works for me in the combobox. Private Sub...

    Oct 17, 2017 at 2:55 PM
  9. NARAYANK991 replied to the thread Percentage in userform listbox and combobox.

    Hi , Insert a macro like this : Private Sub ComboBox1_Change() ComboBox1.Text =...

    Oct 17, 2017 at 2:51 PM
  10. shrivallabha replied to the thread hyperlink and other.

    Yes. Replace complete routine "cmdUpdateCapital_Click" in the code by below one. Private Sub cmdUpdateCapital_Click() Dim rng As Range,...

    Oct 17, 2017 at 2:42 PM
  11. Belleke posted a new thread.

    Percentage in userform listbox and combobox

    Hello everybody. I have a table in a sheet with percentages 10% 20% 30% .... 100% (simple) But when i fill a combobox and a listbox it...

    Forum: VBA Macros

    Oct 17, 2017 at 2:40 PM
  12. Ashok Pai replied to the thread Shortcut to copy cell values.

    Hi, Use Alt+E+I+L to copy left. Regards, Ashok

    Oct 17, 2017 at 2:18 PM
  13. John Jairo V replied to the thread Count Unique values from a list with conditional filter from another list.

    Hi again, @Rediska! The formula must be:...

    Oct 17, 2017 at 2:14 PM
  14. Octofez2 replied to the thread Average Formula With Variables.

    Thank you very much. I like it and it may do the trick. It's a lot simpler than I anticipated. I'll play around with the code.

    Oct 17, 2017 at 2:13 PM
  15. Chihiro replied to the thread Average Formula With Variables.

    If it's always going to be all sheets from first listed sheet to last listed sheet... You can do something like... Sub Get_Average() Dim...

    Oct 17, 2017 at 2:02 PM
Loading...