Jiangws's Blog

 
 
 
  • About

    夢を叶える為
 
INDIRECT formula to dynamically refer to another worksheet ->INDIRECT(“‘” & Sheet’s name & “‘!” & Cell to pull data from) May 16th, 2021

Excel INDIRECT function – basic uses and formula examples (ablebits.com)

Posted in VBA || Comments Off on INDIRECT formula to dynamically refer to another worksheet ->INDIRECT(“‘” & Sheet’s name & “‘!” & Cell to pull data from)
Benefit for learning VBA May 2nd, 2021

Unlike macros, VBA enables you to do the following:

  • Work with complex logic structures (case statements, loops, and so on)
  • Take advantage of functions and actions not available in macros
  • Loop through and perform actions on recordsets
  • Perform transaction processing
Posted in VBA || Comments Off on Benefit for learning VBA
ParamArray August 22nd, 2020

The ParamArray keyword allows you to accept a dynamic number of arguments.
The word ParamArray is an abbreviation for parameter array.
Instead of using a large number of optional parameters it might be better to use a parameter array instead.…

Posted in VBA || Comments Off on ParamArray
Python for Machine Learning: Indexing and Slicing for Lists, Tuples, Strings, and other Sequential Types May 25th, 2020

List is arguably the most useful and ubiquitous type in Python. One of the reasons it’s so handy is Python slice notation. In short, slicing is a flexible tool to build new lists out of an existing list.

Python supports …

Posted in Python || Comments Off on Python for Machine Learning: Indexing and Slicing for Lists, Tuples, Strings, and other Sequential Types
Cool Javascript Find on this Page… March 29th, 2017

http://www.seabreezecomputers.com/tips/find.htm

Posted in JavaScript || Comments Off on Cool Javascript Find on this Page…
jQuery: fire click() before blur() event March 21st, 2017

Solution 1

Listen to mousedown instead of click.

The mousedown and blur events occur one after another when you press the mouse button, but click only occurs when you release it.

Solution 2

You can preventDefault() in mousedown to …

Posted in JavaScript || Comments Off on jQuery: fire click() before blur() event
Sortable — is a JavaScript library for reorderable drag-and-drop lists on modern browsers and touch devices. No jQuery. Supports Meteor, AngularJS, React, Polymer, Knockout and any CSS library, e.g. Bootstrap. March 17th, 2017

https://github.com/RubaXa/Sortable

Posted in JavaScript || Comments Off on Sortable — is a JavaScript library for reorderable drag-and-drop lists on modern browsers and touch devices. No jQuery. Supports Meteor, AngularJS, React, Polymer, Knockout and any CSS library, e.g. Bootstrap.
Reorder list using jQuery and ASP.NET http://sumo.ly/9Lu4 via @CodeAspNet March 16th, 2017

http://codeasp.net/articles/asp-net/65/reorder-list-using-jquery-and-asp-net

Posted in ASP.NET || Comments Off on Reorder list using jQuery and ASP.NET http://sumo.ly/9Lu4 via @CodeAspNet
Bootstrap Multiple Select (Multi-Select) DropDownList with CheckBoxes in ASP.Net MVC Razor March 15th, 2017

https://www.aspsnippets.com/Articles/Bootstrap-Multiple-Select-Multi-Select-DropDownList-with-CheckBoxes-in-ASPNet-MVC-Razor.aspx

Posted in ASP.NET || Comments Off on Bootstrap Multiple Select (Multi-Select) DropDownList with CheckBoxes in ASP.Net MVC Razor
Play Sounds in Websites March 14th, 2017

http://www.schillmania.com/projects/soundmanager2/demo/template/

Posted in Programming(Web etc) || Comments Off on Play Sounds in Websites