VBA поддерживает два типа подпрограмм: процедуры и функции.
Функция — это подпрограмма, которая возвращает результат. Вызов функции является выражением, и может использоваться в других выражениях или в правой части оператора присваивания.
Процедура — это любая подпрограмма, которая не является функцией. Любой макрос VBA является подпрограммой типа "процедура".
{"1_d42f0":{"state":{"visibleItems":[{"content":[{"type":"text","text":"VBA поддерживает два типа подпрограмм: процедуры и функции."}]},{"marker":"bullet","level":1,"content":[{"type":"text","text":"Функция — это подпрограмма, которая возвращает результат. Вызов функции является выражением, и может использоваться в других выражениях или в правой части оператора присваивания."}]},{"marker":"bullet","level":1,"content":[{"type":"text","text":"Процедура — это любая подпрограмма, которая не является функцией. Любой макрос VBA является подпрограммой типа \"процедура\"."}]}],"path":{"items":[{"text":"academy.kgtk.ru"}],"favicon":{"index":0,"pageNumber":0,"size":"m","entry":"1"}},"url":"http://academy.kgtk.ru/it3/ppp/sub-and-function.html","favicon":{"index":0,"pageNumber":0,"size":"m","entry":"1"},"headline":"2.5.3 VBA. Процедуры и функции | Пакеты прикладных...","titleLines":1,"shouldWrapFold":false,"shouldOpenAllCollapsers":false,"disableReadMore":false,"hasA11yHeader":false,"siteSource":{"url":"http://academy.kgtk.ru/it3/ppp/sub-and-function.html","title":{"title":"2.5.3 VBA. Процедуры и функции | Пакеты прикладных...","lines":1},"subtitle":{"path":{"items":[{"text":"academy.kgtk.ru"}],"favicon":{"index":0,"pageNumber":0,"size":"m","entry":"1"}}}},"footer":{"report":{"featureInfo":{"type":"Факт","subtype":"Расширенный факт","fact":{"type":"Расширенный факт","isText":true}},"feature":"","checkBoxLabels":[]},"addonBefore":"На основе информации из источника"},"isGenAnswer":false,"size":"small","footerInFold":false,"baobab":{"parentNode":{"context":{"genInfo":{"prefix":"1_d42fw01-0-1"},"ui":"desktop","service":"web","fast":{"name":"rich_fact"}}}}},"type":"rich_fact"},"1_d42f1":{"state":{"showHint":true,"text":"Быстрый ответ","newSelectors":false,"baobab":{"parentNode":{"context":{"genInfo":{"prefix":"1_d42fw02-0-1"},"ui":"desktop","service":"web","fast":{"name":"fact-header"}}}}},"type":"fact-header"}}
VBA поддерживает два типа пользовательских подпрограмм: процедуры и функции. Их использование существенно упрощает разработку офисных приложений в среде MS Office.
We often use Subs and Functions often not thinking about their true potential and how much we can squeeze out of a regular VBAFunction. Let’s start with a reminder how both differ from each other and then dive into the details. VBA Sub, VBAFunction Syntax.
#VBA #Visio #VisualBasicВ этом видео рассказывается о том, что такое процедуры (Sub) и функции (Function) чем они отличаются, как определяется их область вид...
В отличии от языка VBScript, VBAпроцедуры классифицируются не на два типа (процедура-функция и процедура-подпрограмма), а четырех типов: процедура-функция, процедура-подпрограмма,...
{"2_8dcl":{"state":{"logo":{"lang":"ru","a11yLabel":"Главная страница Яндекса","mordaUrl":"//ya.ru/"},"form":{"action":"/search/","searchLabel":"Найти","hiddenInputs":[{"name":"lr","value":213}]},"actions":{"marketCart":{"url":"https://market.yandex.ru/my/cart?utm_source=serp_header_cart&clid=957&purchase-referrer=serp_cart","goodsCount":0,"ariaLabel":"Маркет"},"advancedSearch":{"checked":false}},"userSection":{"loggedIn":false,"loginProps":{"loginUrl":"https://passport.yandex.ru/auth?retpath=%2F&origin=serp_desktop_auth_new","loginText":"Войти","registrationUrl":"https://passport.yandex.ru/registration?retpath=%2F&origin=serp_desktop_auth_new","registrationText":"Регистрация"}},"navigation":{"tabs":[{"id":"www","label":"Поиск","url":"//ya.ru","params":{"source":"tabbar"},"target":""},{"id":"images","label":"Картинки","url":"/images/search","params":{"text":"[$query]","noreask":"[$noreask]","nomisspell":"[$nomisspell]","parent-reqid":"[$reqid]","from":"tabbar"}},{"id":"video","label":"Видео","url":"/video/search","params":{"text":"[$query]","parent-reqid":"[$reqid]","from":"tabbar"}},{"id":"maps","label":"Карты","url":"/maps","params":{"text":"[$query]","source":"serp_navig"}},{"id":"products","label":"Товары","url":"/products/search","params":{"text":"[$query]","lr":"[$lr]","from":"tabbar"}},{"id":"translate","label":"Переводчик","url":"//translate.yandex.ru","params":{"text":"[$query]","from":"tabbar"}},{"id":"all","label":"Все","url":"/all","params":{"text":"[$query]","from":"tabbar"}}],"selectedTabId":"www","fixedTabsCount":1},"context":{"query":"чем отличается процедура от функции vba","reqid":"1710842019690479-2159719178949890129-balancer-l7leveler-kubr-yp-vla-258-BAL","lr":"213","counters":{"type":"b","data":{"$header":"0_d42fz000","logo":"0_d42fz001","login":"0_d42fz003","register":"0_d42fz004","market-cart":"0_d42fz006","$navigation":"0_d42fz007","item":"0_d42fz00k","tab-www":"0_d42fz009","tab-images":"0_d42fz00b","tab-video":"0_d42fz00d","tab-maps":"0_d42fz00f","tab-products":"0_d42fz00h","tab-translate":"0_d42fz00j","tab-all":"0_d42fz00l"}}},"loggedIn":false,"baobab":{"parentNode":{"context":{"genInfo":{"prefix":"0_d42fw01-0-1"},"ui":"desktop","service":"web","fast":{"name":"header-desktop"}}}}},"type":"header-desktop"},"2_d42f0":{"state":{"i18nTexts":{"durationAriaLabel":"Длительность","freshAriaLabel":"Опубликовано","publishedDateAriaLabel":"Опубликовано"},"clips":[{"thumb":{"image":"//avatars.mds.yandex.net/get-vthumb/1773555/c77ab8217dd8ef01274deeb9866da5b5/176x100","preview":{"type":"video/mp4","url":"https://video-preview.s3.yandex.net/AssEBQAAAAA.mp4"},"isVertical":false},"greenUrlProps":[{"items":[{"text":"YouTube"}],"link":{"url":"http://www.youtube.com/watch?v=Wi9UWybeTIg"}},{"items":[{"text":"Александр Стремнев"}],"link":{"fullText":"Александр Стремнев","url":"/video/search?channelId=d3d3LnlvdXR1YmUuY29tO1VDVEo3Y0lUeVdwZkJCd3VBRUJ2NXNrdw%3D%3D&how=tm&text=%D0%90%D0%BB%D0%B5%D0%BA%D1%81%D0%B0%D0%BD%D0%B4%D1%80+%D0%A1%D1%82%D1%80%D0%B5%D0%BC%D0%BD%D0%B5%D0%B2&path=yandex_search&parent-reqid=1710842019690479-2159719178949890129-balancer-l7leveler-kubr-yp-vla-258-BAL&from_type=vast","logNode":{"name":"channel","attrs":{"attrs":{"clip_channel_data":{"name":"Александр Стремнев","url":"/video/search?channelId=d3d3LnlvdXR1YmUuY29tO1VDVEo3Y0lUeVdwZkJCd3VBRUJ2NXNrdw%3D%3D&how=tm&text=%D0%90%D0%BB%D0%B5%D0%BA%D1%81%D0%B0%D0%BD%D0%B4%D1%80+%D0%A1%D1%82%D1%80%D0%B5%D0%BC%D0%BD%D0%B5%D0%B2","orig_url":"http://www.youtube.com/@user-or9se7qt3d","id":"d3d3LnlvdXR1YmUuY29tO1VDVEo3Y0lUeVdwZkJCd3VBRUJ2NXNrdw=="}}}}}}],"title":"6. \"Основы \u0007[VBA\u0007]: \u0007[Процедуры\u0007] и \u0007[функции\u0007]\"","views":"1,3K","url":"/video/preview/14970712321003183659?text=%D1%87%D0%B5%D0%BC%20%D0%BE%D1%82%D0%BB%D0%B8%D1%87%D0%B0%D0%B5%D1%82%D1%81%D1%8F%20%D0%BF%D1%80%D0%BE%D1%86%D0%B5%D0%B4%D1%83%D1%80%D0%B0%20%D0%BE%D1%82%20%D1%84%D1%83%D0%BD%D0%BA%D1%86%D0%B8%D0%B8%20vba&path=yandex_search&parent-reqid=1710842019690479-2159719178949890129-balancer-l7leveler-kubr-yp-vla-258-BAL&from_type=vast","duration":"27:29","durationA11yText":"Длительность 00:27:29","dateLabelText":"","isFreshDate":false,"counterAttrs":{"duration":1649,"title":"6. \"Основы VBA: Процедуры и функции\"","is_highres":false,"url":["http://www.youtube.com/watch?v=Wi9UWybeTIg"],"creation_time":["2017-06-25T06:37:27.000Z"],"views":[1319],"player":["YouTube"],"ids":["14970712321003183659"]},"isFreshnessColored":true,"isSnippetTitleColorBlack":false,"greenUrlPosition":"BEFORE_INLINE","isChannelWithVerifiedMarkEnabled":true,"publishedDateText":"25 июн 2017"},{"thumb":{"image":"//avatars.mds.yandex.net/get-vthumb/472628/c9d0cf83c83a678dad42e41d334a9951/176x100","preview":{"type":"video/mp4","url":"https://video-preview.s3.yandex.net/X50IcQAAAAA.mp4"},"isVertical":false},"greenUrlProps":[{"items":[{"text":"YouTube"}],"link":{"url":"http://www.youtube.com/v/r5PXGaUG9uY"}},{"items":[{"text":"ROBOTOBOR.PRO ✌ Доступное Программирование"}],"link":{"fullText":"ROBOTOBOR.PRO ✌ Доступное Программирование","url":"/video/search?channelId=d3d3LnlvdXR1YmUuY29tO1VDTndxYzhBRHVUd3lfMHlaTW1PZlQxdw%3D%3D&how=tm&text=ROBOTOBOR.PRO+%E2%9C%8C+%D0%94%D0%BE%D1%81%D1%82%D1%83%D0%BF%D0%BD%D0%BE%D0%B5+%D0%9F%D1%80%D0%BE%D0%B3%D1%80%D0%B0%D0%BC%D0%BC%D0%B8%D1%80%D0%BE%D0%B2%D0%B0%D0%BD%D0%B8%D0%B5&path=yandex_search&parent-reqid=1710842019690479-2159719178949890129-balancer-l7leveler-kubr-yp-vla-258-BAL&from_type=vast","logNode":{"name":"channel","attrs":{"attrs":{"clip_channel_data":{"name":"ROBOTOBOR.PRO ✌ Доступное Программирование","url":"/video/search?channelId=d3d3LnlvdXR1YmUuY29tO1VDTndxYzhBRHVUd3lfMHlaTW1PZlQxdw%3D%3D&how=tm&text=ROBOTOBOR.PRO+%E2%9C%8C+%D0%94%D0%BE%D1%81%D1%82%D1%83%D0%BF%D0%BD%D0%BE%D0%B5+%D0%9F%D1%80%D0%BE%D0%B3%D1%80%D0%B0%D0%BC%D0%BC%D0%B8%D1%80%D0%BE%D0%B2%D0%B0%D0%BD%D0%B8%D0%B5","orig_url":"http://www.youtube.com/@RobotoborPro","id":"d3d3LnlvdXR1YmUuY29tO1VDTndxYzhBRHVUd3lfMHlaTW1PZlQxdw=="}}}}}}],"title":"\u0007[VBA\u0007] Урок_7-1 | \u0007[Процедуры\u0007] и \u0007[Функции\u0007] | Программирование для начинающих Просто и Доступно","views":"22,9K","url":"/video/preview/17184850825312994899?text=%D1%87%D0%B5%D0%BC%20%D0%BE%D1%82%D0%BB%D0%B8%D1%87%D0%B0%D0%B5%D1%82%D1%81%D1%8F%20%D0%BF%D1%80%D0%BE%D1%86%D0%B5%D0%B4%D1%83%D1%80%D0%B0%20%D0%BE%D1%82%20%D1%84%D1%83%D0%BD%D0%BA%D1%86%D0%B8%D0%B8%20vba&path=yandex_search&parent-reqid=1710842019690479-2159719178949890129-balancer-l7leveler-kubr-yp-vla-258-BAL&from_type=vast","duration":"37:12","durationA11yText":"Длительность 00:37:12","dateLabelText":"","isFreshDate":false,"counterAttrs":{"duration":2232,"title":"VBA Урок_7-1 | Процедуры и Функции | Программирование для начинающих Просто и Доступно","is_highres":false,"url":["http://www.youtube.com/v/r5PXGaUG9uY"],"creation_time":["2015-03-06T07:00:00.000Z"],"views":[22862],"player":["YouTube"],"ids":["17184850825312994899"]},"summary":{"fullTextUrl":"/video/result?ask_summarization=1&numdoc=1&noreask=1&nomisspell=1&parent-reqid=1710842019690479-2159719178949890129-balancer-l7leveler-kubr-yp-vla-258-BAL&text=videoid:17184850825312994899","linkTemplate":"/video/preview/17184850825312994899?text=%D1%87%D0%B5%D0%BC%20%D0%BE%D1%82%D0%BB%D0%B8%D1%87%D0%B0%D0%B5%D1%82%D1%81%D1%8F%20%D0%BF%D1%80%D0%BE%D1%86%D0%B5%D0%B4%D1%83%D1%80%D0%B0%20%D0%BE%D1%82%20%D1%84%D1%83%D0%BD%D0%BA%D1%86%D0%B8%D0%B8%20vba&path=yandex_search&parent-reqid=1710842019690479-2159719178949890129-balancer-l7leveler-kubr-yp-vla-258-BAL&from_type=vast&source=summary&ask_summarization=1&t=%%timestamp%%","target":"_blank"},"isFreshnessColored":true,"isSnippetTitleColorBlack":false,"greenUrlPosition":"BEFORE_INLINE","isChannelWithVerifiedMarkEnabled":true,"publishedDateText":" 6 мар 2015"},{"thumb":{"image":"//avatars.mds.yandex.net/get-vthumb/2386527/4e0fbcffb03ce7c4ca4e12ca58e00494/176x100","preview":{"type":"video/mp4","url":"https://video-preview.s3.yandex.net/EFHhEgEAAAA.mp4"},"isVertical":false},"greenUrlProps":[{"items":[{"text":"YouTube"}],"link":{"url":"http://www.youtube.com/watch?v=9py0lDu5r8U"}},{"items":[{"text":"Vigil IT-video"}],"link":{"fullText":"Vigil IT-video","url":"/video/search?channelId=d3d3LnlvdXR1YmUuY29tO1VDV2xxRlBXQUtuRjYxblJ4cnRrMjhkdw%3D%3D&how=tm&text=Vigil+IT-video&path=yandex_search&parent-reqid=1710842019690479-2159719178949890129-balancer-l7leveler-kubr-yp-vla-258-BAL&from_type=vast","logNode":{"name":"channel","attrs":{"attrs":{"clip_channel_data":{"name":"Vigil IT-video","url":"/video/search?channelId=d3d3LnlvdXR1YmUuY29tO1VDV2xxRlBXQUtuRjYxblJ4cnRrMjhkdw%3D%3D&how=tm&text=Vigil+IT-video","orig_url":"http://www.youtube.com/channel/UCWlqFPWAKnF61nRxrtk28dw","id":"d3d3LnlvdXR1YmUuY29tO1VDV2xxRlBXQUtuRjYxblJ4cnRrMjhkdw=="}}}}}}],"title":"Visio+\u0007[VBA\u0007] | #6 \u0007[Процедуры\u0007] и \u0007[функции\u0007]","views":"1,3K","url":"/video/preview/14736760456526086988?text=%D1%87%D0%B5%D0%BC%20%D0%BE%D1%82%D0%BB%D0%B8%D1%87%D0%B0%D0%B5%D1%82%D1%81%D1%8F%20%D0%BF%D1%80%D0%BE%D1%86%D0%B5%D0%B4%D1%83%D1%80%D0%B0%20%D0%BE%D1%82%20%D1%84%D1%83%D0%BD%D0%BA%D1%86%D0%B8%D0%B8%20vba&path=yandex_search&parent-reqid=1710842019690479-2159719178949890129-balancer-l7leveler-kubr-yp-vla-258-BAL&from_type=vast","duration":"16:53","durationA11yText":"Длительность 00:16:53","dateLabelText":"","isFreshDate":false,"counterAttrs":{"duration":1013,"title":"Visio+VBA | #6 Процедуры и функции","is_highres":false,"url":["http://www.youtube.com/watch?v=9py0lDu5r8U"],"creation_time":["2019-08-11T01:58:12.000Z"],"views":[1319],"player":["YouTube"],"ids":["14736760456526086988"]},"isFreshnessColored":true,"isSnippetTitleColorBlack":false,"greenUrlPosition":"BEFORE_INLINE","isChannelWithVerifiedMarkEnabled":true,"publishedDateText":"11 авг 2019"},{"thumb":{"image":"//avatars.mds.yandex.net/get-vthumb/2976332/13a7f9e501285dcc4e52c30bc9286e34/176x100","preview":{"type":"video/mp4","url":"https://video-preview.s3.yandex.net/VlxudQAAAAA.mp4"},"isVertical":false},"greenUrlProps":[{"items":[{"text":"YouTube"}],"link":{"url":"http://www.youtube.com/watch?v=oRPL49rLQec"}},{"items":[{"text":"Геннадий Никифоров"}],"link":{"fullText":"Геннадий Никифоров","url":"/video/search?channelId=d3d3LnlvdXR1YmUuY29tO1VDMUhuZ2RlTk1aSkp2T3pyTWtTMk1NZw%3D%3D&how=tm&text=%D0%93%D0%B5%D0%BD%D0%BD%D0%B0%D0%B4%D0%B8%D0%B9+%D0%9D%D0%B8%D0%BA%D0%B8%D1%84%D0%BE%D1%80%D0%BE%D0%B2&path=yandex_search&parent-reqid=1710842019690479-2159719178949890129-balancer-l7leveler-kubr-yp-vla-258-BAL&from_type=vast","logNode":{"name":"channel","attrs":{"attrs":{"clip_channel_data":{"name":"Геннадий Никифоров","url":"/video/search?channelId=d3d3LnlvdXR1YmUuY29tO1VDMUhuZ2RlTk1aSkp2T3pyTWtTMk1NZw%3D%3D&how=tm&text=%D0%93%D0%B5%D0%BD%D0%BD%D0%B0%D0%B4%D0%B8%D0%B9+%D0%9D%D0%B8%D0%BA%D0%B8%D1%84%D0%BE%D1%80%D0%BE%D0%B2","orig_url":"http://www.youtube.com/@user-yb4hs6lp4g","id":"d3d3LnlvdXR1YmUuY29tO1VDMUhuZ2RlTk1aSkp2T3pyTWtTMk1NZw=="}}}}}}],"title":"18 \u0007[VBA\u0007] \u0007[Процедура\u0007] \u0007[Function\u0007] и \u0007[процедура\u0007] Sub","views":"","url":"/video/preview/1463876695513512768?text=%D1%87%D0%B5%D0%BC%20%D0%BE%D1%82%D0%BB%D0%B8%D1%87%D0%B0%D0%B5%D1%82%D1%81%D1%8F%20%D0%BF%D1%80%D0%BE%D1%86%D0%B5%D0%B4%D1%83%D1%80%D0%B0%20%D0%BE%D1%82%20%D1%84%D1%83%D0%BD%D0%BA%D1%86%D0%B8%D0%B8%20vba&path=yandex_search&parent-reqid=1710842019690479-2159719178949890129-balancer-l7leveler-kubr-yp-vla-258-BAL&from_type=vast","duration":"4:20","durationA11yText":"Длительность 00:04:20","dateLabelText":"","isFreshDate":false,"counterAttrs":{"duration":260,"title":"18 VBA Процедура Function и процедура Sub","is_highres":false,"url":["http://www.youtube.com/watch?v=oRPL49rLQec"],"creation_time":["2018-06-24T07:00:00.000Z"],"views":[43],"player":["YouTube"],"ids":["1463876695513512768"]},"isFreshnessColored":true,"isSnippetTitleColorBlack":false,"greenUrlPosition":"BEFORE_INLINE","isChannelWithVerifiedMarkEnabled":true,"publishedDateText":"24 июн 2018"},{"thumb":{"image":"//avatars.mds.yandex.net/get-vthumb/1594462/59f449d3057d98b97d34a3945458955f/176x100","preview":{"type":"video/mp4","url":"https://video-preview.s3.yandex.net/x16esAAAAAA.mp4"},"isVertical":false},"greenUrlProps":[{"items":[{"text":"YouTube"}],"link":{"url":"http://www.youtube.com/watch?v=CKZhcJDBhY4"}},{"items":[{"text":"Vigil IT-video"}],"link":{"fullText":"Vigil IT-video","url":"/video/search?channelId=d3d3LnlvdXR1YmUuY29tO1VDV2xxRlBXQUtuRjYxblJ4cnRrMjhkdw%3D%3D&how=tm&text=Vigil+IT-video&path=yandex_search&parent-reqid=1710842019690479-2159719178949890129-balancer-l7leveler-kubr-yp-vla-258-BAL&from_type=vast","logNode":{"name":"channel","attrs":{"attrs":{"clip_channel_data":{"name":"Vigil IT-video","url":"/video/search?channelId=d3d3LnlvdXR1YmUuY29tO1VDV2xxRlBXQUtuRjYxblJ4cnRrMjhkdw%3D%3D&how=tm&text=Vigil+IT-video","orig_url":"http://www.youtube.com/@vigilit-video1765","id":"d3d3LnlvdXR1YmUuY29tO1VDV2xxRlBXQUtuRjYxblJ4cnRrMjhkdw=="}}}}}}],"title":"Visio+\u0007[VBA\u0007] | #7 Аргументы \u0007[процедур\u0007] и \u0007[функций\u0007]","views":"","url":"/video/preview/11635671433308162146?text=%D1%87%D0%B5%D0%BC%20%D0%BE%D1%82%D0%BB%D0%B8%D1%87%D0%B0%D0%B5%D1%82%D1%81%D1%8F%20%D0%BF%D1%80%D0%BE%D1%86%D0%B5%D0%B4%D1%83%D1%80%D0%B0%20%D0%BE%D1%82%20%D1%84%D1%83%D0%BD%D0%BA%D1%86%D0%B8%D0%B8%20vba&path=yandex_search&parent-reqid=1710842019690479-2159719178949890129-balancer-l7leveler-kubr-yp-vla-258-BAL&from_type=vast","duration":"10:19","durationA11yText":"Длительность 00:10:19","dateLabelText":"","isFreshDate":false,"counterAttrs":{"duration":619,"title":"Visio+VBA | #7 Аргументы процедур и функций","is_highres":false,"url":["http://www.youtube.com/watch?v=CKZhcJDBhY4"],"creation_time":["2019-08-10T07:25:28.000Z"],"views":[429],"player":["YouTube"],"ids":["11635671433308162146"]},"summary":{"fullTextUrl":"/video/result?ask_summarization=1&numdoc=1&noreask=1&nomisspell=1&parent-reqid=1710842019690479-2159719178949890129-balancer-l7leveler-kubr-yp-vla-258-BAL&text=videoid:11635671433308162146","linkTemplate":"/video/preview/11635671433308162146?text=%D1%87%D0%B5%D0%BC%20%D0%BE%D1%82%D0%BB%D0%B8%D1%87%D0%B0%D0%B5%D1%82%D1%81%D1%8F%20%D0%BF%D1%80%D0%BE%D1%86%D0%B5%D0%B4%D1%83%D1%80%D0%B0%20%D0%BE%D1%82%20%D1%84%D1%83%D0%BD%D0%BA%D1%86%D0%B8%D0%B8%20vba&path=yandex_search&parent-reqid=1710842019690479-2159719178949890129-balancer-l7leveler-kubr-yp-vla-258-BAL&from_type=vast&source=summary&ask_summarization=1&t=%%timestamp%%","target":"_blank"},"isFreshnessColored":true,"isSnippetTitleColorBlack":false,"greenUrlPosition":"BEFORE_INLINE","isChannelWithVerifiedMarkEnabled":true,"publishedDateText":"10 авг 2019"},{"thumb":{"image":"//avatars.mds.yandex.net/get-vthumb/2924127/ad53179c5058205dfb38d41cbfe9ac7e/176x100","preview":{"type":"video/mp4","url":"https://video-preview.s3.yandex.net/g3QioQAAAAA.mp4"},"isVertical":false},"greenUrlProps":[{"items":[{"text":"YouTube"}],"link":{"url":"http://www.youtube.com/watch?v=SUIevMPoOro"}},{"items":[{"text":"ProExcel"}],"link":{"fullText":"ProExcel","url":"/video/search?channelId=d3d3LnlvdXR1YmUuY29tO1VDV0VDa2hWZjRseGozMmVDQ05nT0FCQQ%3D%3D&how=tm&text=ProExcel&path=yandex_search&parent-reqid=1710842019690479-2159719178949890129-balancer-l7leveler-kubr-yp-vla-258-BAL&from_type=vast","logNode":{"name":"channel","attrs":{"attrs":{"clip_channel_data":{"name":"ProExcel","url":"/video/search?channelId=d3d3LnlvdXR1YmUuY29tO1VDV0VDa2hWZjRseGozMmVDQ05nT0FCQQ%3D%3D&how=tm&text=ProExcel","orig_url":"https://www.youtube.com/channel/UCWECkhVf4lxj32eCCNgOABA","id":"d3d3LnlvdXR1YmUuY29tO1VDV0VDa2hWZjRseGozMmVDQ05nT0FCQQ=="}}}}}}],"title":"Области видимости \u0007[процедур\u0007] и \u0007[функций\u0007] в \u0007[VBA\u0007]","views":"","url":"/video/preview/6686214776491220119?text=%D1%87%D0%B5%D0%BC%20%D0%BE%D1%82%D0%BB%D0%B8%D1%87%D0%B0%D0%B5%D1%82%D1%81%D1%8F%20%D0%BF%D1%80%D0%BE%D1%86%D0%B5%D0%B4%D1%83%D1%80%D0%B0%20%D0%BE%D1%82%20%D1%84%D1%83%D0%BD%D0%BA%D1%86%D0%B8%D0%B8%20vba&path=yandex_search&parent-reqid=1710842019690479-2159719178949890129-balancer-l7leveler-kubr-yp-vla-258-BAL&from_type=vast","duration":"20:59","durationA11yText":"Длительность 00:20:59","dateLabelText":"","isFreshDate":false,"counterAttrs":{"duration":1259,"title":"Области видимости процедур и функций в VBA","is_highres":false,"url":["http://www.youtube.com/watch?v=SUIevMPoOro"],"creation_time":["2014-03-07T19:59:21.000Z"],"views":[497],"player":["YouTube"],"ids":["6686214776491220119"]},"summary":{"fullTextUrl":"/video/result?ask_summarization=1&numdoc=1&noreask=1&nomisspell=1&parent-reqid=1710842019690479-2159719178949890129-balancer-l7leveler-kubr-yp-vla-258-BAL&text=videoid:6686214776491220119","linkTemplate":"/video/preview/6686214776491220119?text=%D1%87%D0%B5%D0%BC%20%D0%BE%D1%82%D0%BB%D0%B8%D1%87%D0%B0%D0%B5%D1%82%D1%81%D1%8F%20%D0%BF%D1%80%D0%BE%D1%86%D0%B5%D0%B4%D1%83%D1%80%D0%B0%20%D0%BE%D1%82%20%D1%84%D1%83%D0%BD%D0%BA%D1%86%D0%B8%D0%B8%20vba&path=yandex_search&parent-reqid=1710842019690479-2159719178949890129-balancer-l7leveler-kubr-yp-vla-258-BAL&from_type=vast&source=summary&ask_summarization=1&t=%%timestamp%%","target":"_blank"},"isFreshnessColored":true,"isSnippetTitleColorBlack":false,"greenUrlPosition":"BEFORE_INLINE","isChannelWithVerifiedMarkEnabled":true,"publishedDateText":" 7 мар 2014"}],"header":{"title":"Видео","favicon":{"index":1,"pageNumber":0,"size":"m"},"extralinks":{"items":[{"variant":"reportFeedback","reportFeedback":{"feature":"Тематический блок видео","checkBoxLabels":[{"value":"Несоответствие запросу"},{"value":"Шокирующая или неприятная информация"},{"value":"Порнография"},{"value":"Видео не воспроизводится"},{"value":"Другое"}],"selectParams":{"fieldName":"Заголовок видео","items":["6. \"Основы VBA: Процедуры и функции\"","VBA Урок_7-1 | Процедуры и Функции | Программирование для начинающих Просто и Доступно","Visio+VBA | #6 Процедуры и функции","18 VBA Процедура Function и процедура Sub","Visio+VBA | #7 Аргументы процедур и функций","Области видимости процедур и функций в VBA"]},"customMetaFields":[{"name":"docId","value":"7"},{"name":"queryString","value":"text=%D1%87%D0%B5%D0%BC%20%D0%BE%D1%82%D0%BB%D0%B8%D1%87%D0%B0%D0%B5%D1%82%D1%81%D1%8F%20%D0%BF%D1%80%D0%BE%D1%86%D0%B5%D0%B4%D1%83%D1%80%D0%B0%20%D0%BE%D1%82%20%D1%84%D1%83%D0%BD%D0%BA%D1%86%D0%B8%D0%B8%20vba&path=yandex_search&parent-reqid=1710842019690479-2159719178949890129-balancer-l7leveler-kubr-yp-vla-258-BAL&from_type=vast"},{"name":"feedback_region","value":"102820"},{"name":"1. 6. \"Основы VBA: Процедуры и функции\"","value":"yandex.ru/video/preview/14970712321003183659"},{"name":"2. VBA Урок_7-1 | Процедуры и Функции | Программирование для начинающих Просто и Доступно","value":"yandex.ru/video/preview/17184850825312994899"},{"name":"3. Visio+VBA | #6 Процедуры и функции","value":"yandex.ru/video/preview/14736760456526086988"},{"name":"4. 18 VBA Процедура Function и процедура Sub","value":"yandex.ru/video/preview/1463876695513512768"},{"name":"5. Visio+VBA | #7 Аргументы процедур и функций","value":"yandex.ru/video/preview/11635671433308162146"},{"name":"6. Области видимости процедур и функций в VBA","value":"yandex.ru/video/preview/6686214776491220119"}]}}],"hidden":true}},"footer":{"moreText":"Смотреть все видео"},"videoSearchHref":"/video/search?text=%D1%87%D0%B5%D0%BC%20%D0%BE%D1%82%D0%BB%D0%B8%D1%87%D0%B0%D0%B5%D1%82%D1%81%D1%8F%20%D0%BF%D1%80%D0%BE%D1%86%D0%B5%D0%B4%D1%83%D1%80%D0%B0%20%D0%BE%D1%82%20%D1%84%D1%83%D0%BD%D0%BA%D1%86%D0%B8%D0%B8%20vba&path=yandex_search&parent-reqid=1710842019690479-2159719178949890129-balancer-l7leveler-kubr-yp-vla-258-BAL&from_type=vast","isAdultContent":false,"autoPreviewDisable":false,"reportFeedbackBaseProps":{"initEmail":"","metaFields":{"userAgent":"claudebot","userTestids":"974402,186144,986325,983732,928406,967708,988257,986669,986800,988013,974982,982160,984942,979944,985818,974186,982702,975947,985862,984885,986796,27392,986818,936724,988933,985166,986794,984329,986171,988445,984886,988372,963713,985307,973520,959007,989322,980806,133992,986611,988770,89013,981221,977969,966250,982213,986847,982552,986353,981746,263461,255406,987013,977764,461653,986672,986770,929870,972620,912217,987050,332148,970696,975102,986115,983213,151171,126283,13963,287509,957805,987130,338390,785125,951491,988999,989610,976039,978190,979201,986155,982456,981397,969819,975226,970494","yandexuid":"6498901291710842019","uid":"0","queryText":"чем отличается процедура от функции vba","reqid":"1710842019690479-2159719178949890129-balancer-l7leveler-kubr-yp-vla-258-BAL","searchSlices":["drawer_search_slice_education","drawer_search_slice_cs"],"userRegionName":"Ashburn","userRegionId":"102820"}},"baobab":{"parentNode":{"context":{"genInfo":{"prefix":"2_d42fw02-0-1"},"ui":"desktop","service":"web","fast":{"name":"video-unisearch","subtype":"vast"}}}}},"type":"video-unisearch","subtype":"vast"},"2_d42f1":{"state":{"queryUrl":"/images/search?text=%D1%87%D0%B5%D0%BC%20%D0%BE%D1%82%D0%BB%D0%B8%D1%87%D0%B0%D0%B5%D1%82%D1%81%D1%8F%20%D0%BF%D1%80%D0%BE%D1%86%D0%B5%D0%B4%D1%83%D1%80%D0%B0%20%D0%BE%D1%82%20%D1%84%D1%83%D0%BD%D0%BA%D1%86%D0%B8%D0%B8%20vba&stype=image&lr=213&parent-reqid=1710842019690479-2159719178949890129-balancer-l7leveler-kubr-yp-vla-258-BAL&source=serp","favicon":{"index":2,"pageNumber":0,"size":"m"},"images":[{"src":"//avatars.mds.yandex.net/i?id=3d18771b8c6d80d7d3b4b547dbb7e04737bd7786-10639895-images-thumbs&n=13","width":153.4,"height":115,"url":"/images/search?text=%D1%87%D0%B5%D0%BC+%D0%BE%D1%82%D0%BB%D0%B8%D1%87%D0%B0%D0%B5%D1%82%D1%81%D1%8F+%D0%BF%D1%80%D0%BE%D1%86%D0%B5%D0%B4%D1%83%D1%80%D0%B0+%D0%BE%D1%82+%D1%84%D1%83%D0%BD%D0%BA%D1%86%D0%B8%D0%B8+vba&img_url=https%3A%2F%2Fcf.ppt-online.org%2Ffiles1%2Fslide%2Fy%2FypohSHCwIAgTOLrzQ4V19k2tmvP5cYu7B8biWxRXU%2Fslide-20.jpg&pos=0&rpt=simage&stype=image&lr=213&parent-reqid=1710842019690479-2159719178949890129-balancer-l7leveler-kubr-yp-vla-258-BAL&source=serp","globalId":"3d18771b8c6d80d7d3b4b547dbb7e04737bd7786-10639895-images-thumbs","docid":"Z1DFE1FDDE25B1B9A","crc":"941027395565787297","label":"Картинка Определяемые пользователем функции vba и подпрограммы","origWidth":1024,"origHeight":767,"narrow":false},{"src":"//avatars.mds.yandex.net/i?id=46f0492ee820946b5c0b375385241211ef138ce0-9107083-images-thumbs&n=13","width":153.4,"height":115,"url":"/images/search?text=%D1%87%D0%B5%D0%BC+%D0%BE%D1%82%D0%BB%D0%B8%D1%87%D0%B0%D0%B5%D1%82%D1%81%D1%8F+%D0%BF%D1%80%D0%BE%D1%86%D0%B5%D0%B4%D1%83%D1%80%D0%B0+%D0%BE%D1%82+%D1%84%D1%83%D0%BD%D0%BA%D1%86%D0%B8%D0%B8+vba&img_url=https%3A%2F%2Fcf.ppt-online.org%2Ffiles1%2Fslide%2Ft%2Ft8GaRvq0xdhHAoV97p2UI15BTfMOSiPrwKsEcjZFm%2Fslide-17.jpg&pos=1&rpt=simage&stype=image&lr=213&parent-reqid=1710842019690479-2159719178949890129-balancer-l7leveler-kubr-yp-vla-258-BAL&source=serp","globalId":"46f0492ee820946b5c0b375385241211ef138ce0-9107083-images-thumbs","docid":"Z9263985758CE3435","crc":"15201863126433441086","label":"Картинка Определяемые пользователем функции vba и подпрограммы","origWidth":1024,"origHeight":767,"narrow":false},{"src":"//avatars.mds.yandex.net/i?id=24ccf2a6e0df93e4487704f5dcb277577304898a-10948701-images-thumbs&n=13","width":153.4,"height":115,"url":"/images/search?text=%D1%87%D0%B5%D0%BC+%D0%BE%D1%82%D0%BB%D0%B8%D1%87%D0%B0%D0%B5%D1%82%D1%81%D1%8F+%D0%BF%D1%80%D0%BE%D1%86%D0%B5%D0%B4%D1%83%D1%80%D0%B0+%D0%BE%D1%82+%D1%84%D1%83%D0%BD%D0%BA%D1%86%D0%B8%D0%B8+vba&img_url=https%3A%2F%2Fvvk-yar.ru%2Fwp-content%2Fuploads%2F1%2F2%2Ff%2F12fce2c796623cec47f0fcd2c5120577.jpeg&pos=2&rpt=simage&stype=image&lr=213&parent-reqid=1710842019690479-2159719178949890129-balancer-l7leveler-kubr-yp-vla-258-BAL&source=serp","globalId":"24ccf2a6e0df93e4487704f5dcb277577304898a-10948701-images-thumbs","docid":"Z2F07178AB7F19BDE","crc":"13632395320090141870","label":"Картинка Vba excel. функции преобразования типов","origWidth":1024,"origHeight":767,"narrow":false},{"src":"//avatars.mds.yandex.net/i?id=b848991fdfffd85596264a7795d65e7ae42a1020-8087945-images-thumbs&n=13","width":185,"height":115,"url":"/images/search?text=%D1%87%D0%B5%D0%BC+%D0%BE%D1%82%D0%BB%D0%B8%D1%87%D0%B0%D0%B5%D1%82%D1%81%D1%8F+%D0%BF%D1%80%D0%BE%D1%86%D0%B5%D0%B4%D1%83%D1%80%D0%B0+%D0%BE%D1%82+%D1%84%D1%83%D0%BD%D0%BA%D1%86%D0%B8%D0%B8+vba&img_url=https%3A%2F%2Fbringwell.ru%2Fwp-content%2Fuploads%2F8%2F1%2Fa%2F81a744e635afa3bd0fcee0b7f98fdc87.png&pos=3&rpt=simage&stype=image&lr=213&parent-reqid=1710842019690479-2159719178949890129-balancer-l7leveler-kubr-yp-vla-258-BAL&source=serp","globalId":"b848991fdfffd85596264a7795d65e7ae42a1020-8087945-images-thumbs","docid":"ZA6FD7D45055CE3FA","crc":"5815950341250017325","label":"Картинка Vba excel. функция format (синтаксис, параметры, примеры)","origWidth":857,"origHeight":521,"narrow":false},{"src":"//avatars.mds.yandex.net/i?id=eef9a8d1f7e029a327bf2530614778c84bf49ac6-9685031-images-thumbs&n=13","width":153.4,"height":115,"url":"/images/search?text=%D1%87%D0%B5%D0%BC+%D0%BE%D1%82%D0%BB%D0%B8%D1%87%D0%B0%D0%B5%D1%82%D1%81%D1%8F+%D0%BF%D1%80%D0%BE%D1%86%D0%B5%D0%B4%D1%83%D1%80%D0%B0+%D0%BE%D1%82+%D1%84%D1%83%D0%BD%D0%BA%D1%86%D0%B8%D0%B8+vba&img_url=https%3A%2F%2Fpresent5.com%2Fpresentation%2F3%2F131911407_80478088.pdf-img%2F131911407_80478088.pdf-24.jpg&pos=4&rpt=simage&stype=image&lr=213&parent-reqid=1710842019690479-2159719178949890129-balancer-l7leveler-kubr-yp-vla-258-BAL&source=serp","globalId":"eef9a8d1f7e029a327bf2530614778c84bf49ac6-9685031-images-thumbs","docid":"Z6BD7A7C63DA7C57D","crc":"9465159649937073356","label":"Картинка Создание и использование функций и функций-процедур VBA","origWidth":720,"origHeight":540,"narrow":false},{"src":"//avatars.mds.yandex.net/i?id=db252a724d37babed6185aade63da182c2af3494-9065825-images-thumbs&n=13","width":166.3,"height":115,"url":"/images/search?text=%D1%87%D0%B5%D0%BC+%D0%BE%D1%82%D0%BB%D0%B8%D1%87%D0%B0%D0%B5%D1%82%D1%81%D1%8F+%D0%BF%D1%80%D0%BE%D1%86%D0%B5%D0%B4%D1%83%D1%80%D0%B0+%D0%BE%D1%82+%D1%84%D1%83%D0%BD%D0%BA%D1%86%D0%B8%D0%B8+vba&img_url=https%3A%2F%2Fcf.ppt-online.org%2Ffiles%2Fslide%2Fs%2Fs8a5Ce6Kl9Om20SAHR4gqkDGLXjnwVUfyEMdcB%2Fslide-113.jpg&pos=5&rpt=simage&stype=image&lr=213&parent-reqid=1710842019690479-2159719178949890129-balancer-l7leveler-kubr-yp-vla-258-BAL&source=serp","globalId":"db252a724d37babed6185aade63da182c2af3494-9065825-images-thumbs","docid":"ZA7687FD1D49B83F9","crc":"12750408401372144251","label":"Картинка Язык программирования VBA - презентация онлайн","origWidth":1024,"origHeight":708,"narrow":false,"lazy":true},{"src":"//avatars.mds.yandex.net/i?id=6f52523d9963b1a2b48a8d4aed45c56fc8d26869-9185952-images-thumbs&n=13","width":166.3,"height":115,"url":"/images/search?text=%D1%87%D0%B5%D0%BC+%D0%BE%D1%82%D0%BB%D0%B8%D1%87%D0%B0%D0%B5%D1%82%D1%81%D1%8F+%D0%BF%D1%80%D0%BE%D1%86%D0%B5%D0%B4%D1%83%D1%80%D0%B0+%D0%BE%D1%82+%D1%84%D1%83%D0%BD%D0%BA%D1%86%D0%B8%D0%B8+vba&img_url=https%3A%2F%2Fwudgleyd.ru%2Fwp-content%2Fuploads%2F0%2F4%2F6%2F046cb053905378303429f3a27ceac9d3.jpeg&pos=6&rpt=simage&stype=image&lr=213&parent-reqid=1710842019690479-2159719178949890129-balancer-l7leveler-kubr-yp-vla-258-BAL&source=serp","globalId":"6f52523d9963b1a2b48a8d4aed45c56fc8d26869-9185952-images-thumbs","docid":"Z0466D5CE0E340B36","crc":"16207958900766172228","label":"Картинка Определяемые пользователем функции vba и подпрограммы","origWidth":1024,"origHeight":708,"narrow":false,"lazy":true},{"src":"//avatars.mds.yandex.net/i?id=db130e3737e6eb6a5e240beec89f973dc9a01538-8376360-images-thumbs&n=13","width":181.5,"height":115,"url":"/images/search?text=%D1%87%D0%B5%D0%BC+%D0%BE%D1%82%D0%BB%D0%B8%D1%87%D0%B0%D0%B5%D1%82%D1%81%D1%8F+%D0%BF%D1%80%D0%BE%D1%86%D0%B5%D0%B4%D1%83%D1%80%D0%B0+%D0%BE%D1%82+%D1%84%D1%83%D0%BD%D0%BA%D1%86%D0%B8%D0%B8+vba&img_url=https%3A%2F%2Fpandia.ru%2Ftext%2F80%2F482%2Fimages%2Fimg8_30.png&pos=7&rpt=simage&stype=image&lr=213&parent-reqid=1710842019690479-2159719178949890129-balancer-l7leveler-kubr-yp-vla-258-BAL&source=serp","globalId":"db130e3737e6eb6a5e240beec89f973dc9a01538-8376360-images-thumbs","docid":"ZF5B3A041E7912C44","crc":"7941943818311403627","label":"Картинка Проект vba что это - 82 фото","origWidth":960,"origHeight":607,"narrow":false,"lazy":true},{"src":"//avatars.mds.yandex.net/i?id=e9e0a0020576102795a1ef898f2e7a17c5e2f68d-9181306-images-thumbs&n=13","width":166.3,"height":115,"url":"/images/search?text=%D1%87%D0%B5%D0%BC+%D0%BE%D1%82%D0%BB%D0%B8%D1%87%D0%B0%D0%B5%D1%82%D1%81%D1%8F+%D0%BF%D1%80%D0%BE%D1%86%D0%B5%D0%B4%D1%83%D1%80%D0%B0+%D0%BE%D1%82+%D1%84%D1%83%D0%BD%D0%BA%D1%86%D0%B8%D0%B8+vba&img_url=https%3A%2F%2Fcf.ppt-online.org%2Ffiles1%2Fslide%2Ft%2FT4CiKgMt5GAXNmWofvejuL2EzPUY8hq371prxD%2Fslide-107.jpg&pos=8&rpt=simage&stype=image&lr=213&parent-reqid=1710842019690479-2159719178949890129-balancer-l7leveler-kubr-yp-vla-258-BAL&source=serp","globalId":"e9e0a0020576102795a1ef898f2e7a17c5e2f68d-9181306-images-thumbs","docid":"Z36C164DAE7539CE1","crc":"5995807679788083349","label":"Картинка Язык программирования VBA - презентация онлайн","origWidth":1024,"origHeight":708,"narrow":false,"lazy":true},{"src":"//avatars.mds.yandex.net/i?id=9c26677005207d288de3a20458973fbce608ce90-3749333-images-thumbs&n=13","width":153.4,"height":115,"url":"/images/search?text=%D1%87%D0%B5%D0%BC+%D0%BE%D1%82%D0%BB%D0%B8%D1%87%D0%B0%D0%B5%D1%82%D1%81%D1%8F+%D0%BF%D1%80%D0%BE%D1%86%D0%B5%D0%B4%D1%83%D1%80%D0%B0+%D0%BE%D1%82+%D1%84%D1%83%D0%BD%D0%BA%D1%86%D0%B8%D0%B8+vba&img_url=https%3A%2F%2Fthepresentation.ru%2Fimg%2Ftmb%2F2%2F191042%2F53a816fe1483ac31d8ea2f2c5f6ba977-800x.jpg&pos=9&rpt=simage&stype=image&lr=213&parent-reqid=1710842019690479-2159719178949890129-balancer-l7leveler-kubr-yp-vla-258-BAL&source=serp","globalId":"9c26677005207d288de3a20458973fbce608ce90-3749333-images-thumbs","docid":"Z8D9E7FD5B27EF047","crc":"12827620768128699769","label":"Картинка Презентация на тему: \"Визуальное программирование Visual","origWidth":800,"origHeight":600,"narrow":false,"lazy":true}],"rowsCount":1,"serverWidth":536,"context":{},"extralinks":{"feedback":{"feature":"Колдунщик картинок","checkBoxLabels":[{"value":"Несоответствие запросу"},{"value":"Порнография"},{"value":"Шокирующая или неприятная информация"},{"value":"Недостоверная информация"},{"value":"Удалите мое фото"},{"value":"Другое"}],"customMetaFields":[{"name":"docId","value":"8"}]},"directions":["bottom-end"],"hidden":true},"ajaxContext":{"subtype":"intent_scroller","viewType":{"rows":1}},"title":"Картинки","baobab":{"parentNode":{"context":{"genInfo":{"prefix":"2_d42fw03-0-1"},"ui":"desktop","service":"web","fast":{"name":"images","subtype":"intent"}}}}},"type":"images","subtype":"intent_scroller"},"2_d42f2":{"state":{"thumbWidth":198,"thumbHeight":113,"videoPreviewHref":"/video/preview/14736760456526086988?text=%D1%87%D0%B5%D0%BC%20%D0%BE%D1%82%D0%BB%D0%B8%D1%87%D0%B0%D0%B5%D1%82%D1%81%D1%8F%20%D0%BF%D1%80%D0%BE%D1%86%D0%B5%D0%B4%D1%83%D1%80%D0%B0%20%D0%BE%D1%82%20%D1%84%D1%83%D0%BD%D0%BA%D1%86%D0%B8%D0%B8%20vba&path=search_snippet&parent-reqid=1710842019690479-2159719178949890129-balancer-l7leveler-kubr-yp-vla-258-BAL&from_type=snip-videothumb","internalLinksTarget":"_blank","posterSrc":"//avatars.mds.yandex.net/get-vthumb/2386527/4e0fbcffb03ce7c4ca4e12ca58e00494/564x318","videoSrc":"https://video-preview.s3.yandex.net/EFHhEgEAAAA.mp4","videoType":"video/mp4","duration":"16:53","isAdultContent":false,"isVertical":false,"logNode":{"name":"video","attrs":{"externalId":{"entity":"video","id":"14736760456526086988"},"hasVideoViewerLink":true,"hasFilmId":true}},"organicVideoMeta":{"created":"11 авг 2019","views":"1 тыс. просмотров"},"i18nTexts":{"durationAriaLabel":"Длительность","freshAriaLabel":"Опубликовано"},"baobab":{"parentNode":{"context":{"genInfo":{"prefix":"2_d42fw0b-0-1"},"ui":"desktop","service":"web","organic":1}}}},"type":"organic"},"2_d42f3":{"state":{"src":"//yandex.ru/ads/system/context.js","blockId":"R-I-1644736-3","rawGrab":"чем отличается процедура от функции vba","subtype":"rsya_guarantee","nonceId":"8492","needOwnResult":true,"needSendLayoutCoords":true,"extParams":{"reqId":"1710842019690479-2159719178949890129-balancer-l7leveler-kubr-yp-vla-258-BAL"},"initStrategy":"mediaquery","baobab":{"parentNode":{"context":{"genInfo":{"prefix":"2_d42fw0f-0-1"},"ui":"desktop","service":"web","fast":{"name":"adv","subtype":"rsya_guarantee"}}}}},"type":"adv","subtype":"rsya_guarantee"},"2_d42f4":{"state":{"linksGroups":[{"type":"geo","links":[{"label":"Ашберн","title":"Ашберн","url":"//yandex.ru/tune/geo","logNode":{"name":"region"},"target":"_self","a11yLabel":"Ваш регион Ашберн","needRetpath":true}]},{"type":"searchengines","links":[{"label":"Google","url":"//www.google.ru/search?ie=UTF-8&q=%D1%87%D0%B5%D0%BC%20%D0%BE%D1%82%D0%BB%D0%B8%D1%87%D0%B0%D0%B5%D1%82%D1%81%D1%8F%20%D0%BF%D1%80%D0%BE%D1%86%D0%B5%D0%B4%D1%83%D1%80%D0%B0%20%D0%BE%D1%82%20%D1%84%D1%83%D0%BD%D0%BA%D1%86%D0%B8%D0%B8%20vba","logNode":{"name":"link","attrs":{"type":"google"}},"target":"_blank"},{"label":"Bing","url":"//www.bing.com/search?q=%D1%87%D0%B5%D0%BC%20%D0%BE%D1%82%D0%BB%D0%B8%D1%87%D0%B0%D0%B5%D1%82%D1%81%D1%8F%20%D0%BF%D1%80%D0%BE%D1%86%D0%B5%D0%B4%D1%83%D1%80%D0%B0%20%D0%BE%D1%82%20%D1%84%D1%83%D0%BD%D0%BA%D1%86%D0%B8%D0%B8%20vba","logNode":{"name":"link","attrs":{"type":"bing"}},"target":"_blank"}]},{"type":"feedback","links":[{"label":"Сообщить об ошибке","logNode":{"name":"feedback","attrs":{"behaviour":{"type":"dynamic"}}}}]},{"type":"settings","links":[{"label":"Настройки","url":"//yandex.ru/tune/search","logNode":{"name":"settings"},"target":"_self","needRetpath":true}]},{"type":"morda","links":[{"label":"ya.ru","url":"//ya.ru/?from=serp_footer","logNode":{"name":"morda"},"target":"_self"}]},{"type":"company","links":[{"label":"О компании","url":"https://company.yandex.ru","logNode":{"name":"about"},"target":"_blank"},{"label":"Коммерческие предложения","url":"/search/direct?text=%D1%87%D0%B5%D0%BC%20%D0%BE%D1%82%D0%BB%D0%B8%D1%87%D0%B0%D0%B5%D1%82%D1%81%D1%8F%20%D0%BF%D1%80%D0%BE%D1%86%D0%B5%D0%B4%D1%83%D1%80%D0%B0%20%D0%BE%D1%82%20%D1%84%D1%83%D0%BD%D0%BA%D1%86%D0%B8%D0%B8%20vba&filters_docs=direct_cm","logNode":{"name":"commercial"},"target":"_blank"},{"label":"Вакансии","url":"//yandex.ru/jobs","logNode":{"name":"vacancy"},"target":"_blank"},{"label":"Лицензия на использование","url":"//yandex.ru/legal/termsofuse/","logNode":{"name":"license"},"target":"_blank"},{"label":"Политика конфиденциальности","url":"//yandex.ru/legal/confidential/","logNode":{"name":"confidential"},"target":"_blank"},{"label":"Правила рекомендаций","url":"//yandex.ru/legal/recommendations/#index__search","logNode":{"name":"recommendations"},"target":"_blank"}],"a11yHidden":true}],"reportFeedbackProps":{"feature":"Подвал","title":"Сообщить об ошибке","checkBoxLabels":[]},"isSearchApp":false,"hasExtralinks":true,"limitingSelector":".AliceFabButton","baobab":{"parentNode":{"context":{"genInfo":{"prefix":"2_d42fw0g-0-1"},"ui":"desktop","service":"web"}}}},"type":"serp-footer"},"2_d42f5":{"state":{"conditionLoadList":{"marketCart":false,"highchartsHighstock":false,"advProductGallery":false,"musicPlayer":false,"darkmodeChangeDrawer":true,"userMenuDialog":false,"ecomRates":false},"reportFeedbackBaseProps":{"initEmail":"","metaFields":{"userAgent":"claudebot","userTestids":"974402,186144,986325,983732,928406,967708,988257,986669,986800,988013,974982,982160,984942,979944,985818,974186,982702,975947,985862,984885,986796,27392,986818,936724,988933,985166,986794,984329,986171,988445,984886,988372,963713,985307,973520,959007,989322,980806,133992,986611,988770,89013,981221,977969,966250,982213,986847,982552,986353,981746,263461,255406,987013,977764,461653,986672,986770,929870,972620,912217,987050,332148,970696,975102,986115,983213,151171,126283,13963,287509,957805,987130,338390,785125,951491,988999,989610,976039,978190,979201,986155,982456,981397,969819,975226,970494","yandexuid":"6498901291710842019","uid":"0","queryText":"чем отличается процедура от функции vba","reqid":"1710842019690479-2159719178949890129-balancer-l7leveler-kubr-yp-vla-258-BAL","searchSlices":["drawer_search_slice_education","drawer_search_slice_cs"],"userRegionName":"Ashburn","userRegionId":"102820"}},"extralinksPopupProps":{"abuseLink":"https://yandex.ru/search/abuse?sign=8df6e18d34c456b4081104c0ee5963f3&keyno=0"},"isLoggedIn":false,"userMenuDialogProps":{"flag":"skin,feedback","host":"yandex.ru","lang":"ru","project":"serp","queryParams":{"utm_source":"search"},"retpath":"https%3A%2F%2Fyandex.ru%2Fsearch%2F%3Ftext%3D%25D1%2587%25D0%25B5%25D0%25BC%2520%25D0%25BE%25D1%2582%25D0%25BB%25D0%25B8%25D1%2587%25D0%25B0%25D0%25B5%25D1%2582%25D1%2581%25D1%258F%2520%25D0%25BF%25D1%2580%25D0%25BE%25D1%2586%25D0%25B5%25D0%25B4%25D1%2583%25D1%2580%25D0%25B0%2520%25D0%25BE%25D1%2582%2520%25D1%2584%25D1%2583%25D0%25BD%25D0%25BA%25D1%2586%25D0%25B8%25D0%25B8%2520vba%26lr%3D213%26ncrnd%3D39951","tld":"ru"},"baobab":{"parentNode":{"context":{"genInfo":{"prefix":"2_d42fw0h-0-1"},"ui":"desktop","service":"web","fast":{"name":"lazy-load"}}}}},"type":"lazy-load"},"2_d42f6":{"state":{"requestVisible":false},"type":"arch_metrika"}}