Скачать или смотреть TigerVQ #1 Excel VBA Loop Control Options - For Next Loop, Do Until Loop

This video deals with Excel VBA Loop Control, specifically For Next Loop and Do Until Loops in Excel VBA. A number of different loop controls are available in Excel VBA and each presents different possibilities, so why limit your knowledge to a single loop technique? Command of a range of techniques will lead to better flexibility in your spreadsheets. And it's a chance to improve your coding still further!

In the TigerVQ series, Chris deals with viewer questions in the comments on the channel. In this video, a viewer requests a different way to control a loop. Yes, it is possible to control a loop using a For (Variable) = 1 to 10 type construct in the VBA editor, but what options are available to give the user greater control? We look at using the spreadsheet to control a loop, and at how to apply an input box for a cool interactive control.

The video builds on an example from the Excel VBA for beginners series. View the original video series and download the file used in the video here:

   • Excel VBA for Post-Beginners: (1/6) S...  

Get in touch with Tiger using the platforms below!

For regular spreadsheet hints and tips and more on the #ExcelRevolution:
  / tigerspreadsheetsolutions  
  / tigspreadsheets  
http://tigerspreadsheetsolutions.co.uk