mac

  1. G

    "Dialog.box"

    I have generated thousands of lines of software using macro 4.2 in Excel V5. This is business and accounting software and was produced on a G3 Mac. I have transferred it to G4, G5, Power Mac and (the latest) iMac. I have also generated other software in macro 4 which runs successfully on all...
  2. M

    Overflow error, but I can't get it to repeat it

    A couple of months ago, I found some code online to create a delay when running VBA code, called SleepSub. I needed to use it because on Excel for Mac, some labels on my UserForms were not updating on the screen, even when I would use the Repaint method. (I think the labels were changing too...
  3. D

    Chart Axis Issue on Excel in Mac

    I have a line graph in Excel on Mac. The size and location of the labels on the axis change based on the width of the characters included. Wider labels get slightly smaller and move up higher. Smaller labels remain larger and stay on the bottom. These are all the same number of characters...
  4. M

    Problem printing on Excel for Mac 2016/2019/365

    I'm making a workbook for both Windows & Mac. I have a button in my workbook that allows them to PRINT worksheets, and another that allows them to make a PDF of worksheets. Both buttons work perfectly on Windows. On Mac 2016/2019/365, the PDF button works fine. It’s the PRINT button that...
  5. R

    VBA code with cell.Value and SaveAs works in Windows, not Mac, help

    Hi, I've got a piece of code I found online and it works awesome in Excel for Windows. It takes a long list of data and saves out separate files for each unique value in column A. However, when running it on Excel 2019 for Mac, it does not use the unique values in Column A for the file name, but...
  6. T

    Print to PDF Macro for MAC OS

    Hi everyone and thanks for taking a look at my question. I would really appreciate any assistance! I have created a sales quote template for my company. Some of our sales people use Macs and other use PCs. When going to print a quote, it is necessary to select three different tabs. Sometimes...
  7. H

    Data in ten-thousandths of seconds--Looking for best practice

    Looking for best approach to doing various analyses of data, some of which is pretty extreme time measurements--at least extreme compared to what I'm used to working with... Some is in what I'll call ss0.ssss format and some is in hhh:mm:ss.ssss format from a non-Excel source of course. I use...
  8. M

    MAC Question: Microsoft ActiveX Data Objects

    I code almost exclusively for PC, but occasionally have to code for MAC. I often write SQL to query data and I typically use the Microsoft ActiveX Data Objects 6.1 Library. When running such code on the MAC, the user received a Can't find project or library error. This occurred on the line of...
  9. M

    MAC Question: Using [ ] to Specify Range

    I code almost exclusively for PC, but occasionally have to code for MAC. I always use [ and ] to reference ranges (e.g., [MyRange]), but this does not work on a MAC. Does anyone have any idea why, and how to make it work on a MAC?
  10. S

    Excel Mac 2019

    I have an extremely long formula I am trying to modify. I originally wrote it on my work computer on windows excel. To allow me to renunderstand the formula I need the parentheses that match to blink when scrolling through the formula. It does not do this on the Mac excel 2019. Is there a...
  11. N

    Excel 2016 for Mac has forgotten who its parents are? Automation Error '-2147319767 (80028029)'

    Hiya This code works on Excel 2016 for Windows and Excel 2012 for Mac, but stops with the above error on Excel 2016 for Mac. Apparently it does not recognise the property 'Parent' anymore...? Public Function Whole_Row(rngFirst As Range) As Range Dim rngLast As Range Set rngFirst =...
  12. N

    Alternative method needed to transfer data columns quickly between ranges

    Hiya Very quickly, I have gotten into the habit of passing data to and from arrays and then sending the arrays directly to workbook ranges. This has sped up my code considerably. When I have to transfer a series of non-contiguous columns the speed increase is still considerable, but I have...
  13. L

    Pivot table drop down jumbled so I can't filter

    Hi there, I am trying to filter a very long list of data using a drop down in a pivot table. When I click on the drop down, the list comes up in an unreadable jumbled mess. A lot of items on the list are very long so they take up a few lines. This is a new spreadsheet I am working on, but I...
  14. F

    textBox formatting

    Good Day I m trying to capture MAC Addresses on computer onto a user form. When capturing the NAC Address the cell is returning a value of True whereas I want the cell to display the MAC Address. My code is as follows: [CODEws.Cells(iRow, 40).Value = Me.TextBox77.Value =...
  15. K

    EXCEL for MAC: Circular Reference not identified

    Get a message about a circular ref.when opening WM. Can't find the problem cell(s). Error Checking does not identify it; status bar indicates "Circular Reference" on each sheet but doesn't i.d. the cell. Can't find the error by inspection. Ideas? Please note: Excel for Mac (up to date). Thanks...
  16. R

    VBA issue on Mac.

    Hi All, This code was written by someone else who I lost contact with. This macro saves worksheets to PDFs from a list of worksheet names in column A. It then only prints the number of pages in column B per sheet only if there is a yes in column C per sheet. Before it saves, a prompt will ask...
  17. J

    converting VBA macro code from win7 to MAC

    Hello,I have created a excel VBA macro in windows7 operating system to populate PDF.Macro runs fine i win7 but in MAC operating system it gives error: MakePDF error: 53 file not found: shell32.dll VBAproject. Though On Mac it creates a FDF file. The code is.. ' Write FDF file to disk...
  18. S

    Macro to export every worksheet to a separate PDF on a Mac

    For a couple of years, I've been using a macro in Excel on Windows 10 (running in Parallels on my Mac) that will export each worksheet in my workbook to a separate PDF, saving all of them in a Desktop Folder on my Mac called "ExcelPDFReports" . . . here's the code that works perfectly: Sub...
  19. S

    Customize Ribbon on Excel for Mac - Symbol or Icon is Not Available

    I just added a handful of macro buttons to my ribbon (using Excel for Mac) in customizing my ribbon. On the Windows version of Excel, when you create or rename the button being added to the ribbon, a symbol / icon palette appears, allowing you to choose the icon you want to appear above the...
  20. K

    vba for Excel on Mac; screen updating

    Does anyone know how to turn off screen updating in Excel VBA on a Mac? Application.Screenupdating = False doesn't work on a Mac. Thanks.

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top