1. D

    Windows Opening in Visual Basic Editor

    I have installed several Excel add-ins that I created on my computer. And whenever I open Excel Visual Basic Editor many of the Code Windows that I have closed before exiting the VBA Editor keep popping up each time I open the VBA Editor. It also happens with some of the forms from those...
  2. D

    Open windows explorer to a folder

    Hi, I have this hard wired code to open a folder called Comm. It works perfectly. Shell "explorer.exe ""C:\Users\Pas\Comm\", 1 I have this full folder path recorded in cell A1. Just to make it a bit more flexible, I loaded this value to a string variable and execute the same script to open...
  3. J

    VBA code to change regional settings

    Hi, i need the code for changing regional settings in windows environment: 1. Check what regional settings are used 2. If RS are Windows default (in my case polish -pl) - change to US (United States) 3. If US - change to windows defaults. Cross posted here...
  4. S

    VB to find operating system

    We're moving from Windows 7 Pro to Windows 10 Enterprise. I'd like code in my workbook to work under either environment, meaning I need to determine which environment a user is in and adapt my code accordingly. Thoughts?
  5. J

    Interrupting native functions

    Hi all, I'm trying to change the "automatic" font colour to my company standard colour in Excel 2016. It seems it used to be possible to set this colour in Windows "Personalise" in previous versions of Windows, but Windows 10 works differently and doesn't allow this any more. VBA seems to think...
  6. L


    Hi My computer OS is 64-bit, windows 10. My excel is 365. When I tried =INFO("OSVERSION") I got <tbody> Windows (32-bit) NT 10.00 </tbody> Why is that? thank you very much.
  7. S

    Is there such a thing as an Excel VBA code Checker?

    Is there a software or web-service where you can verify that your macro is running smooth on different version of Excel and also on different platforms? I just wrote a Macro that works on Windows, but on my Mac. However, Excel on on Mac is very unstable all together so I want some third party...
  8. R

    Excel 2016 oversizing once perfectly sized (in Excel 2013) userforms

    Hi, I have a spreadsheet written in Excel 2013 in Windows 7 at 1920x1080 with a userform that fits my screen perfectly (Height = 725, Width = 1161). Recently installed Excel 2016 in Windows 10 and ran the userform and it's quite a bit larger - so much so that information on the bottom of the...
  9. S

    Picture Trucated Error

    I have been using this spreadsheet, which contains various Macros, for at least 5 years using Office 2010 running on Windows 7 64 without issue. Now when I try to run the macros with Office 2010 running Windows 10 64 pro, I am getting an error" The Picture is too large and will be truncated."...
  10. C

    worksheet change macro working in 64-bit windows 10 PC, but not working in another 32-bit windows 7 PC

    I am using the a worksheet change macro to speed up entering totals of different denominations of currencies in around thirty cash counters. The code of the worksheet change macro is as under: '======================================================== Private Sub Worksheet_Change(ByVal Target...
  11. O

    Excel Windows Different 2010 and 365?

    XL 2010 workbook opens with three windows configured (location on screen and size) as they were when the workbook is saved. XL 365 opens with three equally sized windows in the middle of the screen. Tried fiddling with Windows object and indexing but read somewhere that, for example, indexing...
  12. U

    Can we scroll through images and change the aspect ratio in a UserForm?

    I need to be able to select between windows used in home remolding. I have several GIF images that I would like to scroll through and I want to use their file names in the bill of material. I also want to know if there is a way to change the aspect ratio based on the window's dimensions. My...
  13. A

    VBA not running on Office 2016

    Hi, I am wondering if anyone can help me. Today I have upgraded from windows 7 to windows 10 and all the macro enabled worksheets I have previously used have stopped working. It looks like they seem to error around sorting data. I have also noted that when I record a macro and review the code...
  14. W

    Run time error 5 on Excel 2010 but not Excel 2016 (VBA)

    Hi all, I am having some problems with the following VBA code to color some objects and add a screentip. The code works fine on my Excel 2016 (Windows), but it does not work on Excel 2010 (Windows) (It gives Run Time Error 5) However, I need to make sure that this code can work for Excel...
  15. S

    if cell contains two different specific texts then return two different values

    im looking for a formula that returns two seperate values based on two different texts in other columns e.g <tbody> £10 £15 Product Cost Windows 10 Windows & Doors 15 Windows 10 </tbody> I then need to be able to sum the total cost Thanks
  16. B

    Downloaded spreadsheet not opening correctly?

    I've made a workbook in Excel (obviously) on my Mac, saved as a xls document and emailed it as an attachment. When it is opened on a windows pc (Excel 2007) it isn't displaying or functioning correctly even with macros enabled. For example I have in cell drop-down menus which aren't...
  17. N

    Retrieve Windows ReleaseId with vba

    Hello, Is there a way to retrieve the Windows Release Id? Current releasid in my case being 1803, previous was 1709 and now coming up is probably 1810 or possibly 1811. My current version is 17134 but Winver says 17134.345. Any ideas on how to retrieve the last three figures? /nils
  18. N

    Strange Excel Mystery Window - need help fixing this...

    I have a very strange issue going on as follows: If I open a workbook, a "mystery" sheet opens up shortly after I open the workbook. If I close the mystery workbook, it closes the original file I opened up. There are no cells displayed and the ribbon is not displayed in the mystery workbook...
  19. D

    The macro may not be available in this workbook or all macros may be disabled

    Hi, We have a huge problem with running macros in Excel 2010 on Windows 10. In macro settings we marked option "Disable all macros except digitally signed macros". We are using Certificate for Digital Signature and because of that we want to run just digitaly signed macros. I setup all...
  20. R

    Search pdf, xls, doc, csv for keywords and return matching files

    i want to use VBA to search files in Windows 10 for a keyword and return matching documents as a list. Also the windows search facility I always find buggy, but i am not sure why thank you

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...