Ebooks Amazon Free

FREE ALL EBOOKS ON AMAZON AND COURSES ON UDEMY- What books and courses do you need? We have them FREE for you...

Showing posts with label Code VBA. Show all posts
Showing posts with label Code VBA. Show all posts

27 July, 2020

[Free ebook]Ready to Use 101 Powerful Excel VBA Code Just Copy - Paste - Run (For Functional Users) by Anil Nahar

[Free ebook]Ready to Use 101 Powerful Excel VBA Code Just Copy - Paste - Run (For Functional Users) by Anil Nahar


How to Earn 1000$ Per Month & Make your own project in excel thi books help you so much.Please read also my other published book "Ready to Use Amazing Custom function in excel".

This book is to provide basic guideline for people interested in Excel VBA programming. Collection of ready code has been used on reality platform by technical and non technical users on their routine work in corporate and not corporate world. Collection of VBA Code just paste in VBA Editor and Run Macro , no need require any technical coding language. It become smarter in excel with increase desk productivity work 10X.It just publishing for helping to easy work in excel on demand of users.

Example of Ready code :
* Convert One Cell To Multiple Rows
* Convert Text To Column
* Highlight Specific Text
* Indexing All Worksheet Name In Of Active Workbook
* Password Breaker Worksheet If you forgot
* Password Unprotected Workbook
* Unhide All Hidden Worksheets
* Image Conversion Of Selection Area
* Highlight Color Of Duplicate Value
* Data Entry Form Of Activate Sheet
Year:
2020
Language:
english
Pages:
137
File:
PDF, 210 KB
#evba #etipfree #eama #kingexcel
📤How to Download ebooks: https://www.evba.info/2020/02/instructions-for-downloading-documents.html?m=1

19 July, 2020

[Free Ebook]30+ Code Macro VBA 2020 PDF FULL

[Free Ebook]30+ Code Macro VBA 2020 PDF FULL
Read online bellow





Using the Code from Excel Macro Examples
How to Run a Macro
Excel Macro Examples
1. Unhide All Worksheets at One Go
2. Hide All Worksheets Except the Active Sheet
3. Sort Worksheets Alphabetically Using VBA
4. Protect All Worksheets At One Go
5. Unprotect All Worksheets At One Go
6. Unhide All Rows and Columns
7. Unmerge All Merged Cells
8. Save Workbook With TimeStamp in Its Name
9. Save Each Worksheet as a Separate PDF
10. Save Each Worksheet as a Separate PDF
11. Convert All Formulas into Values
12. Protect/Lock Cells with Formulas
13. Protect All Worksheets in the Workbook
14. Insert A Row After Every Other Row in the Selection
15. Automatically Insert Date & Timestamp in the Adjacent Cell
16. Highlight Alternate Rows in the Selection
17. Highlight Cells with Misspelled Words
18. Refresh All Pivot Tables in the Workbook
19. Change the Letter Case of Selected Cells to Upper Case
20. Highlight All Cells With Comments
21. Highlight Blank Cell in the Selected Dataset
22. Sort Data by Single Column
23. Sort Data by Multiple Columns
24. How to Get Only the Numeric Part from a String
25. Always Open Workbook with Specific Tab Activated
26. Save and Close All Workbooks at Once
27. Limit Cursor Movement in a Specific Area
28. Copy Filtered Data into a New Workbook
29. Convert All Formula into Values in Selected Dataset
30. Get Multiple Lookup Values in a Single Cell
#evba #etipfree #eama #kingexcel
📤How to Download ebooks: https://www.evba.info/2020/02/instructions-for-downloading-documents.html?m=1

17 July, 2020

[Free Ebook] 101 Excel Powerful Microsoft Excel VBA Code 2020

[Free Ebook] 101 Excel Powerful Microsoft Excel VBA Code 2020
 DOWNLOAD
Read online bellow⏬






How to Insert VBA code to Excel Workbook
This is a brief step-by-step guideline for beginners showing how to add VBA
code (Visual Basic
for Applications code) to your Excel workbook and run this macro to solve
your spreadsheet
tasks.
This step-by-step guide to be able to use the code you found in this E-Book
:
1. Open your workbook in Excel.
2. Press Alt+F11 to open Visual Basic Editor (VBE).
3. Click on your workbook name in the "Project-VBAProject" pane (at the top
left
corner of the editor window) and select Insert -> Module from the context
menu.
4. Copy the VBA code and paste it to the right pane of the VBA editor
("Module1"
window).
Then add the following lines to get your macro to work faster.
To the very beginning of the code, after all code lines that start with Dim
(if there are no
"Dim" lines, then add them right after the Sub line):
Application.ScreenUpdating = False
Application.DisplayAlerts = False
Application.Calculation = xlCalculationManual
To the very of the code, before End Sub:
Application.ScreenUpdating = True
Application.DisplayAlerts = True
Application.Calculation = xlCalculationAutomatic
These lines, as their names suggest, turn off screen refresh and
recalculating the workbook's
formulas before running the macro.
After the code is executed, everything is turned back on. As a result, the
performance is
increased from 10% to 500% (aha, the macro works 5 times faster if it
continuously
manipulates the cells' contents).
Save your workbook as "Excel macro-enabled workbook". Press Ctrl+S, then
click the "No"
button in the "The following features cannot be saved in macro-free
workbook" warning
dialog.
#evba #etipfree #eama #kingexcel
📤How to Download ebooks: https://www.evba.info/2020/02/instructions-for-downloading-documents.html?m=1

14 July, 2020

[Free Ebook]1000+ Code Excel Visual Basic Macro Examples VBA 2020

[Free Ebook]1000+ Code Excel Visual Basic Macro Examples VBA 2020
Read online bellow


The examples and information in these books are for illustration only, without warranty
either expressed or implied, including, but not limited to, the implied warranties of
merchantability and/or fitness for a particular purpose.
The easiest way to search for a subject is to click on the Search tab and type in key words
in lower case. Then choose a topic to display. To turn search highlighting off:
· Click on Options
· Click the menu item "Search Highlighting Off
If on, then when you do a search and click on a topic, all matching words are
highlighted. If you change the setting, you will need to display a different topic and then
click back on the original topic to see the change.
To copy an example:
· Highlight the code you want to copy
· Right click and select "Copy"
· Or, press CTLC
Topics can be stored in a favorites list for quick access. First display the topic if it is not
already displayed. Then click on the Favorites tab and click the "Add" button
#evba #etipfree #eama #kingexcel
📤How to Download ebooks: https://www.evba.info/2020/02/instructions-for-downloading-documents.html?m=1

26 April, 2020

Difference between Worksheets and Sheets in VBA

Difference between Worksheets and Sheets in VBA

In VBA, you have two collections that can be a bit confusing at times.
In a workbook, you can have worksheets and as well as chart sheets. The example below has three worksheets and one chart sheet.
Worksheets Object in Excel VBA - 1 Chart sheet

24 April, 2020

Pick Names At Random From A List – Excel VBA

Pick Names At Random From A List – Excel VBA

In this blog post we will explore how to pick names at random from a list using Excel VBA.
Suppose we were picking the names for a draw or competition and needed to generate a list of maybe 3, 5 or any number of names from a list.
These names must be selected at random and be unique. You cannot select the same name more than once.
The macro code shown below can be copied and pasted into a VBA module and adapted for your use. Comments have been used to identify the key and more complex parts of the macro.
This macro uses an array variable to store the names being randomly selected from the list. Every time a name is selected, it is checked against this array to ensure that it has not already been selected. If it has, then another name is randomly selected.This macro demonstrates some key VBA techniques including a Do While and a For Next loop. It also uses variables including a string array and an If statement.

Macro to Pick Names at Random from a List

Sub PickNamesAtRandom()

Dim HowMany As Integer
Dim NoOfNames As Long
Dim RandomNumber As Integer
Dim Names() As String 'Array to store randomly selected names
Dim i As Byte
Dim CellsOut As Long 'Variable to be used when entering names onto worksheet
Dim ArI As Byte 'Variable to increment through array indexes

Application.ScreenUpdating = False

HowMany = Range("D3").Value
CellsOut = 6

ReDim Names(1 To HowMany) 'Set the array size to how many names required
NoOfNames = Application.CountA(Range("A:A")) - 1 ' Find how many names in the list
i = 1

Do While i <= HowMany
RandomNo:
    RandomNumber = Application.RandBetween(2, NoOfNames + 1)
    'Check to see if the name has already been picked
    For ArI = LBound(Names) To UBound(Names)
        If Names(ArI) = Cells(RandomNumber, 1).Value Then
            GoTo RandomNo
        End If
    Next ArI
    Names(i) = Cells(RandomNumber, 1).Value ' Assign random name to the array
    i = i + 1
Loop

'Loop through the array and enter names onto the worksheet
For ArI = LBound(Names) To UBound(Names)

    Cells(CellsOut, 4) = Names(ArI)
    CellsOut = CellsOut + 1

Next ArI

Application.ScreenUpdating = True

End Sub

Watch the Video




#evba #etipfree #eama #kingexcel
📤How to Download ebooks: https://www.evba.info/2020/02/instructions-for-downloading-documents.html?m=1

23 April, 2020

[Free PDF ebook]Top 100 Excel power bundle userful macro codes - update 2020

15 April, 2020

[Free ebook]Ready to Use 101 Powerful Excel VBA Code 2020 (For Functional Users) by Anil Nahar

[Free ebook]Ready to Use 101 Powerful Excel VBA Code 2020 (For Functional Users) by Anil Nahar


DOWNLOAD PDF
DOWNLOAD EPUB

How to Earn 1000$ Per Month & Make your own project in excel thi books help you so much.Please read also my other published book "Ready to Use Amazing Custom function in excel".

This book is to provide basic guideline for people interested in Excel VBA programming. Collection of ready code has been used on reality platform by technical and non technical users on their routine work in corporate and not corporate world. Collection of VBA Code just paste in VBA Editor and Run Macro , no need require any technical coding language. It become smarter in excel with increase desk productivity work 10X.It just publishing for helping to easy work in excel on demand of users.

Example of Ready code :
* Convert One Cell To Multiple Rows
* Convert Text To Column
* Highlight Specific Text
* Indexing All Worksheet Name In Of Active Workbook
* Password Breaker Worksheet If you forgot
* Password Unprotected Workbook
* Unhide All Hidden Worksheets
* Image Conversion Of Selection Area
* Highlight Color Of Duplicate Value
* Data Entry Form Of Activate Sheet
Year:
2017
Language:
english
Pages:
137
File:
EPUB, 210 KB
#evba #etipfree #eama #kingexcel
📤How to Download ebooks: https://www.evba.info/2020/02/instructions-for-downloading-documents.html?m=1

14 April, 2020

Free ebook] The Best Codes Macro VBA 2020 on EVBA.info

[Free ebook] The Best Codes Macro VBA 2020 on EVBA.info

DOWNLOAD

Using the Code from Excel Macro Examples Here are the steps you need to
follow to use the code from any of the examples:
. Open the Workbook in which you want to use the macro.
. Hold the ALT key and press F11. This opens the VB Editor.
. Right-click on any of the objects in the project explorer.
. Go to Insert --> Module.
. Copy and Paste the code in the Module Code Window. In case the example
says that you need to paste the code in the worksheet code window, double
click on the worksheet object and copy paste the code in the code window.
Once you have inserted the code in a workbook, you need to save it with a
.XLSM or .XLS extension.
#evba #etipfree #eama #kingexcel
📤How to Download ebooks: https://www.evba.info/2020/02/instructions-for-downloading-documents.html?m=1

07 April, 2020

[Free Ebook PDF]1000+ CODE VBA MACRO FOR EXCEL EXAMPLE

[Free Ebook PDF]1000+ CODE VBA MACRO FOR EXCEL EXAMPLE

DOWNLOAD

The examples and information in these books are for illustration only,
without warranty
either expressed or implied, including, but not limited to, the implied
warranties of
merchantability and/or fitness for a particular purpose.

17 March, 2020

[Free ebook Download]Excel - 51 Awesome Macros: Save time and be more productive by Philippe A. Louis

[Free ebook Download]Excel - 51 Awesome Macros: Save time and be more productive by Philippe A. Louis


DOWNLOAD PDF
DOWNLOAD AZW3

Description

In order to take your productivity to the next level, you need to apply the power of Excel Macros. Inside this book, you'll get all information you need to save time and explore new functionalities in Excel with ready-to-use VBA Codes.

Inside the book:
- Provides an explanation of how implement macros
- Send a full email model with attachment with a single click of mouse
- Automatically creates PowerPoint presentation
- Save the same file in multiple directories
- Automatically adjust chart Labels
- Macros to protect the Spreadsheet with login and password
- Control the users who access the spreadsheet.
- And much more…
#evba #etipfree #eama #kingexcel



📤How to Download ebooks: https://www.evba.info/2020/02/instructions-for-downloading-documents.html?m=1

12 February, 2020

[Free ebook]100+ Code Excel Powerful Microsoft Excel VBA Code 2020 on EVBA.info

08 February, 2020

[Free ebook]Advance Excel Formula (For all users) Ready to use Customize Function-Anil Nahar

[Free ebook]Advance Excel Formula (For all users) Ready to use Customize Function-Anil Nahar


DOWNLOAD PDF
DOWNLOAD EPUB

Author of "Ready to Use 101 Powerful Excel VBA Code" Successfully like by millions of users , Now going ahead to develop Custom Excel Function.
Excel having large collection of functions in-built . Mostly those functions are sufficient to complete the work. Sometimes, Excel doesn't have a pre-built function that suits a specific need, Well not to worry about it , you can create your own function called User Defined Function or custom Excel function with help of Visual Basic for Applications (VBA). You can access a User Defined Function any time just like any other Excel function.
But the main problem is you should have good knowledge of Excel VBA Programming and need so much time to writing code as desire.
This book helps you to use ready code by just copy paste and enjoy the work.
Benefits of this books :
Available readymade function which is very unique and rare.
Create new formula in easy way instead of using long formula
Without any technical knowledge use the new function
Impress your boss with fast working
#evba #etipfree #kingexcel

📤You download App EVBA.info installed directly on the latest phone here : https://www.evba.info/p/app-evbainfo-setting-for-your-phone.html?m=1

07 February, 2020

Free Code VBA the Office programming power solution

02 February, 2020

[FREE Invoice Generator Template] Save Excel Invoice as PDF

[FREE Invoice Generator Template] Save Excel Invoice as PDF

I recently had to get myself registered under Goods and Services Tax (GST) so that I can file for GST on my earnings.
Once you have a GST number, you need to file your tax return every month (in India).
So every month, my Charted Accountant would reach out to me asking for sales invoices so that he can file for the GST.
In my case, there only a handful of invoices to be created, as I have only a few sources of income.
However, since this is additional work, I wanted to get this done as quickly as possible.
So to minimize my effort, I created an Invoice Generator template in Excel that allows me to have all the data in one place, and then it automatically creates PDF invoices for all the data points.
As you can see below, all I need to do is double-click on the client’s name (in column B), and it would instantly create and save the invoice in the PDF format in the specified folder.
Creating Invoice Generator Template in Excel
You can also modify the invoice template to suit your company’s format (which would require you to change the VBA code a little – explained below).
It creates an invoice as shown below:
GST Invoice format in PDF
This Tutorial Covers:


How does this Invoice Generator Template Works?

In this invoice template, there are two worksheets:
  1. Details – This is where you need to specify the details of the sale/transaction. To keep everything together, I have created one row for each record. All the details of a transaction are recorded in the row.
  2. Invoice Template – This is a placeholder template of the invoice where some fields are left empty.  I need to generate a separate invoice for all the sale records and the details for each invoice is picked up from the Details worksheet.
I also have a folder on my desktop with the name ‘Invoice PDFs’. This is the folder where the newly created PDF invoices are saved.
Now let’s see how this works:
You need to double-click on the client’s name (highlighted in orange in the Details sheet).
That’s it!
When you double-click on the client name, it kickstarts the VBA magic in the back end and the following things happen:
  1. Details for the client and the sale transaction are picked up and the invoice template sheet is populated with these details.
  2. A new workbook is created that has the details of the selected client (on which you double-clicked).
  3. This workbook is saved as a PDF in the Invoice PDF folder.
  4. The new workbook is closed without saving.
In case there are any changes in the invoice details, you can double-click on the client name again, and a new invoice will be created (and this will overwrite the old one).
Note that the names of the invoices are based on the month and the invoice number.
For example, an invoice with the date 15-04-2019 and the invoice number as 1 would be saved with the name  April 2019_1.pdf. This helps in keeping track of the invoices in case you have too many.
You can download the Invoice Generator Template by clicking on the button below:

Modifying the Invoice Generator Template

I created this invoice template with a format that I needed for my GST filings.
If you need a different format, you’ll have to edit the template and then adjust the backend VBA code.
Let me first show you the code and explain how it works:
Sub CreateInvoice(RowNum As Integer)
Application.ScreenUpdating = False
Dim wb As Workbook
Dim sh As Worksheet
With shInvoiceTemplate
.Range("D10") = shDetails.Range("A" & RowNum)
.Range("D11") = shDetails.Range("B" & RowNum)
.Range("D12") = shDetails.Range("C" & RowNum)
.Range("B15") = shDetails.Range("D" & RowNum)
.Range("D15") = shDetails.Range("F" & RowNum)
.Range("D16") = shDetails.Range("G" & RowNum)
.Range("D18") = shDetails.Range("E" & RowNum)
End With
FPath = "C:\Users\sumit\Desktop\Invoice PDFs"
Fname = Format(shInvoiceTemplate.Range("D10"), "mmmm yyyy") _
& "_" & shInvoiceTemplate.Range("D12")
shInvoiceTemplate.Copy
ActiveSheet.Name = "InvTemp"
Set wb = ActiveWorkbook
Set sh = ActiveSheet
sh.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
FPath & "\" & Fname, Quality:=xlQualityStandard, IncludeDocProperties:=True, _
IgnorePrintAreas:=False, OpenAfterPublish:=False
wb.Close SaveChanges:=False
ThisWorkbook.Activate
Application.ScreenUpdating = True
End Sub
The above code is what copies the details of a transaction, fills the invoice placeholder template with those details, creates a new workbook, and save the new workbook as a PDF in the specified folder.
If you have a different template or a different folder location, you need to modify the below-highlighted parts of the code:
GST Invoice Generator Template in Excel 2018 modifying the code
  1. The first highlighted section is what takes the details from the Details sheet and populates the invoice template. If you decide to modify the invoice template, you need to make sure you are picking the right details by modifying this part of the code.
  2. This line specifies the folder location. In my case, it was a folder on my Desktop. You can specify the address of the folder where you want the invoices to be saved.
Note that I have renamed the worksheet code name to ‘shDetails’. I have done this so that I can use the name – shDetails – in my code and it would continue to work even if you change the name of the sheets in the worksheet.
If you want to learn more about the sheet name and the code name, have a look at this (check out the section on using the Worksheet code name).

Where is the code in the workbook?

The code is placed in the back-end of the Excel workbook in a module.
To access the code, follow the below steps:
  1. Click the Developer tab.
  2. Click the Visual Basic option. This will open the VB Editor window.
  3. In the Visual Basic editor, double-click on the Module to open its code window. You’ll find the code mentioned above.GST Invoice Generator Template in Excel code in the module window
In case you’re creating a template yourself, you may not find the Module in a new workbook. You need to right-click on any of the workbook objects, go to Insert, and then click on Module. This will insert a new module. Insert a new module in VB Editor Excel

Making the Double-click functionality to Work

The above code does all the heavy lifting, but you need to connect it to the double-click event.
This means that the above VBA macro code needs to run whenever someone double-clicks on the filled cells in the client name column.This can be done by inserting the following code in the worksheet code window:
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
If Target.Cells <> "" And Target.Column = 2 Then
Cancel = True
Call CreateInvoice(Target.Row)
End If
End Sub
Here are the steps to insert this code in the worksheet backend:
  • Right-click on the ‘Details’ worksheet tab
  • Click on the ‘View Code’ option.GST Invoice Generator Template in Excel 2018 click on view code
  • Copy and paste the above code into the code window that appears.Invoice Generator Template in Excel 2018 double click code
The above code does the following things:
  1. Checks if the cell that has been double-clicked has the client details or not. It uses the IF statement to check and run the code only if the cell is not empty and in Column B.
  2. If both the specified criteria are met, it disables double-click functionality (which is to get into the edit mode) and calls the ‘CreateInvoice’ subroutine, which is stored in the Module. It also passes the row number value to the subroutine. For example, if I double-click on the client name in the third row, it will pass 3 as the value to the CreateInvoice subroutine.
  3. Once the ‘CreateInvoice’ subroutine is executed – which creates the PDF of the invoice – it ends.

Saving the Invoice Template as Excel (instead of PDF)

If you want to save the invoice templates as Excel files and not as PDFs, you can use the below code instead:
Sub CreateInvoice(RowNum As Integer)
Application.ScreenUpdating = False
Dim wb As Workbook
Dim sh As Worksheet
With shInvoiceTemplate
.Range("D10") = shDetails.Range("A" & RowNum)
.Range("D11") = shDetails.Range("B" & RowNum)
.Range("D12") = shDetails.Range("C" & RowNum)
.Range("B15") = shDetails.Range("D" & RowNum)
.Range("D15") = shDetails.Range("F" & RowNum)
.Range("D16") = shDetails.Range("G" & RowNum)
.Range("D18") = shDetails.Range("E" & RowNum)
End With
FPath = "C:\Users\sumit\Desktop\Invoice PDFs"
Fname = Format(shInvoiceTemplate.Range("D10"), "mmmm yyyy") _
& "_" & shInvoiceTemplate.Range("D12")
shInvoiceTemplate.Copy
ActiveSheet.Name = "InvTemp"
Set wb = ActiveWorkbook
Set sh = ActiveSheet
sh.Name = Fname
wb.SaveAs Filename:=FPath & "\" & Fname
wb.Close SaveChanges:=False
ThisWorkbook.Activate
Application.ScreenUpdating = True
End Sub
The above code saves the invoice as an Excel workbook with the same naming convention. The worksheet in the workbook that contains the filled invoice in each saved workbook is also named the same.
#evba #etipfree #kingexcel
📤You download App EVBA.info installed directly on the latest phone here : https://www.evba.info/p/app-evbainfo-setting-for-your-phone.html?m=1