Bir h\u00fccrenin de\u011fi\u015fimini alg\u0131lay\u0131p ona g\u00f6re tepki verilmesi i\u00e7in gerekli kod \u00f6rne\u011fi<\/p>\n
Private Sub Worksheet_Change(ByVal Target As Range)\r\n' MsgBox (Target.Address)\r\n If (Target.Address = \"$B$5\") And ([b5].Value = \"\") Then\r\n [d5].Value = \"\"\r\n End If\r\n \r\n If (Target.Address = \"$B$5\") And ([b5].Value <> \"\") Then\r\n FirmaKodSorgu\r\n End If\r\nEnd Sub<\/pre>\n<\/p>\n","protected":false},"excerpt":{"rendered":"
Bir h\u00fccrenin de\u011fi\u015fimini alg\u0131lay\u0131p ona g\u00f6re tepki verilmesi i\u00e7in gerekli kod \u00f6rne\u011fi Private Sub Worksheet_Change(ByVal Target As Range) ‘ MsgBox […]<\/p>\n","protected":false},"author":1,"featured_media":576,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_uag_custom_page_level_css":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[345,2],"tags":[134,152,70],"class_list":["post-481","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel","category-yazilim","tag-excel","tag-macro","tag-vba"],"uagb_featured_image_src":{"full":["https:\/\/dijitalturk.com\/veysel\/wp-content\/uploads\/2015\/04\/logoExcel_VBA.png",256,256,false],"thumbnail":["https:\/\/dijitalturk.com\/veysel\/wp-content\/uploads\/2015\/04\/logoExcel_VBA-150x150.png",150,150,true],"medium":["https:\/\/dijitalturk.com\/veysel\/wp-content\/uploads\/2015\/04\/logoExcel_VBA-190x190.png",190,190,true],"medium_large":["https:\/\/dijitalturk.com\/veysel\/wp-content\/uploads\/2015\/04\/logoExcel_VBA.png",256,256,false],"large":["https:\/\/dijitalturk.com\/veysel\/wp-content\/uploads\/2015\/04\/logoExcel_VBA.png",256,256,false],"1536x1536":["https:\/\/dijitalturk.com\/veysel\/wp-content\/uploads\/2015\/04\/logoExcel_VBA.png",256,256,false],"2048x2048":["https:\/\/dijitalturk.com\/veysel\/wp-content\/uploads\/2015\/04\/logoExcel_VBA.png",256,256,false]},"uagb_author_info":{"display_name":"VeYSeL","author_link":"https:\/\/dijitalturk.com\/veysel\/author\/veysel\/"},"uagb_comment_info":0,"uagb_excerpt":"Bir h\u00fccrenin de\u011fi\u015fimini alg\u0131lay\u0131p ona g\u00f6re tepki verilmesi i\u00e7in gerekli kod \u00f6rne\u011fi Private Sub Worksheet_Change(ByVal Target As Range) ' MsgBox […]","_links":{"self":[{"href":"https:\/\/dijitalturk.com\/veysel\/wp-json\/wp\/v2\/posts\/481","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dijitalturk.com\/veysel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dijitalturk.com\/veysel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dijitalturk.com\/veysel\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dijitalturk.com\/veysel\/wp-json\/wp\/v2\/comments?post=481"}],"version-history":[{"count":0,"href":"https:\/\/dijitalturk.com\/veysel\/wp-json\/wp\/v2\/posts\/481\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dijitalturk.com\/veysel\/wp-json\/wp\/v2\/media\/576"}],"wp:attachment":[{"href":"https:\/\/dijitalturk.com\/veysel\/wp-json\/wp\/v2\/media?parent=481"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dijitalturk.com\/veysel\/wp-json\/wp\/v2\/categories?post=481"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dijitalturk.com\/veysel\/wp-json\/wp\/v2\/tags?post=481"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}