Macro to Superscript specific Text with variable numbers
I want to create a macro that change to Superscript in all PowerPoint textboxes the text strings that contains this form: #Numbers
For example:
#1
#12
#123
#1234
All above needs to be superscript including the hashtag.
澳oes anyone knows how can I do it?
thanks
Sample Presentation file attached
Last edited by pacosalasv; 03-30-2022 at 10:20 AM. Reason: Include an attachment
Please attach a sample PPT file where you would want to do this. See yellow banner at the top of the page.
Thanks for reminder, Presentation with two slides attached.Originally Posted by 6StringJazzer
This worked successfully in your test file.
Please Login or Register to view this content.
Thanks! it works fine at sample file, but how can i handle when the text boxes doesn't have #12 i mean, slides without #ID ??? How can i skip and continue with next shape / slide respectively?
It will do that automatically.
I tried the macro in other PowerPoint File and i got this error message:
Run-time error '-2147024809 (80070057)':
The specified value is out of range.
I cant share the file, due copyrights.
Do you know how can i handle this error and continue executing the routine for the rest of the presentation?
What line of code caused the error? I can't fix it unless I can reproduce it. I need to understand what was in the file that caused it, even if you can't give me a copy.
I tried running this in a modified file that had:
Textbox with no ID numbers
Textbox with "#" but no digits
and no error occurred.
I cannot tell you how to handle the error unless I know what is causing it.
Attached you will find a presentation that causes the error message.
Apparently if if there is a superscript already, it fails...
No, that is not the problem. If there is a superscript already, nothing happens.
The problem is that the code loops through all Shapes, because a TextBox is a Shape. However, if there are other types of Shapes present, they may not have text and you can't refer to those properties. That didn't crop up in the first file, but in the second file you have a Picture on Slide 1.
Here is a correction to the code that works on the second file:
Please Login or Register to view this content.
Its amazing, thanks a lot. works so good!!!No, that is not the problem. If there is a superscript already, nothing happens.
The problem is that the code loops through all Shapes, because a TextBox is a Shape. However, if there are other types of Shapes present, they may not have text and you can't refer to those properties. That didn't crop up in the first file, but in the second file you have a Picture on Slide 1.
Here is a correction to the code that works on the second file:
Please Login or Register to view this content.
Just one more question, if i want the # (Hashtag) also to go as superscript. How can i do it?
This revision will also superscript the # sign
Please Login or Register to view this content.
Its simple and magnificent, the best support possible.
Thanks a lot for your excellent support and attention.
You're welcome!
If a member helped you solve your problem, consider adding to their reputation by clicking on the star icon addreputationiconsmall.jpg below their name.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks