• 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...

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

Search results

  1. A

    Runtime error 424, Object required

    Hi Hui, Oops, that was a typo on my part while posting the code, the actual code is: Private Sub ComboBox1_Change() Dim SubType As String SubType = Range("$D$1").Value Select Case SubType Case "Fruits" ComboBox2.ListFillRange = "Fruits_Range" Case "Vegetables&#34...
  2. A

    Runtime error 424, Object required

    Hello Everyone, I have 2 Activex ComboBoxes on a sheet and I am trying to populate the range in the 2nd combobox based on the value in the first combobox. Here is my code. But whenever I run it, I get the following error: "Runtime error 424, Object required" .. Please Help! Note: Linked...
  3. A

    Speed up / simplify this Excel formula

    Thanks a ton xld! It works like a charm. I never really thought about approaching it this way. I learnt something new today and thank you again for teaching it to me!
  4. A

    Speed up / simplify this Excel formula

    Hello Everyone, So I started writing a formula and ended up with the one below. It looks complex but works. The only issue I am facing is that it is extremely slow and takes forever to calculate. I know this might be due to all the IF statements that I am using, but then other than going in...
Back
Top