Friday, November 1, 2019

AutoIT useful information

Some features:
  • Very easy to create/manage/publish AutoIt projects (compile)
  • Integrated GUI Editor (ISN Form Studio 2)
  • Integrated file & project manager
  • Extendable thanks to plugins and open source!
  • Available in several languages
  • trophies
  • AutoIt 3 Syntax Highlighting / Autocomplete / IntelliSense
  • macros
  • Change Manager for your AutoIt project
  • Detailed overview of your project (how long have you been working on it, total size, etc.)
  • Integrated to-do list for your project
  • Optimized for high-resolution display (High DPI)
  • And much, much more!
ISN AutoIt Studio is free and 100% written (except for some DLL's) in AutoIt!
The latest version of ISN AutoIt Studio can be found under `Downloads'!

For AutoIT script making download ISN Studio followed by below URL

Guides/Tutorials

  • Tutorials - There are many tutorials available for AutoIt. This page is an overview of a few known tutorials.
  • Best coding practices - a detailed explanation of what are to be considered the best coding practices within AutoIt. These recommendations are based on accepted coding practices common to a number of other programming languages. You do not need to follow them, but it is recommended that you do.
  • Snippets - generally single functions or small pieces of code that can be incorporated into a script to add extra functionality.

Videos

Books

Syntax Highlighter

Other Awesome Lists


Checkout below URL for more useful information

https://github.com/J2TEAM/awesome-AutoIt#browsers

How To Auto-Center Checkbox In Cell In Excel?



How To Auto-Center Checkbox In Cell In Excel?

To automatically center all checkboxes in cells in a current worksheet, please do as follows.
1. In the worksheet, you need to auto-center all checkboxes, press the Alt + F11 keys to open the Microsoft Visual Basic for Applications window.
2. In the Microsoft Visual Basic for Applications window, please click Insert > Module. Then copy and paste VBA code into the code window.
VBA code: Automatically center all checkboxes in cells
Sub CenterCheckbox ()
Dim xRg As Range
Dim chkBox As OLEObject
Dim chkFBox As CheckBox
On Error Resume Next
Application.ScreenUpdating = False
For Each chkBox In ActiveSheet.OLEObjects
If TypeName(chkBox.Object) = "CheckBox" Then
Set xRg = chkBox.TopLeftCell
chkBox.Width = xRg.Width * 2 / 3
chkBox.Height = xRg.Height
chkBox.Left = xRg.Left + (xRg.Width - chkBox.Width) / 2
chkBox.Top = xRg.Top + (xRg.Height - chkBox.Height) / 2
End If
Next
For Each chkFBox In ActiveSheet.CheckBoxes
Set xRg = chkFBox.TopLeftCell
chkFBox.Width = xRg.Width * 2 / 3
chkFBox.Height = xRg.Height
chkFBox.Left = xRg.Left + (xRg.Width - chkFBox.Width) / 2
chkFBox.Top = xRg.Top + (xRg.Height - chkFBox.Height) / 2
Next
Application.ScreenUpdating = True
End Sub
3. Press the F5 key. Then all checkboxes are moved into the center of the cells immediately as below screenshot shown.
Note: This VBA code can be applied to both CheckBox (ActiveX Control) and CheckBox (Form Control).
For more details kindly follow below URL:
Thank you very much for taking the time to reading this topic.