By using listi.net you agree to our cookie policy, We and our partners operate globally and use cookies, for multiple purposes

listi.net

 


Excel VBA - Random Selection

video of Random Selection

Click to view video

Prerequisite Videos


Shortcut keys used
  • Ctrl+P shortcut
  • How to setup Ctrl+Shift+R key
  • Alt+tab
  • Ctrl+F9
  • F7 - code window
  • F8
  • Shift+F2 - go to routine
  • Debugger

    Excel
  • Filters

    VBA
  • Do statement
  • Loops
  • VBA Editor
  • Syntax Errors
  • Source Code
  • sub
  • VBE
  • Showing Excel and VBE at the same time
  • Creating a new sub
  • What is a sub
  • Why create subroutines
  • Requirements
  • Filters
  • Switch between Excel and VBA
  • Column range
  • Circular reference
  • Unfilter
  • Scrolling down
  • Copy/Paste
  • [ ] to run formula
  • Browser
  • Listi
  • variables
  • Assignment statement

    Functions
  • =randbetween
  • Subtotal
  • CountA

    VBA Statements
  • cells(r,c).select
  • activecell.column
  • columnletter
  • application.evaluate
  • String concatenation
  • rows
  • if
  • .hidden
  • do - loop
  • I = I + 1
  • rn = rn - 1
  • activecell
  • or
  • I < 2
  • do while
  • end sub
  • delete code
  • comment code

    Problems
  • Hover not working

    • blog comments powered by Disqus