VBA-使用用户窗体的PowerPoint演示文稿中的参考标签 [英] VBA - Reference Label in PowerPoint Presentation with UserForm

问题描述

我正在尝试使用VBA用户窗体在PowerPoint演示文稿(将用作文本框)中编辑ActiveX标签.我无法确定如何引用标签，但是可以使用一些指导.我尝试了各种 Presentations("Combined Staff Agenda Template").Slides(0).Shapes("Date_Label").Value = LabelDate， 但我仍然收到错误消息. ActiveX标签位于合并员工议程模板"演示文稿的第一张幻灯片上，并命名为"Date_Label".

I am attempting to use a VBA UserForm to edit an ActiveX label in a PowerPoint Presentation (which will serve as a textbox). I can't determine how to reference the label, however, and could use some direction. I have tried variations of Presentations("Combined Staff Agenda Template").Slides(0).Shapes("Date_Label").Value = LabelDate, but I still receive an error. The ActiveX label is on the first slide of the "Combined Staff Agenda Template" presentation, and is named "Date_Label".

推荐答案

Presentations("Combined Staff Agenda Template").Slides(0) _
                     .Shapes("Date_Label").OLEFormat.Object.Caption = LabelDate

这篇关于VBA-使用用户窗体的PowerPoint演示文稿中的参考标签的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！