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. Excel VBA - selecting a cell in different sheet using GoTo and IF statement giving error.

    in Windows 10 Network and Sharing
    Excel VBA - selecting a cell in different sheet using GoTo and IF statement giving error.: Hi all, I am trying to select a cell in different sheet in my code using nested IF and GoTo, however, I am getting Runtime error:1004 Code is as below. I apologise, It might look very amateur : [ATTACH]...
  3. Excel, VBA: What does or what is BeforeDragOver?

    in Windows 10 Software and Apps
    Excel, VBA: What does or what is BeforeDragOver?: I can still imagine something under top or height. [ATTACH] Excel, VBA: Was macht oder was ist BeforeDragOver?
  4. 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...
  5. Excel: Which process in the task manager must be aborted to end an endless loop in VBA?

    in Windows 10 Installation and Upgrade
    Excel: Which process in the task manager must be aborted to end an endless loop in VBA?: I cannot find a process called Excel.exe. Excel: Welchen Prozess im Taskmanager muss man abbrechen, um eine Endlosschleife in VBA zu beenden?
  6. VBA "subscript out of range" error #9

    in Windows 10 BSOD Crashes and Debugging
    VBA "subscript out of range" error #9: Gentlemen: At about 1200 noon Pacific Time, I demonstrated my question to a Microsoft Technician who used Quick Assist to examine my system and to watch the error occur. It is case # 100 516 6344. I have a VBA macro which opens 6 Excel files properly. Moments later the...
  7. VBA Error When Using AutoCad Civil 3D Version 2018

    in Windows 10 Customization
    VBA Error When Using AutoCad Civil 3D Version 2018: I am trying to run AutoCad Civil 3D 2018 version and I keep getting an error that says first: Microsoft Visual Basic for Applications Unexpected error 713 I say okay and the next box that appears says: Microsoft Visual Basic for Applications Class not...
  8. Microsoft Access VBA assistance for Here API

    in AntiVirus, Firewalls and System Security
    Microsoft Access VBA assistance for Here API: For years I used google maps to calculate travel time and distance for sales routes. Using MS Access database table for locations and a little form that a user could select addresses and number a route sequence. However, this data is not freely accessible anymore. I used to...
  9. VBA Basic

    in Windows 10 Network and Sharing
    VBA Basic: VBA basic app has a macro Excel macro that will not edit, run, delete or anything else. An error message is constantly posted. "Invalid Outside Procedure" The app is closing each time I try to view macros from the task ribbon. Upon opening, the app displays the VBA...
  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).