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. Built in Microsoft Keyboard recorder or using VBA with Windows 10

    in Windows 10 Customization
    Built in Microsoft Keyboard recorder or using VBA with Windows 10: I can't find a Macro recorder that is built in to Windows 10. I want to be able to record a macro or write a VBA routine to setup desktop computers to show "This PC" on the desktop, to activate hidden directories, to place all of the MS Office App Icons on the Tool Bar and...
  3. Excel 2010 Document Inspector reports hidden sheets, not shown in VBA

    in Microsoft Office and 365
    Excel 2010 Document Inspector reports hidden sheets, not shown in VBA: I have a worksheet with 14 tabs along the bottom. I've had the worksheet for many years - creation date is 16 November 1997 -and it's evolved over time to be more and more useful. Obviously been through many versions of Excel. It has several user functions and VBA procedures....
  4. Mistakenly removed Microsoft VBA addin for Outlook (O365-Outlook16)

    in Microsoft Office and 365
    Mistakenly removed Microsoft VBA addin for Outlook (O365-Outlook16): I made a dumb mistake. I tried to remove a Bitdefender Antispam addin that is no longer supported, but somehow I removed the VBA addin as well. I was running as an admin. Now I can't run any of my macros, in fact they seem to be gone. Is there a way to reinstall, or otherwise...
  5. Can't open the immediate window in ACCESS VBA

    in Windows 10 BSOD Crashes and Debugging
    Can't open the immediate window in ACCESS VBA: Recently I have been unable to open the immediate window or locals window or watch window when working in Access 365. I'm not sure if this happened after the most recent Windows/Office365 updates, but it is very recent. Any help available? Gordon...
  6. if Vlookup vba in userform

    in Microsoft Office and 365
    if Vlookup vba in userform: Hi again,,, I am fairly new to vba and refer to the dummies guide which I bought recently and I am running windows 10. I have set up a userform in a sheet called START and the first textbox in the userform I want to know the name of a player in my bowling team where the...
  7. VBA Copy Offset

    in Microsoft Office and 365
    VBA Copy Offset: Hi all,, what I am trying here is to copy a range and offset it to the contents of the cell in AH5 but I am geting the Mismatch error, Can you tell me where I am going wrong Please. Range("Ad10:AG17").Copy Range("AH10").Offset(, "AH5") Len 129177
  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...