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
    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
    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. JUST DAVEG
    Just DaveG Win User
    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. WILLOW1044
    willow1044 Win User

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

  6. KB5032190 Crashes the VBA macro editor in Access 2007d

    in Windows 10 Gaming
    KB5032190 Crashes the VBA macro editor in Access 2007d: After this update KB5032190 when trying to write something in the Microsoft Access 2007 macro editor VBA, the editor crashes.Uninstalling KB50302190 resolves the issue....

  7. KB5032190 Crashes the VBA macro editor in Access 2007d

    in Windows 10 Software and Apps
    KB5032190 Crashes the VBA macro editor in Access 2007d: After this update KB5032190 when trying to write something in the Microsoft Access 2007 macro editor VBA, the editor crashes.Uninstalling KB50302190 resolves the issue....

  8. win 11 office 2016 ACCESS databank with VBA

    in Windows 10 Gaming
    win 11 office 2016 ACCESS databank with VBA: HI I am using Office 2016 with Access and VBA on win 10.I would like to know if my databank will still work with win 11 , as it is works with VBA win 10.I take it that the other componants like word excel aso will work with win 11 ?thank you for your answer.It was a big work...

  9. win 11 office 2016 ACCESS databank with VBA

    in Windows 10 Software and Apps
    win 11 office 2016 ACCESS databank with VBA: HI I am using Office 2016 with Access and VBA on win 10.I would like to know if my databank will still work with win 11 , as it is works with VBA win 10.I take it that the other componants like word excel aso will work with win 11 ?thank you for your answer.It was a big work...

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