custom

  1. gmooney

    Excel Custom Lists?

    I just created a custom list in an Excel file that I am using for a Slicer and pivot table filter. I emailed the file to another person and the custom list did not transfer with the file? How can I make sure that the custom list stays in the file?
  2. C

    Text Format

    I have a sheet for user to keyin the data. The format of the data can be 451 / 1903, 0012 / 9908 or 00287 / 0099. The number after the "/" is always 4 digits, it was a data code. The issue was end-user sometimes forgot to put a "space" before and/or after "/". how can i custom the cell format...
  3. R

    custom sort not applying

    I've recorded a custom sort. The sort works exactly how I want, when manually applied (during record process), but fails to apply when applied by executing recorded vba code; by fail, I mean not applying sort and no error messages displayed. After the code has completed, I can visit the "Custom...
  4. F

    Formatting column with custom date format

    I have a worksheet with a column with date and time that I get from our IT showing all incoming and outgoing calls. The date and time column is formated to show Aug 30, 2019 7:15:22PM. I want to change the format to be mm/dd/yy hh:mm. When i highlight the column and go to custom and format the...
  5. M

    What Is A Real World Use Of Creating An Event In a Custom Class?

    Hi, I've been coding in VBA with Excel's built-in events for the Workbook and Worksheet and their usefulness is very obvious. However, with custom classes in VBA you can also create your own events -- and raise them -- to other objects that are listening for those events. What's unclear to me...
  6. M

    Can you save a sort in a Custom View?

    Okay, I've sorted my sheet the want want to view something, and have saved it as a Custom View. When I remove all of the filters, and test the view by selecting it, everything works except for the sort. I'd like for it to sort from smallest (number) to biggest. Is this possible?
  7. L

    Power Query - Custom Column - Reference Previous Cell

    I use a formula in my excel workbook that references the previous cell or cell above in order to calculate inventory based on order count. I have searched far and wide for a way to do this in Power Query in a custom column and have had no luck. Can anyone assist? I would like this in a custom...
  8. A

    HELP! formula for OBIEE

    Hi all, I have tried ( I am very new to this) to write a CASE statement where if the product Family= custom and unit list price =0 return NO but the tricky part is everything else with a list price of 0 needs to be YES else NO. No matter how I write the statement the list price of 0 is...
  9. M

    How to transport Customized Ribbon Linked to Macros to another system

    Hello, I have a VBA module with 50 + macros located inside of personal.xlsb. I have customized an elaborate ribbon that links to all of these macros. I am trying to port this setup into a new workstation. I just made a copy of the personal.xlsb and put it in the xlstart folder of the new...
  10. S

    Adding new Geographical Boundries to Excel Map

    Hi, I would like to add an LGA map on top to create new geographical boundries and names. Eg. an Local Government Area can be a combination of more than one or multiple postcode. I have downloaded the shape files from government websites but I am unable to create custom region maps as per...
  11. A

    Slicer Settings Do Not Show Custom Sort Option

    Hello I made a pivot table add to the data model of the query Connection. There is no use custom list when sort in my slicer setting and I have encountered sorting problems. thank you for any help you might provide
  12. G

    Custom Date format and calculations

    Good Day I am trying to find a way to type and only indicate the number of years and months in one cell. This format must also then be used to calculate and end date for a contract term. I would like to be able to display the cell value as 9 y 11 m or 2 y 3 m etc... This must then be added to...
  13. S

    Searching multiple values in Custom Filter

    Is it possible to search for several matching numbers when running a search from the Filter drop down dialog box or even with the 'Text Filters > Custom Filters' option? I tried putting a comma between each value but it didn't work. Thanks in advance.
  14. L

    Excel convert time to Custom

    Hi No matter how I enter the time in excel, excel will change the format to Custom (h:00:00 am/pm). Why excel does not change the format of the time I entered to "Time" instead of "Custom" ? <tbody> I entered excel convert custom 1:00:00 am 1:00:00 AM h:mm:ss AM/PM 1 am 1:00 AM h:mm...
  15. A

    Looking to make custom Ribbon buttons

    Any really for idiots guide to making custom Ribbon buttons? I'd like one that toggles between "Center Across Selection" on and off. Another that toggles through Plain, Underline, Single Accounting Underline to ideally replace the underline button. Is this possible? I downloaded the...
  16. I

    Custom MsgBox. Buttons

    Evening, I’m looking for a msgbox but with buttons as 1 & 2. Is there a way to do this without it being a userform. Thanks
  17. R

    Custom Number Format

    How do I create a custom number format that always returns 5 digits? Examples: #2 = 00002 #2 2 = 00022 #2 22 = 00222
  18. L

    hiding only +ve numbers

    Hi I have the data below and I want to hide only positive numbers. So I went to Format Cells --> custom and typed ; I thought that would ignored the +ve only since I did not write anything for the positive. I know custom format is like this positive; negative; 0; text so ignoring positive...
  19. S

    Custom Sort with wildcard not working

    I'm trying to make a custom sort based on a contact's management level. Basically sort by their title. So the list would sort something like this: Owner, CEO, President, Vice President, CFO,etc... The list works fine when the title is exactly as in the custom list. But if the title is a...
  20. D

    VBA to insert a custom image

    I have code to insert a set image. Could someone tell me how to alter it so it can insert a custom image please? Sub cmdJakeSig() Dim shp As Shape Set shp = ThisWorkbook.Worksheets("sheet1").Shapes("textbox4") Sheets("Sheet2").Shapes("ImgJ").Copy Sheets("sheet1").Paste...

Some videos you may like

This Week's Hot Topics

Top