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