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. PATSYSMITH_890
    PatsySmith_890 Win User

    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
    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. WILLOW1044
    willow1044 Win User
    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
    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. I can't get the scheduler to run an excel file with vba code that creates a report and...

    in Windows 10 Gaming
    I can't get the scheduler to run an excel file with vba code that creates a report and...: Hi,I have built vba code in an excel file that creates a report file and emails it to some recipients. I am trying to get the scheduler in windows 10 to run this but no matter how I do it it does not run when I am not logged in. I have now also tried in windows 11 and there...

  3. I can't get the scheduler to run an excel file with vba code that creates a report and...

    in Windows 10 Software and Apps
    I can't get the scheduler to run an excel file with vba code that creates a report and...: Hi,I have built vba code in an excel file that creates a report file and emails it to some recipients. I am trying to get the scheduler in windows 10 to run this but no matter how I do it it does not run when I am not logged in. I have now also tried in windows 11 and there...

  4. Can i edit vba code with windows tablet?

    in Windows 10 Gaming
    Can i edit vba code with windows tablet?: Can i edit vba code with windows tablet? https://answers.microsoft.com/en-us/windows/forum/all/can-i-edit-vba-code-with-windows-tablet/99f3a348-c077-4ca6-9a9c-fa480f7ebc29

  5. Can i edit vba code with windows tablet?

    in Windows 10 Software and Apps
    Can i edit vba code with windows tablet?: Can i edit vba code with windows tablet? https://answers.microsoft.com/en-us/windows/forum/all/can-i-edit-vba-code-with-windows-tablet/99f3a348-c077-4ca6-9a9c-fa480f7ebc29

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

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

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

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

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