Скачать или смотреть Select Multiple Values in Excel Data Validation! Full VBA line-by-line walkthrough and refactor

Learn the select multiple values for cells with data validation -the RIGHT way!

We review a popular web result for how to do this - then refactor the code to be LESS THAN HALF the number of lines (and almost half the characters).

Then we fix a bug with the original code!

00:00 - 01:26 Intro
01:27 - 02:02 The Question
02:03 - 05:49 Pseudo Code
05:50 - 06:23 Original Code operations
06:24 - 11:52 Original Code Review part 1
11:53 - 13:00 Range.Cells Object Model
13:01 - 15:05 Original Code Review Part 2
15:06 - 15:32 Rant #1
15:33 - 16:23 Intersect Object Model
16:24 - 19:30 Original Code Review Part 3
19:31 - 19:58 Rant #2
19:59 - 22:47 Original Code REview Part 4
22:48 - 23:25 GOTE Code Operations
23:26 - 28:36 GOTE Cod Review
28:37 - 31:51 Bug Smash

#exceltutorial #vbaprogramming #vbatutorial