Loops in VBA

>> YOUR LINK HERE: ___ http://youtube.com/watch?v=YAgURl_g9zQ

Excel ## VBA ## Loops ## For ## For Each ## DO while # Do UNTIL ###","styleRuns":[{"startIndex":0,"length":67,"fontSize":0,"styleRunExtensions":{"styleRunColorMapExtension":{"colorMap":[{"key":"USER_INTERFACE_THEME_DARK","value":4294967295},{"key":"USER_INTERFACE_THEME_LIGHT","value":4279440147}]}},"fontFamilyName":"Roboto"}]},"headerRuns":[{"startIndex":0,"length":67,"headerMapping":"ATTRIBUTED_STRING_HEADER_MAPPING_HEADING_2"}]}},{"itemSectionRenderer":{"contents":[{"continuationItemRenderer":{"trigger":"CONTINUATION_TRIGGER_ON_ITEM_SHOWN","continuationEndpoint":{"clickTrackingParams":"CLcBELsvGAIiEwiQxIjvkZOKAxXEmIwIHcxRE1w=","commandMetadata":{"webCommandMetadata":{"sendPost":true,"apiUrl":"/youtubei/v1/next"}},"continuationCommand":{"token":"Eg0SC1lBZ1VSbF9nOXpRGAYyJSIRIgtZQWdVUmxfZzl6UTAAeAJCEGNvbW1lbnRzLXNlY3Rpb24%3D","request":"CONTINUATION_REQUEST_TYPE_WATCH_NEXT"}}}}],"trackingParams":"CLcBELsvGAIiEwiQxIjvkZOKAxXEmIwIHcxRE1w=","sectionIdentifier":"comment-item-section","targetId":"comments-section"}}],"trackingParams":"CLYBELovIhMIkMSI75GTigMVxJiMCB3MURNc"}},"secondaryResults":{"secondaryResults":{"results":[{"compactVideoRenderer":{"videoId":"lYq9iqqtLqs","thumbnail":{"thumbnails":[{"url":"https://i.ytimg.com/vi/lYq9iqqtLqs/hqdefault.jpg?sqp=-oaymwE8CKgBEF5IWvKriqkDLwgBFQAAAAAYASUAAMhCPQCAokN4AfABAfgB_gmAAqIFigIMCAAQARgiIFoofzAP rs=AOn4CLCiJ5N387NXWb7pAgeI6-07KY6iUg","width":168,"height":94},{"url":"https://i.ytimg.com/vi/lYq9iqqtLqs/hqdefault.jpg?sqp=-oaymwE9CNACELwBSFryq4qpAy8IARUAAAAAGAElAADIQj0AgKJDeAHwAQH4Af4JgAKiBYoCDAgAEAEYIiBaKH8wDw== rs=AOn4CLCpo56lPgKW03h_Wc4nlVb1MLoqtw","width":336,"height":188}]},"title":{"accessibility":{"accessibilityData":{"label":"By Val and By Ref in VBA door EXQL-Soft-Learning 149 weergaven 2 maanden geleden 23 minuten"}},"simpleText":"By Val and By Ref in VBA"},"longBylineText":{"runs":[{"text":"EXQL-Soft-Learning ","navigationEndpoint":{"clickTrackingParams":"CLABEKQwGAAiEwiQxIjvkZOKAxXEmIwIHcxRE1wyB3JlbGF0ZWQ=","commandMetadata":{"webCommandMetadata":{"url":"/@EXQL-Soft-Learning","webPageType":"WEB_PAGE_TYPE_CHANNEL","rootVe":3611,"apiUrl":"/youtubei/v1/browse"}},"browseEndpoint":{"browseId":"UCc-ByI1TnYX-NkhW9klttJQ","canonicalBaseUrl":"/@EXQL-Soft-Learning"}}}]},"publishedTimeText":{"simpleText":"2 maanden geleden"},"viewCountText":{"simpleText":"149 weergaven"},"lengthText":{"accessibility":{"accessibilityData":{"label":"23 minuten en 5 seconden"}},"simpleText":"23:05"},"navigationEndpoint":{"clickTrackingParams":"CLABEKQwGAAiEwiQxIjvkZOKAxXEmIwIHcxRE1wyB3JlbGF0ZWRItO6D_-WIhYRgmgEFCAEQ-B0=","commandMetadata":{"webCommandMetadata":{"url":"/watch?v=lYq9iqqtLqs","webPageType":"WEB_PAGE_TYPE_WATCH","rootVe":3832}},"watchEndpoint":{"videoId":"lYq9iqqtLqs","nofollow":true,"watchEndpointSupportedOnesieConfig":{"html5PlaybackOnesieConfig":{"commonConfig":{"url":"https://rr4---sn-oj5hn5-55.googlevideo.com/initplayback?source=youtube oeis=1 c=WEB oad=3200 ovd=3200 oaad=11000 oavd=11000 ocs=700 oewis=1 oputc=1 ofpcc=1 msp=1 odepv=1 id=958abd8aaaad2eab ip=5.34.180.93 initcwndbps=247500 mt=1733487443 oweuc= pxtags=Cg4KAnR4Egg1MTMzNzAwMQ rxtags=Cg4KAnR4Egg1MTMzNjk5OQ%2CCg4KAnR4Egg1MTMzNzAwMA%2CCg4KAnR4Egg1MTMzNzAwMQ"}}}}},"shortBylineText":{"runs":[{"text":"EXQL-Soft-Learning ","navigationEndpoint":{"clickTrackingParams":"CLABEKQwGAAiEwiQxIjvkZOKAxXEmIwIHcxRE1wyB3JlbGF0ZWQ=","commandMetadata":{"webCommandMetadata":{"url":"/@EXQL-Soft-Learning","webPageType":"WEB_PAGE_TYPE_CHANNEL","rootVe":3611,"apiUrl":"/youtubei/v1/browse"}},"browseEndpoint":{"browseId":"UCc-ByI1TnYX-NkhW9klttJQ","canonicalBaseUrl":"/@EXQL-Soft-Learning"}}}]},"channelThumbnail":{"thumbnails":[{"url":"https://yt3.ggpht.com/ytc/AIdro_n_lui30_R4aFboFtgT_VxYjD4iTGYWon2fteKOKgKDhtSlE3mEcaX1nF_zJZGiJY87Og=s68-c-k-c0x00ffffff-no-rj","width":68,"height":68}]},"trackingParams":"CLABEKQwGAAiEwiQxIjvkZOKAxXEmIwIHcxRE1xAq9201aqxr8WVAQ==","shortViewCountText":{"accessibility":{"accessibilityData":{"label":"149 weergaven"}},"simpleText":"149 weergaven"},"menu":{"menuRenderer":{"items":[{"menuServiceItemRenderer":{"text":{"runs":[{"text":"Toevoegen aan wachtrij"}]},"icon":{"iconType":"ADD_TO_QUEUE_TAIL"},"serviceEndpoint":{"clickTrackingParams":"CLQBEP6YBBgFIhMIkMSI75GTigMVxJiMCB3MURNc","commandMetadata":{"webCommandMetadata":{"sendPost":true}},"signalServiceEndpoint":{"signal":"CLIENT_SIGNAL","actions":[{"clickTrackingParams":"CLQBEP6YBBgFIhMIkMSI75GTigMVxJiMCB3MURNc","addToPlaylistCommand":{"openMiniplayer":false,"openListPanel":true,"videoId":"lYq9iqqtLqs","listType":"PLAYLIST_EDIT_LIST_TYPE_QUEUE","onCreateListCommand":{"clickTrackingParams":"CLQBEP6YBBgFIhMIkMSI75GTigMVxJiMCB3MURNc","commandMetadata":{"webCommandMetadata":{"sendPost":true,"apiUrl":"/youtubei/v1/playlist/create"}},"createPlaylistServiceEndpoint":{"videoIds":["lYq9iqqtLqs"],"params":"CAQ%3D"}},"videoIds":["lYq9iqqtLqs"]}},{"clickTrackingParams":"CLQBEP6YBBgFIhMIkMSI75GTigMVxJiMCB3MURNc","openPopupAction":{"popup":{"notificationActionRenderer":{"responseText":{"simpleText":"Toegevoegd aan wachtrij"},"trackingParams":"CLUBELlqIhMIkMSI75GTigMVxJiMCB3MURNc"}},"popupType":"TOAST"}}]}},"trackingParams":"CLQBEP6YBBgFIhMIkMSI75GTigMVxJiMCB3MURNc"}},{"menuServiceItemRenderer":{"text":{"runs":[{"text":"Delen"}]},"icon":{"iconType":"SHARE"},"serviceEndpoint":{"clickTrackingParams":"CLABEKQwGAAiEwiQxIjvkZOKAxXEmIwIHcxRE1w=","commandMetadata":{"webCommandMetadata":{"sendPost":true,"apiUrl":"/youtubei/v1/share/get_share_panel"}},"shareEntityServiceEndpoint":{"serializedShareEntity":"CgtsWXE5aXFxdExxcw%3D%3D","commands":[{"clickTrackingParams":"CLABEKQwGAAiEwiQxIjvkZOKAxXEmIwIHcxRE1w=","openPopupAction":{"popup":{"unifiedSharePanelRenderer":{"trackingParams":"CLMBEI5iIhMIkMSI75GTigMVxJiMCB3MURNc","showLoadingSpinner":true}},"popupType":"DIALOG","beReused":true}}]}},"trackingParams":"CLABEKQwGAAiEwiQxIjvkZOKAxXEmIwIHcxRE1w=","hasSeparator":true}}],"trackingParams":"CLABEKQwGAAiEwiQxIjvkZOKAxXEmIwIHcxRE1w=","accessibility":{"accessibilityData":{"label":"Actiemenu"}},"targetId":"watch-related-menu-button"}},"thumbnailOverlays":[{"thumbnailOverlayTimeStatusRenderer":{"text":{"accessibility":{"accessibilityData":{"label":"23 minuten en 5 seconden"}},"simpleText":"23:05"},"style":"DEFAULT"}},{"thumbnailOverlayToggleButtonRenderer":{"isToggled":false,"untoggledIcon":{"iconType":"WATCH_LATER"},"toggledIcon":{"iconType":"CHECK"},"untoggledTooltip":"Later bekijken","toggledTooltip":"Toegevoegd","untoggledServiceEndpoint":{"clickTrackingParams":"CLIBEPnnAxgBIhMIkMSI75GTigMVxJiMCB3MURNc","commandMetadata":{"webCommandMetadata":{"sendPost":true,"apiUrl":"/youtubei/v1/browse/edit_playlist"}},"playlistEditEndpoint":{"playlistId":"WL","actions":[{"addedVideoId":"lYq9iqqtLqs","action":"ACTION_ADD_VIDEO"}]}},"toggledServiceEndpoint":{"clickTrackingParams":"CLIBEPnnAxgBIhMIkMSI75GTigMVxJiMCB3MURNc","commandMetadata":{"webCommandMetadata":{"sendPost":true,"apiUrl":"/youtubei/v1/browse/edit_playlist"}},"playlistEditEndpoint":{"playlistId":"WL","actions":[{"action":"ACTION_REMOVE_VIDEO_BY_VIDEO_ID","removedVideoId":"lYq9iqqtLqs"}]}},"untoggledAccessibility":{"accessibilityData":{"label":"Later bekijken"}},"toggledAccessibility":{"accessibilityData":{"label":"Toegevoegd"}},"trackingParams":"CLIBEPnnAxgBIhMIkMSI75GTigMVxJiMCB3MURNc"}},{"thumbnailOverlayToggleButtonRenderer":{"untoggledIcon":{"iconType":"ADD_TO_QUEUE_TAIL"},"toggledIcon":{"iconType":"PLAYLIST_ADD_CHECK"},"untoggledTooltip":"Toevoegen aan wachtrij","toggledTooltip":"Toegevoegd","untoggledServiceEndpoint":{"clickTrackingParams":"CLEBEMfsBBgCIhMIkMSI75GTigMVxJiMCB3MURNc","commandMetadata":{"webCommandMetadata":{"sendPost":true}},"signalServiceEndpoint":{"signal":"CLIENT_SIGNAL","actions":[{"clickTrackingParams":"CLEBEMfsBBgCIhMIkMSI75GTigMVxJiMCB3MURNc","addToPlaylistCommand":{"openMiniplayer":false,"openListPanel":true,"videoId":"lYq9iqqtLqs","listType":"PLAYLIST_EDIT_LIST_TYPE_QUEUE","onCreateListCommand":{"clickTrackingParams":"CLEBEMfsBBgCIhMIkMSI75GTigMVxJiMCB3MURNc","commandMetadata":{"webCommandMetadata":{"sendPost":true,"apiUrl":"/youtubei/v1/playlist/create"}},"createPlaylistServiceEndpoint":{"videoIds":["lYq9iqqtLqs"],"params":"CAQ%3D"}},"videoIds":["lYq9iqqtLqs"]}}]}},"untoggledAccessibility":{"accessibilityData":{"label":"Toevoegen aan wachtrij"}},"toggledAccessibility":{"accessibilityData":{"label":"Toegevoegd"}},"trackingParams":"CLEBEMfsBBgCIhMIkMSI75GTigMVxJiMCB3MURNc"}},{"thumbnailOverlayNowPlayingRenderer":{"text":{"runs":[{"text":"Wordt nu afgespeeld"}]}}}],"accessibility":{"accessibilityData":{"label":"By Val and By Ref in VBA - 23 minuten - Naar kanaal gaan - EXQL-Soft-Learning - 149 weergaven - 2 maanden geleden - video afspelen"}}}},{"lockupViewModel":{"contentImage":{"collectionThumbnailViewModel":{"primaryThumbnail":{"thumbnailViewModel":{"image":{"sources":[{"url":"https://i.ytimg.com/vi/QYW1SlKfKdM/hqdefault.jpg?sqp=-oaymwEWCKgBEF5IWvKriqkDCQgBFQAAiEIYAQ== rs=AOn4CLCTga1-7p2-igP5m7dYUL2uZqitYw","width":168,"height":94},{"url":"https://i.ytimg.com/vi/QYW1SlKfKdM/hqdefault.jpg?sqp=-oaymwEXCNACELwBSFryq4qpAwkIARUAAIhCGAE= rs=AOn4CLD6mBkqbJs1R4H3PAZJKW1tk5v7Yw","width":336,"height":188}]},"overlays":[{"thumbnailOverlayBadgeViewModel":{"thumbnailBadges":[{"thumbnailBadgeViewModel":{"icon":{"sources":[{"clientResource":{"imageName":"PLAYLISTS"}}]},"text":"5 video's","badgeStyle":"THUMBNAIL_OVERLAY_BADGE_STYLE_DEFAULT","backgroundColor":{"lightTheme":3355443,"darkTheme":3355443}}}],"position":"THUMBNAIL_OVERLAY_BADGE_POSITION_BOTTOM_END"}},{"thumbnailHoverOverlayViewModel":{"icon":{"sources":[{"clientResource":{"imageName":"PLAY_ALL"}}]},"text":{"content":"Alles afspelen","styleRuns":[{"startIndex":0,"length":14}]},"style":"THUMBNAIL_HOVER_OVERLAY_STYLE_COVER"}}],"backgroundColor":{"lightTheme":3750201,"darkTheme":3750201}}},"stackColor":{"lightTheme":10066329,"darkTheme":9211020}}},"metadata":{"lockupMetadataViewModel":{"title":{"content":"VBA UserForms"},"metadata":{"contentMetadataViewModel":{"metadataRows":[{"metadataParts":[{"text":{"content":"Excel Macro Mastery

#############################

New on site