#1
|
|||
|
|||
VBA Powerpoint slide table data to combobox item
I have combobox and I want to add items from table(it could be as table, or excel SpreadSheet) which is on previous slide.
I found one example for excel(I don't know if will work ir PPT): Sub Loadbox() row_review = 1 Dim TheSheet As ????? Set TheSheet = ????? Do DoEvents row_review = row_review + 1 item_in_review = TheSheet.Range("A" & row_review) If Len(item_inreview) > 0 Then ComboBox1.AddItem (item_in_review) Loop Until item_in_review = ""End Sub But I couldn't understand how to define table from witch I get data for item. Maybe there is better way how to do it? Thanks |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Need macro to fill data from different sheets based on selected item from drop down | skorasika | Excel Programming | 1 | 03-13-2015 11:25 AM |
Pivot table - I cant display item labels when no fields in value area | differentdrummer | Excel | 0 | 12-12-2013 05:13 PM |
powerpoint slide hit counter | breisleach | PowerPoint | 7 | 08-30-2013 12:25 AM |
Create PPT slide presentation with Excel data. Chart is displayed off the slide. | eratem | PowerPoint | 4 | 02-29-2012 09:44 AM |
Powerpoint: adding data to trend lines w/o data labels | HaiLe | PowerPoint | 0 | 04-11-2011 09:21 AM |