Use an ActiveX control text box as the input for a graph on a different slide

Hello VBA Forum,

I am once again asking for your help. I am new to VBA but need to use it for a very important project at work. We want to be able to insert a value during presentation mode into an ActiveX Control Text Box, run a macro and then have that value update a graph on a later slide.

I have attached images of both slides...On the first screen shot, where it says "Target State Score" is where the ActiveX text box will be. We want this value to automatically update the move the position of the "you are here" bubble on the bubble chart. Since the chart values are stored in excel, I am not sure if there is a way to do this. I have not been able to find any information online, so any help or ideas that you have are greatly appreciated.


Thanks in advanced.

Best,

Micah D.Attachment 27431Attachment 27432