Search:

Type: Posts; User: shoun2502; Keyword(s):

Page 1 of 2 1 2

Search: Search took 0.00 seconds.

  1. Re: Vba code to just find red font color text in powerpoint

    I have written a subroutine as mentioned below but could not get the desired result


    Sub findred()
    Dim aslide As Slide
    Dim ashape As Shape
    For Each aslide In...
  2. Vba code to just find red font color text in powerpoint

    Dear Team,

    I am using the mentioned vba code to find text in font color red in powerpoint . The below mentioned code i was using to find red color font text in ms word.


    Sub newred()
    ...
  3. Re: Vba code to replace with chr(13) with space for selected text in powerpoint

    Thanks Yongle

    Saved a lot of time indeed!
  4. Re: Vba code to replace with chr(13) with space for selected text in powerpoint

    Hi yongle,

    I have used your subroutine with slight modificactions as mentioned below


    Sub ReplaceText()
    Dim Shp As Shape
    On Error Resume Next
    For Each Shp In...
  5. Re: Vba code to replace with chr(13) with space for selected text in powerpoint

    Hi Yongle,

    The code is not working

    Thanks for the reply.
  6. Vba code to replace with chr(13) with space for selected text in powerpoint

    Dear all,

    I am currently working on this code and I need to replace chr(13) with space for the selected text and not for the whole slide. The code below works well with all shapes in active...
  7. Re: Vba code to set the margin of selected text in indent level 2

    Hi I have worked with my First question pertaining to Margin .

    However when I select multiple paragraphs the subroutine doesn't give the results for all paragraphs. Only the code will run on the...
  8. Vba code to set the margin of selected text in indent level 2

    Hi I have the following mention code which sets the indent level for second paragraph . I have two issues with this code.

    1. On selecting more than one paragraphs the indentation will work only...
  9. Vba code to replace, position and remove indentation in powerpoint.

    The code works with the replace , position except with the indentation I am trying to establish


    Before text = 0 cm, Special = None, Alignment = Left"




    I have established the code below
  10. Re: Vba code to replace and position text box in powerpoint

    Hi Yongle

    I am currently using this code to establish . However what I have just discovered that some of the text in text placeholder has some indentation which should be

    Before text = 0 cm...
  11. Re: Vba code to replace and position text box in powerpoint

    Hi Yongle ,

    The mentioned code is not working . It would be grateful if you could please share any other subroutine for that.
  12. Re: Vba code to replace and position text box in powerpoint

    Thanks for the reply. It works very well . Actually in some of my Text placeholder there is some additional spaces that is not being deleted to the left AND right of my TEXT.

    I want my TEXT inside...
  13. Vba code to replace and position text box in PowerPoint

    Dear All,

    The code above replace my font Size and Apart from this I need to align to the below mentioned position . Please help me to incorporate this code


    Sub changeFont()
    For Each aSlide...
  14. Reposted : VBA CODE FOR TABLE FORMATTING

    I need a help with the below mentioned code. As the code runs well . Further I need to incorporate the following points.


    1. Outside border as Color white
    2. In table alternate rows RGB (211...
  15. Replies
    4
    Views
    222

    Re: Vba code for table formatting

    I need a help with the below mentioned code. As the code runs well . Further I need to incorporate the following points.


    1. Outside border as Color white
    2. In table alternate rows RGB (211...
  16. Replies
    4
    Views
    222

    Re: Vba code for table formatting

    https://ibb.co/KqWmFMQ
  17. Replies
    4
    Views
    222

    Re: Vba code for table formatting

    Sorry Sir,

    But the code is not serving my purpose. I need to add-in the outside border of table white and alternate rows having interior color RGB (211,217,222) in my table .

    Keeping the below...
  18. Replies
    4
    Views
    222

    Vba code for table formatting

    Dear Team,




    I need outside border of table white and alternate rows having interior color RGB (211,217,,222)


    Please help with the following vba code.
  19. Re: Auto filter and then auto update advanced filtering in other sheet having dynamic criteria range

    Thanks for the reply.

    But the code is not working.

    Please share your mail id , I ll share my sheet for better understanding.
  20. Re: Auto filter and then auto update advanced filtering in other sheet having dynamic criteria range

    https://www.pastepic.xyz/image/LYk2C :: Untitled 2
    https://www.pastepic.xyz/image/LYh58 :: Untitled 1


    https://www.pastepic.xyz/image/LYk2Chttps://www.pastepic.xyz/image/LYh58
  21. Re: Auto filter and then auto update advanced filtering in other sheet having dynamic criteria range

    https://www.pastepic.xyz/image/LYh58https://www.pastepic.xyz/image/LYk2****itled 1 - The one where I Need to filter out the result in Sheet 2Untitled 2- - Sheet 1 criteria range which is a dynamic...
  22. Auto filter and then auto update advanced filtering in other sheet having dynamic criteria range

    1. I have data in Sheet 1 having 2 columns name Description and Range_T and in Range_T "*" is used for advanced filtering for text.


    2. In sheet 2 I have Range_T which is having different data...
  23. VBA generalise code to create pivot table for selected range into new workbook

    Dear Team,

    Greetings of the day.

    I need to create a pivot table every time for different ranges , for that I need a code to just select the range and create the pivot into another workbook for...
  24. Replies
    14
    Views
    339

    Re: Table formatting VBA CODE

    Thanks for the reply. I do acknowledge your point of view.
    Actually I was trying for the last row as well, so eventually got stuck with that.


    Thanks anyways.
  25. Replies
    14
    Views
    339

    Re: Table formatting VBA CODE

    Similarly, If I have Some data having borders not table Is it possible to execute the code in similar formatting.
    With First,Last row and First Column.

    Please do help me with that.
Results 1 to 25 of 28
Page 1 of 2 1 2