Hello All,
I have powerpoint presentation and each slide has multiple shapes on it. Requirement is to update these shapes with values from excel sheet dynamically.
Not all shapes are to be updated (ex. title, placeholders in footer etc). However, chart data, tables, few textboxes etc are to be updated dynamically depending on range/cell selected by user in excel sheet.
I am trying to loop through all shapes on slide and then by using select case asking user to get dynamic input from user by using application.inputbox("select data ..",type:=8) function.
however, i am not very sure how to update data for charts, tables using dynamic input.
Can someone advise?
I have powerpoint presentation and each slide has multiple shapes on it. Requirement is to update these shapes with values from excel sheet dynamically.
Not all shapes are to be updated (ex. title, placeholders in footer etc). However, chart data, tables, few textboxes etc are to be updated dynamically depending on range/cell selected by user in excel sheet.
I am trying to loop through all shapes on slide and then by using select case asking user to get dynamic input from user by using application.inputbox("select data ..",type:=8) function.
however, i am not very sure how to update data for charts, tables using dynamic input.
Can someone advise?