www.excelgoodies.com Open in urlscan Pro
104.42.35.35  Public Scan

Form analysis
3 forms found in the DOM

GET https://www.excelgoodies.com/blog/

<form method="get" id="searchform-movil" action="https://www.excelgoodies.com/blog/">
  <label for="s" class="assistive-text">Search</label>
  <input type="search" class="txt-search-movil" placeholder="Search..." name="s" id="s">
  <input type="submit" name="submit" id="btn-search-movil" value="Search">
</form>

Name: input — POST

<form name="input" method="post">
  <div class="modal-header" style="background-color: #5cb85c;">
    <h3 class="modal-title" style="text-align: center; color: #FFFFFD; font-family: Verdana;">Please enter your Email-id</h3>
  </div>
  <div class="modal-body">
    <div class="form-group">
      <div style="margin-top: 10px;" class="input-group">
        <span class="input-group-addon" id="basic-addon1">@</span>
        <input name="txtEmailId2" type="text" id="txtEmailId2" class="form-control" placeholder="Email-Id" aria-describedby="basic-addon1" style="height: 40px;">
      </div>
      <div style="margin-top: 10px;" class="input-group">
        <span class="input-group-addon"><i class="glyphicon glyphicon-map-marker"></i></span>
        <input name="txtLocation2" type="text" id="txtLocation2" class="form-control" placeholder="Location" aria-describedby="basic-addon1" style="height: 40px;">
      </div>
    </div>
  </div>
  <div class="modal-footer">
    <a class="btn btn-success" onclick="return SubsValidate();" style="font-weight: bolder;">Subscribe</a>
    <a class="btn btn-default" data-dismiss="modal">Cancel</a>
    <input type="submit" style="display:none;" value="submit" id="imgBtnSubmit">
  </div>
</form>

GET https://www.excelgoodies.com/blog/

<form method="get" id="searchform" action="https://www.excelgoodies.com/blog/">
  <label for="s" class="assistive-text">Search</label>
  <input type="text" class="txt-search-n" name="s" id="s">
  <input type="submit" name="submit" id="btn-search-n" value="Search">
</form>

Text Content

MENU
Search


Skip to content


PLEASE ENTER YOUR EMAIL-ID

@

Subscribe Cancel


IS POWER BI, THE SILENT DEATH OF SSRS?

Well, the end-purpose of both tools is to help business users with high-end
reporting. Where does the difference lie? The changing role of Business Users
from just “receiving” the powerful… Read more »

Power BI   



IS KNOWING EXCEL VBA A GOOD STARTING POINT FOR LEARNING ANY OTHER PROGRAMMING
LANGUAGES?

Yes – If you are a “BUSINESS USER” (non-programmer) looking to get into
programming (part time/full-fledged). My whole point stands on one belief – You
learn best when “you connect what you learn… Read more »

Uncategorized    Excel VBA



HOW TO SHOW PROGRESS ON STATUS BAR USING VBA?

The below code will add serial numbers up to 500 in your sheet and along with it
will show progress on the status bar. Sub progressStatusBar()
Application.StatusBar= “Start Printing the… Read more »

VBA Code Bank, VBA Macro Programming    Excel VBA



OPEN XML FILE IN EXCEL

Here are the primitive commands to open an XML file in Microsoft Excel. Sub
Open_XMLFile() Dim OXML As Workbook Set OXML =
Workbooks.OpenXML(“c:\sample.xml”) End Sub Sub Open_XML_File_As_List() Dim OXML
As… Read more »

VBA Code Bank, VBA Macro Programming    Excel VBA, Microsoft Excel VBA



WHY VLOOKUP WHEN THERE IS INDEX?

Vlookup: The syntax for Vlookup is:
VLOOKUP(lookup_value,table_array,col_index_num,range_lookup) Index: The Syntax
for Index is: INDEX( array, row_number, [column_number] ) Match: The Syntax for
Match is: MATCH( value, array, [match_type] ) Problem:… Read more »

Microsoft Excel    Index, Vlookup



MERGE TEXT FILES USING VBA

The below code merges around 50 ascii files into one It uses File System Object
and you need to add a reference of Microsoft Scripting Runtime Sub
Append_Text_Files() Dim F1… Read more »

VBA Code Bank, VBA Macro Programming    Excel VBA, Microsoft Excel VBA



HOW TO REVERSE THE TEXT IN A CELL?

All you have to do just enter “reverse” function in a cell and refer to the cell
in which you have text which you want to reverse. Public Function reverse(ByVal…
Read more »

VBA Code Bank, VBA Macro Programming    Excel VBA Code



HOW TO CONVERT TEXT TO SPEECH USING VBA?

Just select a range and run this code, excel will speak all the text what you
have in that range, cell by cell. Sub Speak() Selection.Speak End Sub Do
wonders… Read more »

VBA Code Bank, VBA Macro Programming    Excel VBA



HOW TO SAVE EACH WORKSHEET AS A SINGLE PDF?

The below code will let you save each Worksheet as a single PDF Sub
SaveWorkshetAsPDF() Dimws As Worksheet For Each ws In
Worksheetsws.ExportAsFixedFormat xlTypePDF, “ENTER FOLDER NAME HERE” ; ws.Name…
Read more »

VBA Code Bank, VBA Macro Programming    Excel VBA



ADD A CALCULATOR TO THE EXCEL TOOLBAR

There’s a calculator in Excel 2010 but by default this feature is hidden, to get
the calculator on your Excel screen navigate to Quick Access toolbar options,
it’s the down… Read more »

Microsoft Excel    Microsoft Excel



POST NAVIGATION

← Older posts

18 - Jan - 2022
Search


RECENT POSTS

 * Is Power Bi, the silent death of SSRS?
 * Is knowing Excel VBA a good starting point for learning any other programming
   languages?
 * How to Show Progress on Status Bar using VBA?
 * Open XML File in Excel
 * Why Vlookup when there is Index?


ARCHIVES

 * September 2021
 * August 2021
 * June 2017
 * May 2017
 * April 2017
 * March 2017
 * February 2017
 * January 2017
 * December 2016
 * November 2016
 * October 2016
 * September 2016
 * August 2016
 * July 2016
 * June 2016
 * May 2016
 * April 2016
 * March 2016
 * February 2016
 * January 2016
 * December 2015
 * November 2015
 * October 2015
 * September 2015
 * April 2015
 * March 2015
 * February 2015
 * November 2014
 * October 2014
 * July 2014
 * April 2014
 * March 2014


CATEGORIES

 * Charts ; Graphs (4)
 * Dashboards (2)
 * Microsoft Excel (29)
 * Power BI (1)
 * PowerPivots (4)
 * Uncategorized (1)
 * VBA Code Bank (32)
 * VBA Macro Programming (34)


META

 * Log in
 * Entries RSS
 * Comments RSS
 * WordPress.org

Copyright 2016
Excelgoodies, Inc.
Ribosome by GalussoThemes.com
Powered by WordPress