VBA - Count filtered rows in the table

**sandy666** · 08-23-2023, 11:29 AM

can you define encoding UTF 65001 in VBA ?

if it will be a problem don't worry too much about it

**DocAElstein** · 08-23-2023, 11:36 AM

Originally Posted by sandy666

could you explain what it is for me? What is it needed for?

It looks like an Excel Userform
https://www.excel-easy.com/vba/userform.html

I hardly ever use them. I don’t know so much about them. I never put one in the file FilTit2.xlsm

I have no idea how it got there. I never put it there

I didnt put it there.jpg

As far as I know, you have to put them there. I never saw them come there themselves.
Perhaps with newer Excel they give you one just to fuck you up a bit more.

**DocAElstein** · 08-23-2023, 11:50 AM

Originally Posted by sandy666

can you define encoding UTF 65001 in VBA ?

No I can't define it. I have no idea at all what it is. I never heard of anything like that ever before

How about

Useless Text Fucking format

**sandy666** · 08-23-2023, 11:55 AM

this is very good format

I found new shit from MS like:

it should be OFF
don't be fooled by UTF-8 because it is UTF-65001

**sandy666** · 08-23-2023, 11:59 AM

Originally Posted by DocAElstein

It looks like an Excel Userform
https://www.excel-easy.com/vba/userform.html

I hardly ever use them. I don’t know so much about them. I never put one in the file FilTit2.xlsm

I have no idea how it got there. I never put it there

I didnt put it there.jpg

As far as I know, you have to put them there. I never saw them come there themselves.
Perhaps with newer Excel they give you one just to fuck you up a bit more.

you used it in the first version of vba - first file and forgot to remove it

**DocAElstein** · 08-23-2023, 12:41 PM

Originally Posted by sandy666

you used it in the first version of vba - first file and forgot to remove it

**sandy666** · 08-23-2023, 01:11 PM

maybe this is it

**DocAElstein** · 08-23-2023, 01:47 PM

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

**sandy666** · 08-23-2023, 02:04 PM

it looks like you say that by opening a clean excel xlsm file I can see a lot of some vba code

**DocAElstein** · 08-23-2023, 02:37 PM

No. Microsoft do not let us see all the VBA coding that makes Excel work.
Probably Microsoft do not want us to see it all. If we could see it all, then some people could probably steal all the coding and make their own Excel without Microsoft!

Microsoft only let us see a very very small amount in a clean file.
Mostly they let us have access to codings that do things when events, like opening, or changing things, happen. But they hide, (make invisible), their coding. But we can add our coding in those places.

The main macro I did for you I put in the Microsoft coding that works when you change something in a cell. That is why it works automatically when you change something. Not many people know how to do that. Only people like me with big cock and big brain

The start of the main coding I did for you https://www.excelfox.com/forum/showt...ll=1#post23211 , looks like this:

Code:

Private Sub Worksheet_Change(ByVal Target As Range)
Rem 1 what cell changes don't interest me
 If Target.Cells.Count <> 1 Then Exit Sub '  More than one cell changed, for example by pasiting new range in
 If Target.Row = 1 Then Exit Sub '        '  Row 1 is always header so of no interst for adding data
' If Target.Value = "" Then Exit Sub '     '  If we empty a cell we don't want the macro to do anything

Target is the cell or cells that get changed.
The first few code lines check to see
_ If you changed more than one cell
_ or If you are in the first row.
In those case I exit the macro, since I assume we don’t want to do anything automatically in those cases

The coding called Sub Worksheet_Change(ByVal Target As Range) is always there in a new file and there is already lots of coding in it. But we can’t see it. Microsoft made all their coding invisible.

If you look at that macro in a new file it looks like this to us

Code:

Private Sub Worksheet_Change(ByVal Target As Range)



















End Sub

Microsoft have lots of coding in it, but they make that invisible to us. But they let us put extra coding in it.

Thread: VBA - Count filtered rows in the table

Thread Tools

Search Thread

Display

Similar Threads

VBA Copy Rows From One Workbook To text csv File Based On Count In Different Workbook. Cross Posted Chaos

Delete Filtered Rows Excluding The Header

Creating A Filtered Subset Of A Data Table Using Controls Instead Of Slicers

Lookup and Count Using Pivot Table

Unique Count on a Filtered Range

Bookmarks

Bookmarks

Posting Permissions