Results 1 to 10 of 51

Thread: VBA - Count filtered rows in the table

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #17
    Fuhrer, Vierte Reich DocAElstein's Avatar
    Join Date
    Aug 2014
    Posts
    10,457
    Rep Power
    10
    No. that is a VBA built in Message Box. We can get it with coding like this
    Code:
    MsgBox Prompt:="Alan Big Cock" & vbCr & vbLf & "big VBA man."

    ( the people at Microsoft who made Excel probably used something like a UserForm to make that VBA built in Message Box. The approximately story is that…..
    …… Excel and Word and similar stuff is made from VBA coding: Excel is just a very long VBA code and it makes a lot of forms. Basically we having access to VBA is like being able to manipulate and change that coding.
    For example: When Excel first opens, there is a lot of coding which opens it.
    Because Microsoft lets us, and because I am so incredibly big and clever VBA man, and have a big brain, I can put that coding above into the coding that works when you open Excel.

    So, if/ when you get macros enabled in your Excel, then open the attached file:
    As it opens it will run that coding above, because I have figured out how to put that coding inside the coding that runs when the file is opened )

    Alan Big Cock big VBA man.jpg
    Attached Files Attached Files

Similar Threads

  1. Replies: 101
    Last Post: 06-11-2020, 02:01 PM
  2. Delete Filtered Rows Excluding The Header
    By xander1981 in forum Excel Help
    Replies: 5
    Last Post: 04-01-2014, 11:44 PM
  3. Replies: 1
    Last Post: 07-30-2013, 11:08 PM
  4. Lookup and Count Using Pivot Table
    By RobExcel in forum Excel Help
    Replies: 2
    Last Post: 12-21-2012, 11:08 AM
  5. Unique Count on a Filtered Range
    By Admin in forum Excel and VBA Tips and Tricks
    Replies: 0
    Last Post: 08-14-2011, 04:29 AM

Posting Permissions

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