textframe

Lets see if I can even describe this correctly... I have a userform that uses option buttons to help place certain shapes and then assign text to/around those shapes. Part of the userform is in the image below and an example of what I'm trying to do in the other image. My question is around...

I can't quite figure out how to fix the following issue. Background: I made a userform to assist me in making timelines of various workstreams. Essentially it uses adds a shape of a certain length (duration) and some text to fill it in. Code snip that does that... If TaskCheck = True Then...

I was using the statement Sheets("GEN").Shapes("Rounded Rectangle 5").TextFrame.Characters.Text = "NOLOG" to change the text of a Rounded Rectangle on a worksheet. After coding, I was able to click the rectangle and cycle through various values (it toggles from NOLOG to TERSE to FULL and...

Hi all, I am writing a workflow program for my work. It essentially creates a rounded rectangle auto shape for each new ticket. It then populates the text of the ticket with the ticket number and summary text. This was working fine on several machines including my own (all running Office...

I am having a hard time figuring how to change the color of all the different text groups in a chart, header, axis, labels etc, and even the macro recorder has failed me this time - I have recorded the following, where I selected the graph, changed textcolor to white and then ended the recording...