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

    VBA Overflow Workaround

    I recently just be able to get my code working, so just want to post what I've change so if others are reading my initial post, they would know what changed and if it worked.
  2. E

    VBA selecting a table and chart from excel to PPT

    Hir SirJB7, This is a different vba code that i am working than my previous one, so I thought it will be good practice to start a new thread. I have also checked the Chandoo forumn that you mentioned above. It's slightly different and I was hoping to get some help. Thanks for replying...
  3. E

    VBA Overflow Workaround

    Thank you SirJB7 and Hui for your help. I was able to get my code working after I change all of my variables to Double. Sorry for the late reply.
  4. E

    VBA selecting a table and chart from excel to PPT

    Hi, I am wondering if anyone would be able to help with copying a workbook of excel tables and charts into PPT? I was able to get the code to work to copy the table (range D3 to V21) into ppt, however, when I added in the following code I got a Compile error (invalid Next control variable...
  5. E

    VBA Overflow Workaround

    Hi there, I have a macro that will transpose data from the 'test' tab to the 'result' tab. Data in the 'test' tab are numbers -1000 to 1000 with 5 decimal places. The macro will take the table format in 'test' tab and tranpose into column format that used to be import into databases. This...
  6. E

    Compile Error - ComboBox

    Thank you Deb! I changed my "drop down list" from userform to activecontrol, and now it is working.
  7. E

    Compile Error - ComboBox

    ahh..I see where the NameBox is and it is "Drop Down 1". When I try to replace ComboBox1 with Sheet1."Drop Down 1", I see get the same error. I have tried using: 1. Sheet1.Drop Down 1 2. Sheet1."Drop Down 1" Both still get the same compile error. Do you know why?
  8. E

    Compile Error - ComboBox

    I tried right clicking on the combo box, but I cannot find the NameBox? I only see "Cut, Copy, Past, Group, Order, Assign Macro, Format Control". Can you point me to the right direction?
  9. E

    Compile Error - ComboBox

    Hello, I am trying to write a simple add item query to a combo box. Below is my code: With Sheet1.ComboBox1 .AddItem "Paris" But I keep getting a Compile error: Method or data member not found. I suspect it's something wrong with the ComboBox1 "code function". Usually when I start...
  10. E

    Export Excel tab to PDF and PPT

    Hi Deb, Thank you for showing me how to post a sample file, below is a link of my sample model. https://www.dropbox.com/s/n4k3dgn5lohk9pr/model%20sample.xlsx What I am trying to accomplish: 1. Pick a region from the combo box on the Title page tab 2. This will automatically update the...
  11. E

    Export Excel tab to PDF and PPT

    Hello, I have a model that display regional forecasting information on one summary tab. In the first tab of this model, I created a combox box to allow user to pick which region (from a list of 50 regions) they want to view, then on the summary tab, they would see a chart and a summary table...
Back
Top