View Single Post
 
Old 03-25-2015, 05:05 AM
janism22 janism22 is offline Windows 7 64bit Office 2013
Novice
 
Join Date: Mar 2015
Posts: 3
janism22 is on a distinguished road
Default 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
Reply With Quote