{"id":4915,"date":"2023-07-06T12:08:03","date_gmt":"2023-07-06T12:08:03","guid":{"rendered":"https:\/\/statorials.org\/tr\/vba-hucre-bicimi\/"},"modified":"2023-07-06T12:08:03","modified_gmt":"2023-07-06T12:08:03","slug":"vba-hucre-bicimi","status":"publish","type":"post","link":"https:\/\/statorials.org\/tr\/vba-hucre-bicimi\/","title":{"rendered":"Vba kullanarak excel&#39;de h\u00fccreleri bi\u00e7imlendirme (\u00f6rneklerle)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">VBA&#8217;daki <a href=\"https:\/\/learn.microsoft.com\/en-us\/office\/vba\/api\/excel.cellformat\" target=\"_blank\" rel=\"noopener\">\u00e7e\u015fitli \u00f6zellikleri<\/a> kullanarak Excel&#8217;deki h\u00fccreleri bi\u00e7imlendirmenin \u00e7ok \u00e7e\u015fitli yollar\u0131 vard\u0131r:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Girinti ekle<\/span><\/li>\n<li> <span style=\"color: #000000;\">Ba\u015fvuru<\/span><\/li>\n<li> <span style=\"color: #000000;\">Kenarl\u0131klar<\/span><\/li>\n<li> <span style=\"color: #000000;\">Yarat\u0131c\u0131<\/span><\/li>\n<li> <span style=\"color: #000000;\">Karakter yaz\u0131 tipi<\/span><\/li>\n<li> <span style=\"color: #000000;\">GizliForm\u00fcl<\/span><\/li>\n<li> <span style=\"color: #000000;\">Yatay hizalama<\/span><\/li>\n<li> <span style=\"color: #000000;\">Para \u00e7ekme seviyesi<\/span><\/li>\n<li> <span style=\"color: #000000;\">\u0130\u00e7 mekan<\/span><\/li>\n<li> <span style=\"color: #000000;\">Kilitli<\/span><\/li>\n<li> <span style=\"color: #000000;\">H\u00fccreleri Birle\u015ftir<\/span><\/li>\n<li> <span style=\"color: #000000;\">Say\u0131 bi\u00e7imi<\/span><\/li>\n<li> <span style=\"color: #000000;\">NumaraYerelBi\u00e7im<\/span><\/li>\n<li> <span style=\"color: #000000;\">Oryantasyon<\/span><\/li>\n<li> <span style=\"color: #000000;\">Ebeveyn<\/span><\/li>\n<li> <span style=\"color: #000000;\">Ayarlamak \u0130\u00e7in Azalt\u0131n<\/span><\/li>\n<li> <span style=\"color: #000000;\">Dikey hizalama<\/span><\/li>\n<li> <span style=\"color: #000000;\">Metni kayd\u0131r<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">VBA&#8217;da bir makro olu\u015fturarak, bir Excel sayfas\u0131nda belirli bir aral\u0131ktaki h\u00fccreleri bi\u00e7imlendirmek i\u00e7in bu \u00f6zelliklerden bir veya daha fazlas\u0131n\u0131 kullanabilirsiniz.<\/span><\/p>\n<p> <span style=\"color: #000000;\">A\u015fa\u011f\u0131daki \u00f6rnek bunun pratikte nas\u0131l yap\u0131laca\u011f\u0131n\u0131 g\u00f6stermektedir.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>\u00d6rnek: VBA Kullanarak Excel&#8217;de H\u00fccreleri Bi\u00e7imlendirme<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Excel&#8217;de a\u015fa\u011f\u0131daki basketbol tak\u0131m\u0131 adlar\u0131 listesine sahip oldu\u011fumuzu varsayal\u0131m:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-38355 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/formatercell1.png\" alt=\"\" width=\"447\" height=\"402\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\"><strong>A2:A11<\/strong> aral\u0131\u011f\u0131ndaki h\u00fccrelerin her birini belirli \u00f6zelliklerle bi\u00e7imlendirmek i\u00e7in a\u015fa\u011f\u0131daki makroyu olu\u015fturabiliriz:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">SubFormatCells<\/span> ()\n\n    <span style=\"color: #0000ff;\">With<\/span> Worksheets(\"Sheet1\").Range(\"A2:A11\")\n     .Font.FontStyle = \"Bold\"\n     .Font.Name = \"Calibri\"\n     .Font.Size = 13\n     .Font.Color = vbRed\n     .HorizontalAlignment = xlCenter\n    <span style=\"color: #0000ff;\">End With<\/span>\n\n<span style=\"color: #0000ff;\">End Sub<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Bu makro \u00e7al\u0131\u015ft\u0131r\u0131ld\u0131\u011f\u0131nda <strong>A2:A11<\/strong> aral\u0131\u011f\u0131ndaki h\u00fccrelerin her biri belirtti\u011fimiz \u015fekilde bi\u00e7imlendirilecektir:<\/span><\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-38356 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/formatercell2.png\" alt=\"\" width=\"446\" height=\"407\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">Bu \u00f6zel makroyu kullanarak <strong>A2:A11<\/strong> aral\u0131\u011f\u0131ndaki h\u00fccrelerin her birinde a\u015fa\u011f\u0131daki de\u011fi\u015fiklikleri yapt\u0131k:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Yaz\u0131 tipi stilini kal\u0131n olarak de\u011fi\u015ftirdik.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Font ailesini Calibri olarak de\u011fi\u015ftirdik.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Yaz\u0131 tipi boyutunu 13 olarak de\u011fi\u015ftirdik.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Yaz\u0131 tipi rengini k\u0131rm\u0131z\u0131 olarak de\u011fi\u015ftiriyoruz.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Metni yatay olarak ortalad\u0131k.<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Bu \u00f6rne\u011fin belirli bir aral\u0131ktaki h\u00fccreleri bi\u00e7imlendirmenin yaln\u0131zca bir yolunu g\u00f6sterdi\u011fini unutmay\u0131n.<\/span><\/p>\n<p> <span style=\"color: #000000;\">VBA&#8217;da bulunan \u00e7e\u015fitli \u00f6zellikleri kullanarak h\u00fccreleri istedi\u011finiz g\u00f6r\u00fcn\u00fcme g\u00f6re bi\u00e7imlendirebilirsiniz.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Not<\/strong> : VBA&#8217;daki t\u00fcm olas\u0131 h\u00fccre bi\u00e7imlendirme \u00f6zelliklerinin tam belgelerini <a href=\"https:\/\/learn.microsoft.com\/en-us\/office\/vba\/api\/excel.cellformat\" target=\"_blank\" rel=\"noopener\">burada<\/a> bulabilirsiniz.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Ek kaynaklar<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">A\u015fa\u011f\u0131daki e\u011fitimlerde VBA&#8217;da di\u011fer ortak g\u00f6revlerin nas\u0131l ger\u00e7ekle\u015ftirilece\u011fi a\u00e7\u0131klanmaktad\u0131r:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><a href=\"https:\/\/statorials.org\/tr\/vba-kalin-yazi-tipi\/\" target=\"_blank\" rel=\"noopener\">VBA kullanarak yaz\u0131 tipini kal\u0131n hale getirme<\/a><br \/> <a href=\"https:\/\/statorials.org\/tr\/merkezi-metin-vba\/\" target=\"_blank\" rel=\"noopener\">VBA Kullanarak Metin Nas\u0131l Ortalan\u0131r?<\/a><br \/> <a href=\"https:\/\/statorials.org\/tr\/vba-yazi-tipi-boyutu\/\" target=\"_blank\" rel=\"noopener\">VBA kullanarak yaz\u0131 tipi boyutu nas\u0131l ayarlan\u0131r<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>VBA&#8217;daki \u00e7e\u015fitli \u00f6zellikleri kullanarak Excel&#8217;deki h\u00fccreleri bi\u00e7imlendirmenin \u00e7ok \u00e7e\u015fitli yollar\u0131 vard\u0131r: Girinti ekle Ba\u015fvuru Kenarl\u0131klar Yarat\u0131c\u0131 Karakter yaz\u0131 tipi GizliForm\u00fcl Yatay hizalama Para \u00e7ekme seviyesi \u0130\u00e7 mekan Kilitli H\u00fccreleri Birle\u015ftir Say\u0131 bi\u00e7imi NumaraYerelBi\u00e7im Oryantasyon Ebeveyn Ayarlamak \u0130\u00e7in Azalt\u0131n Dikey hizalama Metni kayd\u0131r VBA&#8217;da bir makro olu\u015fturarak, bir Excel sayfas\u0131nda belirli bir aral\u0131ktaki h\u00fccreleri bi\u00e7imlendirmek i\u00e7in [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"class_list":["post-4915","post","type-post","status-publish","format-standard","hentry","category-rehber"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>VBA Kullanarak Excel&#039;de H\u00fccreleri Bi\u00e7imlendirme (\u00d6rneklerle) - Statorials<\/title>\n<meta name=\"description\" content=\"Bu e\u011fitimde VBA kullan\u0131larak Excel&#039;de h\u00fccrelerin nas\u0131l bi\u00e7imlendirilece\u011fi \u00e7e\u015fitli \u00f6rneklerle a\u00e7\u0131klanmaktad\u0131r.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/statorials.org\/tr\/vba-hucre-bicimi\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"VBA Kullanarak Excel&#039;de H\u00fccreleri Bi\u00e7imlendirme (\u00d6rneklerle) - Statorials\" \/>\n<meta property=\"og:description\" content=\"Bu e\u011fitimde VBA kullan\u0131larak Excel&#039;de h\u00fccrelerin nas\u0131l bi\u00e7imlendirilece\u011fi \u00e7e\u015fitli \u00f6rneklerle a\u00e7\u0131klanmaktad\u0131r.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/tr\/vba-hucre-bicimi\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-06T12:08:03+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/formatercell1.png\" \/>\n<meta name=\"author\" content=\"Dr.benjamin anderson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Yazan:\" \/>\n\t<meta name=\"twitter:data1\" content=\"Dr.benjamin anderson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/tr\/vba-hucre-bicimi\/\",\"url\":\"https:\/\/statorials.org\/tr\/vba-hucre-bicimi\/\",\"name\":\"VBA Kullanarak Excel&#39;de H\u00fccreleri Bi\u00e7imlendirme (\u00d6rneklerle) - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/tr\/#website\"},\"datePublished\":\"2023-07-06T12:08:03+00:00\",\"dateModified\":\"2023-07-06T12:08:03+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48\"},\"description\":\"Bu e\u011fitimde VBA kullan\u0131larak Excel&#39;de h\u00fccrelerin nas\u0131l bi\u00e7imlendirilece\u011fi \u00e7e\u015fitli \u00f6rneklerle a\u00e7\u0131klanmaktad\u0131r.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/tr\/vba-hucre-bicimi\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/tr\/vba-hucre-bicimi\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/tr\/vba-hucre-bicimi\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/statorials.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Vba kullanarak excel&#39;de h\u00fccreleri bi\u00e7imlendirme (\u00f6rneklerle)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/statorials.org\/tr\/#website\",\"url\":\"https:\/\/statorials.org\/tr\/\",\"name\":\"Statorials\",\"description\":\"\u0130statistik okuryazarl\u0131\u011f\u0131 rehberiniz!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/statorials.org\/tr\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"tr\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48\",\"name\":\"Dr.benjamin anderson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/statorials.org\/tr\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/statorials.org\/tr\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"contentUrl\":\"https:\/\/statorials.org\/tr\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"caption\":\"Dr.benjamin anderson\"},\"description\":\"Merhaba, ben Benjamin, emekli bir istatistik profes\u00f6r\u00fc ve Statorials \u00f6\u011fretmenine d\u00f6n\u00fc\u015ft\u00fcm. \u0130statistik alan\u0131ndaki kapsaml\u0131 deneyimim ve uzmanl\u0131\u011f\u0131mla, \u00f6\u011frencilerimi Statorials arac\u0131l\u0131\u011f\u0131yla g\u00fc\u00e7lendirmek i\u00e7in bilgilerimi payla\u015fmaya can at\u0131yorum. Daha fazlas\u0131n\u0131 bil\",\"sameAs\":[\"https:\/\/statorials.org\/tr\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"VBA Kullanarak Excel&#39;de H\u00fccreleri Bi\u00e7imlendirme (\u00d6rneklerle) - Statorials","description":"Bu e\u011fitimde VBA kullan\u0131larak Excel&#39;de h\u00fccrelerin nas\u0131l bi\u00e7imlendirilece\u011fi \u00e7e\u015fitli \u00f6rneklerle a\u00e7\u0131klanmaktad\u0131r.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/statorials.org\/tr\/vba-hucre-bicimi\/","og_locale":"tr_TR","og_type":"article","og_title":"VBA Kullanarak Excel&#39;de H\u00fccreleri Bi\u00e7imlendirme (\u00d6rneklerle) - Statorials","og_description":"Bu e\u011fitimde VBA kullan\u0131larak Excel&#39;de h\u00fccrelerin nas\u0131l bi\u00e7imlendirilece\u011fi \u00e7e\u015fitli \u00f6rneklerle a\u00e7\u0131klanmaktad\u0131r.","og_url":"https:\/\/statorials.org\/tr\/vba-hucre-bicimi\/","og_site_name":"Statorials","article_published_time":"2023-07-06T12:08:03+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/formatercell1.png"}],"author":"Dr.benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Yazan:":"Dr.benjamin anderson","Tahmini okuma s\u00fcresi":"2 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/tr\/vba-hucre-bicimi\/","url":"https:\/\/statorials.org\/tr\/vba-hucre-bicimi\/","name":"VBA Kullanarak Excel&#39;de H\u00fccreleri Bi\u00e7imlendirme (\u00d6rneklerle) - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/tr\/#website"},"datePublished":"2023-07-06T12:08:03+00:00","dateModified":"2023-07-06T12:08:03+00:00","author":{"@id":"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48"},"description":"Bu e\u011fitimde VBA kullan\u0131larak Excel&#39;de h\u00fccrelerin nas\u0131l bi\u00e7imlendirilece\u011fi \u00e7e\u015fitli \u00f6rneklerle a\u00e7\u0131klanmaktad\u0131r.","breadcrumb":{"@id":"https:\/\/statorials.org\/tr\/vba-hucre-bicimi\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/tr\/vba-hucre-bicimi\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/tr\/vba-hucre-bicimi\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/statorials.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Vba kullanarak excel&#39;de h\u00fccreleri bi\u00e7imlendirme (\u00f6rneklerle)"}]},{"@type":"WebSite","@id":"https:\/\/statorials.org\/tr\/#website","url":"https:\/\/statorials.org\/tr\/","name":"Statorials","description":"\u0130statistik okuryazarl\u0131\u011f\u0131 rehberiniz!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/statorials.org\/tr\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"tr"},{"@type":"Person","@id":"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48","name":"Dr.benjamin anderson","image":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/statorials.org\/tr\/#\/schema\/person\/image\/","url":"https:\/\/statorials.org\/tr\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","contentUrl":"https:\/\/statorials.org\/tr\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","caption":"Dr.benjamin anderson"},"description":"Merhaba, ben Benjamin, emekli bir istatistik profes\u00f6r\u00fc ve Statorials \u00f6\u011fretmenine d\u00f6n\u00fc\u015ft\u00fcm. \u0130statistik alan\u0131ndaki kapsaml\u0131 deneyimim ve uzmanl\u0131\u011f\u0131mla, \u00f6\u011frencilerimi Statorials arac\u0131l\u0131\u011f\u0131yla g\u00fc\u00e7lendirmek i\u00e7in bilgilerimi payla\u015fmaya can at\u0131yorum. Daha fazlas\u0131n\u0131 bil","sameAs":["https:\/\/statorials.org\/tr"]}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/posts\/4915","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/comments?post=4915"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/posts\/4915\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/media?parent=4915"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/categories?post=4915"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/tags?post=4915"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}