Windows 10: VBA Question

Discus and support VBA Question in Microsoft Office and 365 to solve the problem; Hi all, I am attempting to teach myself VBA in Excel and I am asking is it possible to invoke a macro depending on the contents of a cell? please. Len... Discussion in 'Microsoft Office and 365' started by donnylad, Mar 19, 2019.

  1. donnylad Win User

    VBA Question


    Hi all, I am attempting to teach myself VBA in Excel and I am asking is it possible to invoke a macro depending on the contents of a cell? please.
    Len

    :)
     
    donnylad, Mar 19, 2019
    #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, Mar 19, 2019
    #2
  3. VBA Excel Question

    I'm going through someone elses code in VBA Excel - how do I know that "FIELD 16" is?

    ActiveSheet.Range("$D$2:$R$5000").AutoFilter Field:=16, Criteria1:="="
     
    Just DaveG, Mar 19, 2019
    #3
  4. VBA Question

    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, Mar 19, 2019
    #4
Thema:

VBA Question

Loading...
  1. VBA Question - Similar Threads - VBA Question

  2. 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...
  3. 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...
  4. 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
  5. MS Office Last Update - Excel VBA issue

    in Windows 10 Installation and Upgrade
    MS Office Last Update - Excel VBA issue: Hi all, I have been updated again... now I have serious trouble with my Excel VBA files. If I try to make some modifications in code some actions lead into Excel crash: Select a part of code and trying to del ---> crash Press "Reset" button in editor ---> crash (even...
  6. 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...
  7. Excel 2016 VBA - VBE6EXT.OLB cannot be loaded followed by Out of Memory

    in Windows 10 Software and Apps
    Excel 2016 VBA - VBE6EXT.OLB cannot be loaded followed by Out of Memory: I face the error message when opening VBA in my Excel 2016 64bits. I have tried all the methods available in the internet includes: 1. renaming olb 2. copy paste the file into Program Files without x86 3. Run sfc and DIMC 4. adjust ram memory Please help! Thanks!...
  8. Office VBA + AMSI: Parting the veil on malicious macros

    in Windows 10 News
    Office VBA + AMSI: Parting the veil on malicious macros: As part of our continued efforts to tackle entire classes of threats, Office 365 client applications now integrate with Antimalware Scan Interface (AMSI), enabling antivirus and other security solutions to scan macros and other scripts at runtime to check for malicious...
  9. VBA code

    in Windows 10 Customization
    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. https://answers.microsoft.com/en-us/windows/forum/windows_10-other_settings/vba-code/e9ef2778-957d-4354-8346-458793521d8b
  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...

Users found this page by searching for:

  1. Assume you have a mailing list file. This file is currently the active workbook and the active sheet of this workbook has full names in column A starting in cell A1 with last name last and everything in uppercase letters (such as STEPHEN E. LEE).