Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.06 seconds.

  1. Replies
    6
    Views
    1,926

    Re: VBA UI Ribbon Toggle Button

    Hello Worf,

    I am working on something similar.

    Please send me a copy of this workbook.

    The XML code is too small to read.

    Thanks,
  2. Replies
    4
    Views
    122

    Re: Hide 2 buttons when 1 Button is selected

    |?xml version="1.0" encoding="UTF-8" standalone="yes"?>customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui" ******="RibbonControl******">
    |ribbon>
    |tabs>
    |tab...
  3. Replies
    4
    Views
    122

    Re: Hide 2 buttons when 1 Button is selected

    Here is the XML



    |<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
    |<customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui" ******="RibbonControl******">
    | <ribbon>
    | ...
  4. Replies
    4
    Views
    122

    Re: Hide 2 buttons when 1 Button is selected

    '<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
    '<customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui" ******="RibbonControl******">
    ' <ribbon>
    ' <tabs>
    ' <tab...
  5. Replies
    4
    Views
    122

    Re: Hide 2 buttons when 1 Button is selected

    Help!

    How do I clean up the XML code??
  6. Replies
    4
    Views
    122

    Hide 2 buttons when 1 Button is selected

    I have the following XML in a Custom Ribbon I have created


    <?xml version="1.0" encoding="UTF-8" standalone="yes"?>
    <customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui"...
  7. Replies
    1
    Views
    137

    Formula not working

    I have the following line of code:



    'TopLeft.Offset(1, 17).Resize(RowCount, 1).Value = Projectinfo.Range_BidName


    I am trying to get it to see this instead but the code stops.
  8. Replies
    5
    Views
    2,168

    Re: VBA / macro to change filter in pivot table

    I found this code from Domenic while doing a search and it does indeed work!

    Great job Domenic.

    Can anyone help me to modify this code so that it changes the values on 4 different pivot tables...
  9. Replies
    0
    Views
    131

    Add a Slicer to a Ribbon Menu is it possible

    Hello All,

    I have been searching for the last hour and I cannot find anything on how to add a slicer to a Ribbon Menu.

    Is it possible?

    Kurt
  10. Replies
    2
    Views
    1,088

    Happy birthday bill jelen!

    Happy birthday Bill Jelen!!
  11. This code works but I need it to transpose when copying

    I have this code that does indeed work, but it is transposing the data. I have tried to change the x and y coordinates but still no luck.

    Does anyone know how to change this to where the code...
  12. Replies
    10
    Views
    564

    Re: Workbook VERY slow to open

    Have you gone to Data, Edit Links to see if you need all the workbooks that it might be linked to?

    I would save a copy of your workbook try to edit the links that may help your performance issue....
  13. Macro to extract unique instance of multiple values in a column

    Hello All,

    I found this old Mr. Excel post while doing a search:

    https://www.mrexcel.com/forum/excel-questions/986844-vba-extract-unique-values-multiple-columns-one-column.html

    I have...
  14. Replies
    1
    Views
    195

    Remove Part Of A Text String

    I have the following info in cell D5: MECH^CHU-BSW-PF

    Using the following VBA code what do I add to take out the MECH^ part of the text string in cell D5?

    My code needs to stay in this format...
  15. Replies
    4
    Views
    247

    Re: Extracting text using VBA

    We can use cell A1 as an example.
  16. Replies
    4
    Views
    247

    Re: Extracting text using VBA

    I really need to keep using that formula format.

    A MsgBox would not work since there are several thousand rows.

    Thanks for your input.
  17. Replies
    4
    Views
    247

    Extracting text using VBA

    I have made some head and thanks to everyone's help so far.

    I am using the same string of text:'

    MECH~CDA-CUP-PF~1 - CUP0915.2XL - Copper Reducer (P)


    How do I get the CDA-CUP-PF extracted...
  18. Replies
    8
    Views
    241

    Re: Iferror right and find function

    Yes you are correct :-)
  19. Replies
    8
    Views
    241

    Re: Iferror right and find function

    Yes I am now trying to get your formula to work on this line of code:



    AddFormula TopLeft.Offset(1, 3).Resize(RowCount, 1), "=LEFT(AA" & Row & ",FIND(""#"",SUBSTITUTE(AA" & Row & "," -...
  20. Replies
    8
    Views
    241

    Re: Iferror right and find function

    Thanks that does indeed work.

    How can I put that in the following format:



    AddFormula TopLeft.Offset(1, 3).Resize(RowCount, 1), "IFERROR(=LEFT(AA & Row & ", Find("#", Substitute(A1, "-",...
  21. Replies
    8
    Views
    241

    Re: Iferror right and find function

    I am wanting to return this part of the string:

    MECH~CDA-CUP
  22. Replies
    8
    Views
    241

    Iferror right and find function

    I am now trying to recreate my Excel VBA formula on a worksheet to pick it apart.

    I have the following text in cell A1



    MECH~CDA-CUP-PF~1 - CUP0915.2XL - Copper Reducer (P)


    I have the...
  23. Replies
    19
    Views
    523

    Re: Extract characters from a cell using VBA

    The word will change so I don't think I can use that syntax.

    I need to follow this format:



    AddFormula TopLeft.Offset(1, 3).Resize(RowCount, 1), "=IFERROR(MID(AA" & Row &...
  24. Re: Extract characters from a Cell using a VBA Formula

    Thank you for your efforts but I need to stay with the format I am using.

    That will not work for my present needs. Too many lines of code also, but thank you for your efforts.
  25. Replies
    19
    Views
    523

    Re: Extract characters from a cell using VBA

    So would it be something like this:



    AddFormula TopLeft.Offset(1, 2).Resize(RowCount, 1), "=IFERROR(=extractword(A1,2,""~"")


    or something else based on this example of code
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4