code vba

Dear All Master, Please help me with the vba code. What I want in the data sheet to be like in the result sheet, namely in columns A & B. What I want is as follows: 1. I want to pop up a textbox to type the year because in the original data sheet there is no year, so with the pop up textbox I...

Dear All Master, 1. I want the exact formula in the vba code in column B in the sheet "INPUT BOJ" & "INPUT M18" because using an array formula makes it slow because the data to be input is about ten thousand rows. You can see an example of an array formula that I created in column B. So I want...

Dear All Master, The problem I mean is as follows : 1. I want to modify the vba code because it takes too long/very slow to vlookup in VBA code so I want a very fast vba code 2. I want to set from column I2 and J2 in the sheet "GSD" and I mark it in yellow 3. I want vba code which is automatic...

Dear All Master, I want the vba code in the db sheet in the table name which is "DB". I want in the id column I just type and immediately enter or type and immediately tab, copy the value then it will automatically appear in the value in the Name & Job column. This is my link : VBA Worksheet...

Dear All master, I want multi filters. In cell N1, the filter validation by year, cell O1 filter validation by period, cell P1 filter validation by category. So please modify the code vba I have. This is my link : VBA Worksheet Change Event Multi Filter.xlsm file Private Sub...

Not sure if this kind of question is allowed or not, but.. I have been looking at an Excel add-in called "Code VBA" ( Code VBA coding tools ) that looks interesting but have been unable to locate any actual user reviews, comments or meaningful ratings. There is a free demo but have not...