Windows 10: VBA code

Discus and support VBA code in Windows 10 Customization to solve the problem; I have been working on program in VBA code. I have been able to access with alt F11. Now I am unable to view my code.... Discussion in 'Windows 10 Customization' started by PatsySmith_890, Aug 19, 2018.

  1. VBA code


    I have been working on program in VBA code. I have been able to access with alt F11. Now I am unable to view my code.

    :)
     
    PatsySmith_890, Aug 19, 2018
    #1
  2. BrooksyX Win User

    Help with Excel VBA Problem?

    Can someone help me code the following VBA problem:

    "Assume you have a mailing list file. This file is currently the active workbook, and the active worksheet of this book has full name in coloumn starting in cell A1, with the last name last and everything in uppercase letters (such as STEPHEN E. LEE). Write a sub that counts the number of names in the list with last name LEE and then displays the count in a MsgBox. Not that there might be last names such as KLEE, which should not be counted."

    Thanks!
     
    BrooksyX, Aug 19, 2018
    #2
  3. VBA on windows phones and tablets

    I want to use Powerpoint to prototype an app that I am building. As such I need to customize the PPT file with VBA to do things like have countdown timers, drop down lists, popups etc.

    From my research it appears I need a Surface Pro tablet with full office. Anything else like RT won't do the job.

    However, I can't determine if a Windows phone will support VBA.

    Can anyone confirm if full VBA support is available for Windows phones and tablets? And if so which OS and model.

    Thank you,
     
    willow1044, Aug 19, 2018
    #3
  4. Superfly Win User

    VBA code

    Question about VBA CODE not working good


    I'm no VBA specialist but seems it's a formatting issue - if what you mean by "blanc" is a leading space?
    In normal code Trim remove those, but in VBA I suppose one of the constants does that - maybe try ..

    .PasteSpecial Paste:=xlPasteValues

    Not sure why removing he last char has a different output to the sort function though...
     
    Superfly, Aug 19, 2018
    #4
Thema:

VBA code

Loading...
  1. VBA code - Similar Threads - VBA code

  2. how to get list of sub registry keys in vba?

    in Windows 10 Gaming
    how to get list of sub registry keys in vba?: how to get list of sub registry keys in vba? https://answers.microsoft.com/en-us/windows/forum/all/how-to-get-list-of-sub-registry-keys-in-vba/5b0fed7f-74e2-4f82-891d-feb9227d3409
  3. how to get list of sub registry keys in vba?

    in Windows 10 Software and Apps
    how to get list of sub registry keys in vba?: how to get list of sub registry keys in vba? https://answers.microsoft.com/en-us/windows/forum/all/how-to-get-list-of-sub-registry-keys-in-vba/5b0fed7f-74e2-4f82-891d-feb9227d3409
  4. Having problems with very simple VBA Excel Macros: Command Buttons do not work

    in Windows 10 Software and Apps
    Having problems with very simple VBA Excel Macros: Command Buttons do not work: Hello !!!Could this be the cause of Command Buttons not working in VBA Excel?The machine-default permission settings do not grant Local Activation permission for the COM Server application with CLSID {C2F03A33-21F5-47FA-B4BB-156362A2F239} and APPID...
  5. Task scheduler is running task, but not activating the VBA code in the spreadsheet.

    in Windows 10 Gaming
    Task scheduler is running task, but not activating the VBA code in the spreadsheet.: I have a VBA code in an excel spreadsheet that is written to save data everyday and create a seperate spreadsheet of said data. The task scheduler is used run this program, at a specific time of my choice. Right now, when I run the task, it opens up excel but the actual code...
  6. Task scheduler is running task, but not activating the VBA code in the spreadsheet.

    in Windows 10 Software and Apps
    Task scheduler is running task, but not activating the VBA code in the spreadsheet.: I have a VBA code in an excel spreadsheet that is written to save data everyday and create a seperate spreadsheet of said data. The task scheduler is used run this program, at a specific time of my choice. Right now, when I run the task, it opens up excel but the actual code...
  7. Excel VBA Coding Window Horizontal scrollbar

    in Microsoft Office and 365
    Excel VBA Coding Window Horizontal scrollbar: Hello All, I hope everyone is keeping well and safe!! Within the Excel VBA coding window I am unable to horizontally scroll at all, using either, my laptops touchpad (two finger gesture) or a seperate mouse wheel. It's actility pretty frustrating. I am able to press and...
  8. Version 1809 caused out of memory in VBA code in Outlook

    in Windows 10 Installation and Upgrade
    Version 1809 caused out of memory in VBA code in Outlook: I got problems with some VBA code I use for Outlook, causing out of memory errors. The code got stuck on this row: Set wdDoc = objOpenInspector.WordEditor After going back to previous Windows 10 version 1803 things are working again. Office version (Office 2016 or Office...
  9. VBA Code returns NAME? ERROR

    in Windows 10 BSOD Crashes and Debugging
    VBA Code returns NAME? ERROR: I have tried 3 different VBA codes for counting cells by color and keep getting NAME? https://answers.microsoft.com/en-us/windows/forum/windows_10-performance/vba-code-returns-name-error/14f9bb69-dfed-420a-9781-f4dff490e06e
  10. Question about VBA CODE not working good

    in Windows 10 Software and Apps
    Question about VBA CODE not working good: hi guys, do not know if there are VBA specialists on the board, but I pop the question: since recently when I save a docu automatically, like 199-invoice I get: blanc 199-invoice, instead of the same without the blanc position in front. Sorting the invoice at the...