• 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 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...
  2. 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...
  3. 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...
  4. 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