Threads 1 to 14 of 14

Forum: Familiar with Commands and Formulas

This is an area to describe VBA command or Formula with its syntax

  1. VBA Input Pop up Boxes: Application.InputBox Method versus VBA.InputBox Function

    Started by DocAElstein, 02-03-2018 11:17 PM
    2 Pages •
    1 2
    1 Attachment(s)
    • Replies: 19
    • Views: 293,105
    DocAElstein
    Today, 01:49 PM Go to last post

  2. Right Hand Side Range Range Value values Range=Range.Value only sometimes. Range Range.Value Anomaly

    Started by DocAElstein, 08-14-2023 12:17 PM
    • Replies: 2
    • Views: 3,564
    DocAElstein
    08-14-2023, 12:17 PM Go to last post

  3. Resume On Error GoTo 0 -1 GoTo Error Handling Statements Runtime VBA Err Handling ORNeRe GoRoT N0Nula 1

    Started by DocAElstein, 03-22-2018 11:57 PM
    6 Pages •
    1 2 3 ... 6
    10 Attachment(s)
    • Replies: 51
    • Views: 92,200
    DocAElstein
    10-22-2022, 01:47 PM Go to last post

  4. VBA referring to external shared Libraries, 1) Early, 1.5) Laterly Early and 2) Late Binding Techniques

    Started by DocAElstein, 03-23-2018 12:39 AM
    10 Attachment(s)
    • Replies: 9
    • Views: 76,288
    DocAElstein
    05-13-2021, 02:31 PM Go to last post

  5. Named Ranges and Named Ranges scope. Referencing a named range

    Started by DocAElstein, 11-18-2018 04:30 PM
    2 Pages •
    1 2
    2 Attachment(s)
    • Replies: 10
    • Views: 180,373
    DocAElstein
    11-18-2018, 06:33 PM Go to last post

  6. Built in VBA methods and functions to alter the contents of existing character strings

    Started by DocAElstein, 02-14-2018 03:09 AM
    • Replies: 1
    • Views: 283,939
    DocAElstein
    02-14-2018, 03:09 AM Go to last post

  7. VBA Range.Insert Method: Code line makes a space to put new range in

    Started by DocAElstein, 01-24-2018 08:37 PM
    • Replies: 9
    • Views: 151,219
    DocAElstein
    01-24-2018, 08:54 PM Go to last post

  8. Excel VBA Interception and Implicit Intersection and VLookUp

    Started by DocAElstein, 02-02-2017 09:17 PM
    2 Pages •
    1 2
    • Replies: 12
    • Views: 355,818
    DocAElstein
    03-15-2017, 05:00 AM Go to last post

  9. Understanding VBA Range Object Properties and referring to ranges and spreadsheet cells

    Started by DocAElstein, 01-20-2017 07:25 PM
    • Replies: 3
    • Views: 89,282
    DocAElstein
    01-25-2017, 04:55 AM Go to last post

  10. Lightbulb Difference Between 'On Error GoTo 0' And 'On Error GoTo -1'

    Started by Transformer, 04-09-2013 04:27 PM
    • Replies: 7
    • Views: 33,292
    DocAElstein
    07-02-2015, 04:07 PM Go to last post

  11. Lightbulb Application.Caller

    Started by Transformer, 05-01-2013 12:32 PM
    • Replies: 0
    • Views: 22,465
    Transformer
    05-01-2013, 12:32 PM Go to last post

  12. How To Use Frequency Function In Excel

    Started by Transformer, 04-09-2013 10:40 AM
    • Replies: 1
    • Views: 11,208
    Admin
    04-09-2013, 11:49 AM Go to last post

  13. Val Function

    Started by Transformer, 06-11-2012 10:49 AM
    2 Pages •
    1 2
    function, val, vba
    • Replies: 10
    • Views: 29,711
    mrmmickle1
    09-14-2012, 04:12 PM Go to last post

  14. Number 9.99999999E+307 in Excel Formula

    Started by Admin, 06-11-2012 04:09 PM
    • Replies: 0
    • Views: 16,625
    Admin
    06-11-2012, 04:09 PM Go to last post

Thread Display Options

Use this control to limit the display of threads to those newer than the specified time frame.

Allows you to choose the data by which the thread list will be sorted.

Order threads in...

Note: when sorting by date, 'descending order' will show the newest results first.

Icon Legend

Contains unread posts
Contains unread posts
Contains no unread posts
Contains no unread posts
More than 15 replies or 150 views
Hot thread with unread posts
More than 15 replies or 150 views
Hot thread with no unread posts
Closed Thread
Thread is closed
Thread Contains a Message Written By You
You have posted in this thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules