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
|