{"id":12130,"date":"2012-02-29T13:46:40","date_gmt":"2012-02-29T13:46:40","guid":{"rendered":"http:\/\/www.learnexcelmacro.com\/?p=1394"},"modified":"2022-08-07T00:35:38","modified_gmt":"2022-08-07T00:35:38","slug":"progressbar-in-excel-vba","status":"publish","type":"post","link":"https:\/\/vmlogger.com\/excel\/2012\/02\/progressbar-in-excel-vba\/","title":{"rendered":"Progress Bar in Excel VBA"},"content":{"rendered":"

How to use Progress Bar in excel Macro (VBA)<\/h2>\n

Progress bar is nothing but a placeholder, where you see the Progress of the operation which is getting performed.
\nLike Visual Studio there is NO already built progress bar in Excel Macro (VBA), which you can use it as an object and it will act like a Progress bar. But this is not a difficult task to create a Progress Bar in Excel Macro. In this article you are going to learn how to create\/simulate different types of Progress bar in Excel macro (VBA).
\nBasically as part of this article we are going to discuss following different kind of Progress bar:<\/p>\n

    \n
  1. Progress in Status Bar of Excel<\/li>\n
  2. Simple Progress Bar using User Form Control<\/li>\n
  3. Simple progress bar with % increment<\/li>\n
  4. Free Download : Progress Bar Excel Workbook<\/li>\n<\/ol>\n

    Progress in Status Bar of Excel:<\/h2>\n

    I believe this is the simplest way to show user the progress of your Excel Macro. For displaying and coding, both purposes it is very easy to use. Below is the Syntax to show the Progress of your Macro in Status Bar:
    \n 
    \nApplication.StatusBar=<Your Message or Status here<\/i>><\/font>
    \n
    \nExample:<\/strong> Below is an example, which shows how to show Progress message in Status Bar of the Excel, when Macro is running.<\/p>\n

    \r\n\r\nSub ShowProgressInStatus()\r\n\tDim Percent As Integer\r\n\tDim PercentComplete As Single\r\n\tDim MaxRow, MaxCol As Integer\r\n\tMaxRow = 800\r\n\tMaxCol = 800\r\n\tPercent = 0\r\n\tFor irow = 1 To MaxRow\r\n\t\tFor icol = 1 To MaxCol\r\n\t\t\tWorksheets(\"Sheet1\").Cells(irow, icol).Value = irow\r\n\t\tNext\r\n\t\tPercentComplete = irow * icol \/ (MaxRow * MaxCol)\r\n\t\tApplication.StatusBar = Format(PercentComplete, \"0%\") & \" Completed\"\r\n\t\tDoEvents\r\n\tNext\r\n\tApplication.StatusBar = \"\"\r\nEnd Sub\r\n\r\n<\/code><\/pre>\n
    <\/p>\n
    The above code will display the Dynamic Progress in % while Macro is running as shown below. Message you can customize yourself by changing the above Code.
    \n
    \n
    \"Progress<\/a>
    How to Show Progress in Status Bar<\/p><\/div>
    \n<\/p>\n
    Simple Progress Bar using User Control Form:<\/h2>\n
    In Excel Macro, there is no already built Progress bar Control, which can directly be used just by dragging and putting it in User Form.  Below are the Steps to create a Progress Bar in your Excel macro Code.<\/p>\n
    1. Open one Excel Workbook
    \n2. Press Alt+F11
    \n3. Now Add a New User Form by Right Clicking on the Left side Project as shown below:<\/p>\n
    \n
    \"How<\/a>
    How to Create Progress Bar : Add a User Form<\/p><\/div>
    \n<\/p>\n
    4. Now Change the Caption of the User Form as \u201cProcessing\u2026\u201d<\/p>\n
    \n
    \"How<\/a>
    How to Create Progress Bar : Add a User Form<\/p><\/div>
    \n<\/p>\n
    5. Add one Label Control from the Control Box and also change the Back Color of the Label in different Color.<\/p>\n
    <\/p>\n
    \"How<\/a>
    How to Create Progress Bar : Add a Label<\/p><\/div>
    \n<\/p>\n
    6. Remove the Caption of the label and keep it blank.
    \n7. Now make the Size of the User Form same as the Label<\/p>\n
    <\/p>\n
    \"How<\/a>
    How to Create Progress Bar : Add a Label-2<\/p><\/div>
    \n<\/p>\n
    8. Now Double Click on the User Form and Copy \u2013Paste the below Code<\/p>\n
    \r\n\r\nPrivate Sub UserForm_Activate()\r\n    Call ShowProgressBarWithoutPercentage\r\nEnd Sub\r\n\r\n\r\nSub ShowProgressBarWithoutPercentage()\r\n\tDim Percent As Integer\r\n\tDim PercentComplete As Single\r\n\tDim MaxRow, MaxCol As Integer\r\n\tDim iRow, iCol As Integer\r\n\tMaxRow = 500\r\n\tMaxCol = 500\r\n\tPercent = 0\r\n'Initially Set the width of the Label as Zero\r\n\tfrmProgressBar.LabelProgress.Width = 0\r\n\tFor iRow = 1 To MaxRow\r\n\t\tFor iCol = 1 To MaxCol\r\n\t\t\tWorksheets(\"Sheet1\").Cells(iRow, iCol).Value = iRow * iCol\r\n\t\t\t\r\n\t\tNext\r\n\t\tPercentComplete = iRow \/ MaxRow\r\n\t\tfrmProgressBar.LabelProgress.Width = PercentComplete * frmProgressBar.Width\r\n\t\tDoEvents\r\n\tNext\r\n\tUnload frmProgressBar\r\nEnd Sub\r\n\r\n<\/code><\/pre>\n
    <\/p>\n
    You are done with your Progress bar creation. Now you can activate the User Form at any point of time during your code and Progress Bar will start.
    \n <\/p>\n
    Important: How to call this Progress Bar? <\/h2>\n
    Wherever you want to show this progress bar use the below statement:
    \n 
    \nfrmProgressBar.Show<\/i><\/font>
    \n 
    \nWhile running, this is how your Progress Bar will look like.<\/p>\n
    \n
    \"How<\/a>
    How to Create Progress Bar : Progress Bar<\/p><\/div>
    \n<\/p>\n
    Simple Progress Bar with % Increment:<\/h2>\n
    This can be achieved exactly the same way as we have done above. The only change will be in the code. You need to add one line to display the calculated % in Label Caption or User Form Caption.<\/p>\n
    The below highlighted line will display the Completed % dynamically. <\/p>\n
    \r\n\r\nPrivate Sub UserForm_Activate()\r\n    Call ShowProgressBarWithoutPercentage\r\nEnd Sub\r\n\r\n\r\nSub ShowProgressBarWithoutPercentage()\r\n\tDim Percent As Integer\r\n\tDim PercentComplete As Single\r\n\tDim MaxRow, MaxCol As Integer\r\n\tDim iRow, iCol As Integer\r\n\tMaxRow = 500\r\n\tMaxCol = 500\r\n\tPercent = 0\r\n'Initially Set the width of the Label as Zero\r\n\tfrmProgressBar.LabelProgress.Width = 0\r\n\tFor iRow = 1 To MaxRow\r\n\t\tFor iCol = 1 To MaxCol\r\n\t\t\tWorksheets(\"Sheet1\").Cells(iRow, iCol).Value = iRow * iCol\r\n\t\t\t\r\n\t\tNext\r\n\t\tPercentComplete = iRow \/ MaxRow\r\n\t\tfrmProgressBar.LabelProgress.Width = PercentComplete * frmProgressBar.Width\r\n                frmProgressBar.LabelProgress.Caption = Format(PercentComplete, \"0%\")\r\n\t\tDoEvents\r\n\tNext\r\n\tUnload frmProgressBar\r\nEnd Sub\r\n\r\n<\/code><\/pre>\n
    You are done with your Progress bar creation. Now you can activate the User Form at any point of time during your code and Progress Bar will start.
    \n <\/p>\n
    Important: How to call this Progress Bar? <\/h2>\n
    Wherever you want to show this progress bar use the below statement:
    \n 
    \nfrmProgressBar.Show<\/i><\/font>
    \n <\/p>\n
    This is how it will look while running the code:<\/p>\n
    \n
    \"How<\/a>
    How to Create Progress Bar : Progress Bar With %<\/p><\/div>
    \n<\/p>\n
     If you need the Sample Workbook with Progress bar download it from here. If you are facing any issue in downloading it, please let me know.<\/h2>\n
    <\/p>\n
    \n\"Download<\/a>\n<\/div>\n
    <\/p>\n\n\n
    \n 
    \nTo Check out Excel Macro Tutorials, visit Excel Macro Tutorial<\/a><\/strong>
    \n\n<\/td>\n<\/tr>\n<\/table>\n
    <\/p>\n<\/span>","protected":false},"excerpt":{"rendered":"
    How to use Progress Bar in excel Macro (VBA) Progress bar is nothing but a placeholder, where you see the Progress of the operation which is getting performed. Like Visual Studio there is NO already built progress bar in Excel Macro (VBA), which you can use it as an object and it will act like […]<\/p>\n","protected":false},"author":45,"featured_media":242545,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","rop_custom_images_group":[],"rop_custom_messages_group":[],"rop_publish_now":"initial","rop_publish_now_accounts":{"facebook_10221221723514640_204908552914904":"","twitter_aTo1MTIwNTUyMDQ7_512055204":""},"rop_publish_now_history":[],"rop_publish_now_status":"pending","footnotes":""},"categories":[1246],"tags":[],"class_list":["post-12130","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-macro"],"yoast_head":"\nProgress Bar in Excel VBA - Let's excel in Excel<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/vmlogger.com\/excel\/2012\/02\/progressbar-in-excel-vba\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Progress Bar in Excel VBA\" \/>\n<meta property=\"og:description\" content=\"How to use Progress Bar in excel Macro (VBA) Progress bar is nothing but a placeholder, where you see the Progress of the operation which is getting performed. Like Visual Studio there is NO already built progress bar in Excel Macro (VBA), which you can use it as an object and it will act like […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/vmlogger.com\/excel\/2012\/02\/progressbar-in-excel-vba\/\" \/>\n<meta property=\"og:site_name\" content=\"Let's excel in Excel\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/vmlogger\" \/>\n<meta property=\"article:author\" content=\"http:\/\/www.facebook.com\/vmlogger\" \/>\n<meta property=\"article:published_time\" content=\"2012-02-29T13:46:40+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-08-07T00:35:38+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2012\/02\/Tutorial-to-create-progress-bar.png\" \/>\n\t<meta property=\"og:image:width\" content=\"400\" \/>\n\t<meta property=\"og:image:height\" content=\"250\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Vishwamitra Mishra\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@https:\/\/www.twitter.com\/learnexcelmacro\" \/>\n<meta name=\"twitter:site\" content=\"@learnexcelmacro\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Vishwamitra Mishra\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2012\/02\/progressbar-in-excel-vba\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2012\/02\/progressbar-in-excel-vba\/\"},\"author\":{\"name\":\"Vishwamitra Mishra\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"headline\":\"Progress Bar in Excel VBA\",\"datePublished\":\"2012-02-29T13:46:40+00:00\",\"dateModified\":\"2022-08-07T00:35:38+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2012\/02\/progressbar-in-excel-vba\/\"},\"wordCount\":707,\"commentCount\":39,\"publisher\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"image\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2012\/02\/progressbar-in-excel-vba\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2012\/02\/Tutorial-to-create-progress-bar.png\",\"articleSection\":[\"Excel Macro\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/vmlogger.com\/excel\/2012\/02\/progressbar-in-excel-vba\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2012\/02\/progressbar-in-excel-vba\/\",\"url\":\"https:\/\/vmlogger.com\/excel\/2012\/02\/progressbar-in-excel-vba\/\",\"name\":\"Progress Bar in Excel VBA - Let's excel in Excel\",\"isPartOf\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2012\/02\/progressbar-in-excel-vba\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2012\/02\/progressbar-in-excel-vba\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2012\/02\/Tutorial-to-create-progress-bar.png\",\"datePublished\":\"2012-02-29T13:46:40+00:00\",\"dateModified\":\"2022-08-07T00:35:38+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2012\/02\/progressbar-in-excel-vba\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/vmlogger.com\/excel\/2012\/02\/progressbar-in-excel-vba\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2012\/02\/progressbar-in-excel-vba\/#primaryimage\",\"url\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2012\/02\/Tutorial-to-create-progress-bar.png\",\"contentUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2012\/02\/Tutorial-to-create-progress-bar.png\",\"width\":400,\"height\":250,\"caption\":\"Tutorial to create progress bar in Excel VBA\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2012\/02\/progressbar-in-excel-vba\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/vmlogger.com\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel Macro\",\"item\":\"https:\/\/vmlogger.com\/excel\/macro\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Progress Bar in Excel VBA\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#website\",\"url\":\"https:\/\/vmlogger.com\/excel\/\",\"name\":\"Let's excel in Excel\",\"description\":\"Let's share knowledge\",\"publisher\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/vmlogger.com\/excel\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\",\"name\":\"Vishwamitra Mishra\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png\",\"contentUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png\",\"width\":528,\"height\":560,\"caption\":\"Vishwamitra Mishra\"},\"logo\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/\"},\"description\":\"My name is Vishwamitra Mishra. Friends Call me Vishwa. I hold a Bachelor\u2019s Degree in Computer Science from D.A.V.V. Indore & currently working as a Technical Lead having over 7 years of experience.\",\"sameAs\":[\"http:\/\/www.learnexcelmacro.com\",\"http:\/\/www.facebook.com\/vmlogger\",\"https:\/\/x.com\/https:\/\/www.twitter.com\/learnexcelmacro\",\"https:\/\/www.youtube.com\/c\/VMLogger\"],\"url\":\"https:\/\/vmlogger.com\/excel\/author\/vishwamitra\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Progress Bar in Excel VBA - Let's excel in Excel","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:\/\/vmlogger.com\/excel\/2012\/02\/progressbar-in-excel-vba\/","og_locale":"en_US","og_type":"article","og_title":"Progress Bar in Excel VBA","og_description":"How to use Progress Bar in excel Macro (VBA) Progress bar is nothing but a placeholder, where you see the Progress of the operation which is getting performed. Like Visual Studio there is NO already built progress bar in Excel Macro (VBA), which you can use it as an object and it will act like […]","og_url":"https:\/\/vmlogger.com\/excel\/2012\/02\/progressbar-in-excel-vba\/","og_site_name":"Let's excel in Excel","article_publisher":"http:\/\/www.facebook.com\/vmlogger","article_author":"http:\/\/www.facebook.com\/vmlogger","article_published_time":"2012-02-29T13:46:40+00:00","article_modified_time":"2022-08-07T00:35:38+00:00","og_image":[{"width":400,"height":250,"url":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2012\/02\/Tutorial-to-create-progress-bar.png","type":"image\/png"}],"author":"Vishwamitra Mishra","twitter_card":"summary_large_image","twitter_creator":"@https:\/\/www.twitter.com\/learnexcelmacro","twitter_site":"@learnexcelmacro","twitter_misc":{"Written by":"Vishwamitra Mishra","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/vmlogger.com\/excel\/2012\/02\/progressbar-in-excel-vba\/#article","isPartOf":{"@id":"https:\/\/vmlogger.com\/excel\/2012\/02\/progressbar-in-excel-vba\/"},"author":{"name":"Vishwamitra Mishra","@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"headline":"Progress Bar in Excel VBA","datePublished":"2012-02-29T13:46:40+00:00","dateModified":"2022-08-07T00:35:38+00:00","mainEntityOfPage":{"@id":"https:\/\/vmlogger.com\/excel\/2012\/02\/progressbar-in-excel-vba\/"},"wordCount":707,"commentCount":39,"publisher":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"image":{"@id":"https:\/\/vmlogger.com\/excel\/2012\/02\/progressbar-in-excel-vba\/#primaryimage"},"thumbnailUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2012\/02\/Tutorial-to-create-progress-bar.png","articleSection":["Excel Macro"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/vmlogger.com\/excel\/2012\/02\/progressbar-in-excel-vba\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/vmlogger.com\/excel\/2012\/02\/progressbar-in-excel-vba\/","url":"https:\/\/vmlogger.com\/excel\/2012\/02\/progressbar-in-excel-vba\/","name":"Progress Bar in Excel VBA - Let's excel in Excel","isPartOf":{"@id":"https:\/\/vmlogger.com\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/vmlogger.com\/excel\/2012\/02\/progressbar-in-excel-vba\/#primaryimage"},"image":{"@id":"https:\/\/vmlogger.com\/excel\/2012\/02\/progressbar-in-excel-vba\/#primaryimage"},"thumbnailUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2012\/02\/Tutorial-to-create-progress-bar.png","datePublished":"2012-02-29T13:46:40+00:00","dateModified":"2022-08-07T00:35:38+00:00","breadcrumb":{"@id":"https:\/\/vmlogger.com\/excel\/2012\/02\/progressbar-in-excel-vba\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/vmlogger.com\/excel\/2012\/02\/progressbar-in-excel-vba\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/vmlogger.com\/excel\/2012\/02\/progressbar-in-excel-vba\/#primaryimage","url":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2012\/02\/Tutorial-to-create-progress-bar.png","contentUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2012\/02\/Tutorial-to-create-progress-bar.png","width":400,"height":250,"caption":"Tutorial to create progress bar in Excel VBA"},{"@type":"BreadcrumbList","@id":"https:\/\/vmlogger.com\/excel\/2012\/02\/progressbar-in-excel-vba\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/vmlogger.com\/excel\/"},{"@type":"ListItem","position":2,"name":"Excel Macro","item":"https:\/\/vmlogger.com\/excel\/macro\/"},{"@type":"ListItem","position":3,"name":"Progress Bar in Excel VBA"}]},{"@type":"WebSite","@id":"https:\/\/vmlogger.com\/excel\/#website","url":"https:\/\/vmlogger.com\/excel\/","name":"Let's excel in Excel","description":"Let's share knowledge","publisher":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/vmlogger.com\/excel\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5","name":"Vishwamitra Mishra","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/","url":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png","contentUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png","width":528,"height":560,"caption":"Vishwamitra Mishra"},"logo":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/"},"description":"My name is Vishwamitra Mishra. Friends Call me Vishwa. I hold a Bachelor\u2019s Degree in Computer Science from D.A.V.V. Indore & currently working as a Technical Lead having over 7 years of experience.","sameAs":["http:\/\/www.learnexcelmacro.com","http:\/\/www.facebook.com\/vmlogger","https:\/\/x.com\/https:\/\/www.twitter.com\/learnexcelmacro","https:\/\/www.youtube.com\/c\/VMLogger"],"url":"https:\/\/vmlogger.com\/excel\/author\/vishwamitra\/"}]}},"_links":{"self":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts\/12130"}],"collection":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/users\/45"}],"replies":[{"embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/comments?post=12130"}],"version-history":[{"count":0,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts\/12130\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/media\/242545"}],"wp:attachment":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/media?parent=12130"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/categories?post=12130"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/tags?post=12130"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}