{"id":12172,"date":"2013-02-18T18:04:37","date_gmt":"2013-02-18T18:04:37","guid":{"rendered":"http:\/\/www.learnexcelmacro.com\/?p=2815"},"modified":"2022-08-12T11:18:57","modified_gmt":"2022-08-12T11:18:57","slug":"input-box-and-smart-input-box","status":"publish","type":"post","link":"https:\/\/vmlogger.com\/excel\/2013\/02\/input-box-and-smart-input-box\/","title":{"rendered":"Input Box and “Smart” Input Box"},"content":{"rendered":"

The most easiest and commonly used function in VBA is Input Box<\/strong>. Without much VBA coding, user can be asked to enter some input at any point of programming. To illustrate the simplicity of Input Box we will take an example.
\nExample: You are trying to add a New WorkSheet in a Workbook but the Sheet Name you want to be provided by the user run time. When I say “Run Time” It means after running the program you are asked for the Name of the sheet and once you enter it a new sheet is created with the same name you entered. You can read more on Adding sheet using VBA in this article<\/a><\/p>\n

Sub Add_Sheet()\n\n    Sheets.Add.Name = InputBox(Title:=\"Title Name\", _\n                        Prompt:=\"Prompt Name\", _\n                        Default:=\"Default Value\", _\n                        xPos:=100, yPos:=100, _\n                        HelpFile:=\"Demo.help\", _\n                        Context:=2)\n\nEnd Sub<\/code><\/pre>\n
Above Code will add a New sheet in the Excel workbook, with the same name which entered in to the Input Box appeared.
\nNote: This is a very simple code to add a sheet. It does not have any validation like checking if any sheet with the same name exist or not. To handle all such validation you can read this article.Click Here<\/a><\/strong><\/p>\n
Syntax:<\/h3>\n
InputBox(prompt[, title] [, default] [, xpos] [, ypos] [, helpfile, context])<\/span>
\nPrompt(Required):<\/span> This is the message which you want to be displayed in the dialog box (Input Dialog Box). For example: “Enter your Sheet Name”<\/p>\n
Title (Optional):<\/span> This is the Title which you want to be displayed in the title bar of the dialog box. If you do not provide title, then application name is displayed in the title bar by default.<\/p>\n
Default (Optional):<\/span> This is value which you want to be displayed by default as soon as InputBox is launched. If you do not pass this parameter then it will remain blank by default.<\/p>\n
xPos Optional.<\/span> Numeric value which displays the distance of the dialog box from Left side of the Screen. By default it is centrally aligned to the screen.<\/p>\n
yPos (Optional):<\/span> Numeric value which displays the distance of the dialog box from upper side of the Screen. By default it is vertically positioned approximately one-third of the way down the screen.<\/p>\n
HelpFile (Optional):<\/span> If you want Help button to be displayed on the InputBox then you can pass HelpFile Name in this parameter.<\/p>\n
Context (Optional):<\/span> Numeric expression that is the Help context number assigned to the appropriate Help topic by the Help author. If context is provided, helpfile must also be provided.
\nOn Running the above code, InputBox will appear like this:
\n
\n
\"VBA
VBA : Input Box<\/p><\/div><\/p>\n
Let’s take another example where you want user to enter a valid Cell Range to perform some operation on that range.<\/p>\n
\nSub ClearSelectedArea()\n Dim rng As Range\n Dim strAddress As String\n strAddress = InputBox(\"Select the cells to be cleared\")\n Set rng = Range(strAddress)\n rng.Select\n Selection.ClearContents\nEnd Sub<\/code><\/pre>\n
When InputBox dialog Box opens then your Excel Workbook get frozen. It means you can not select any cell or do anything until you closes the InputBox dialog box. It means this kind of InputBox is good for users to enter any text or number. But in the above example if you see, It is difficult to Input a range Address in input box without having flexibility to see and select the cells or cell-range. Without doing so you will not be able to select.<\/p>\n
This is where the other InputBox comes in to picture. Technically the InputBox which we have used before is called as “VBA InputBox Function” and the other InputBox (which I am calling it as Smart InputBox) is an InputBox method in Excel VBA.<\/p>\n
Since this Smart InputBox is a method in Excel VBA, therefore, it must be used like this:
\n
\n rng = Application.InputBox(“Select the Cells to be cleared”)<\/span><\/strong>
\n
\nFrom the above code, it looks very much similar to what we have used in normal InputBox but there are few differences in the functionality.<\/p>\n
As I told smart InputBox is a VBA method, it means It is not necessary that it will return only string. It may return different types of values like Boolean type, Range Object or a number. This InputBox method can return different types of values, then there must be an identifier which tells user which type of value it should return.<\/p>\n
\"InputBox
InputBox Method<\/p><\/div>\n
In the above picture the  Type<\/strong> parameter is to determine the type of the return value. For different types of values, there are different types which you need to mention.
\nFor example, in above case when you want that a user has to select a range address then you need to pass the Type Parameter as 8.<\/p>\n
Below table shows the different Type Values and corresponding data types:
\n<\/p>\n\n\n\n\n\n\n\n\n\n\n
Type Value<\/td>\nType Meaning<\/td>\n<\/tr>\n
0<\/td>\nA formula<\/td>\n<\/tr>\n
1<\/td>\nA number<\/td>\n<\/tr>\n
2<\/td>\nText (a string)<\/td>\n<\/tr>\n
4<\/td>\nA logical value (True or False)<\/td>\n<\/tr>\n
8<\/td>\nA cell reference, as a Range object<\/td>\n<\/tr>\n
16<\/td>\nAn error value, such as #N\/A<\/td>\n<\/tr>\n
64<\/td>\nAn array of values<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
 <\/p>\n
Therefore in the above example we can use the InputBox method to take the range object from the user and we need to pass the type parameter as 8.<\/p>\n
Sub ClearSelectedArea()\n Dim rng As Range\n Dim strAddress As String\n strAddress = Application.InputBox(Prompt:=\"Select the cells to be cleared\",Type:=8)\n Set rng = Range(strAddress)\n rng.Select\n Selection.ClearContents\nEnd Sub<\/code><\/pre>\n
 <\/p>\n
InputBox Method looks little different from the InputBox function as show below:<\/p>\n
\"InputBox-Method\"
InputBox-Method<\/p><\/div>\n
Now in the above example you can see that InputBox is accepting only valid excel range. Even if you try to enter an invalid Range Input then it will throw an error. This is the reason I prefer calling it as Smart InputBox because it does the validation before accepting any value entered by the user.
<\/p>\n<\/span>","protected":false},"excerpt":{"rendered":"
The most easiest and commonly used function in VBA is Input Box. Without much VBA coding, user can be asked to enter some input at any point of programming. To illustrate the simplicity of Input Box we will take an example. Example: You are trying to add a New WorkSheet in a Workbook but the […]<\/p>\n","protected":false},"author":45,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[1673,1678,5204],"tags":[],"class_list":["post-12172","post","type-post","status-publish","format-standard","hentry","category-excel-functions","category-interesting-vba-functions","category-vba-programming"],"yoast_head":"\nInput Box and "Smart" Input Box - 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\/2013\/02\/input-box-and-smart-input-box\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Input Box and "Smart" Input Box\" \/>\n<meta property=\"og:description\" content=\"The most easiest and commonly used function in VBA is Input Box. Without much VBA coding, user can be asked to enter some input at any point of programming. To illustrate the simplicity of Input Box we will take an example. Example: You are trying to add a New WorkSheet in a Workbook but the […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/vmlogger.com\/excel\/2013\/02\/input-box-and-smart-input-box\/\" \/>\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=\"2013-02-18T18:04:37+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-08-12T11:18:57+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2013\/01\/InputBox.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=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2013\/02\/input-box-and-smart-input-box\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2013\/02\/input-box-and-smart-input-box\/\"},\"author\":{\"name\":\"Vishwamitra Mishra\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"headline\":\"Input Box and “Smart” Input Box\",\"datePublished\":\"2013-02-18T18:04:37+00:00\",\"dateModified\":\"2022-08-12T11:18:57+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2013\/02\/input-box-and-smart-input-box\/\"},\"wordCount\":901,\"commentCount\":3,\"publisher\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"image\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2013\/02\/input-box-and-smart-input-box\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2013\/01\/InputBox.png\",\"articleSection\":[\"Excel Functions\",\"Interesting VBA Functions\",\"VBA Programming\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/vmlogger.com\/excel\/2013\/02\/input-box-and-smart-input-box\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2013\/02\/input-box-and-smart-input-box\/\",\"url\":\"https:\/\/vmlogger.com\/excel\/2013\/02\/input-box-and-smart-input-box\/\",\"name\":\"Input Box and \\\"Smart\\\" Input Box - Let's excel in Excel\",\"isPartOf\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2013\/02\/input-box-and-smart-input-box\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2013\/02\/input-box-and-smart-input-box\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2013\/01\/InputBox.png\",\"datePublished\":\"2013-02-18T18:04:37+00:00\",\"dateModified\":\"2022-08-12T11:18:57+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2013\/02\/input-box-and-smart-input-box\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/vmlogger.com\/excel\/2013\/02\/input-box-and-smart-input-box\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2013\/02\/input-box-and-smart-input-box\/#primaryimage\",\"url\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2013\/01\/InputBox.png\",\"contentUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2013\/01\/InputBox.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2013\/02\/input-box-and-smart-input-box\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/vmlogger.com\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel Functions\",\"item\":\"https:\/\/vmlogger.com\/excel\/excel-functions\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Input Box and “Smart” Input Box\"}]},{\"@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":"Input Box and \"Smart\" Input Box - 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\/2013\/02\/input-box-and-smart-input-box\/","og_locale":"en_US","og_type":"article","og_title":"Input Box and \"Smart\" Input Box","og_description":"The most easiest and commonly used function in VBA is Input Box. Without much VBA coding, user can be asked to enter some input at any point of programming. To illustrate the simplicity of Input Box we will take an example. Example: You are trying to add a New WorkSheet in a Workbook but the […]","og_url":"https:\/\/vmlogger.com\/excel\/2013\/02\/input-box-and-smart-input-box\/","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":"2013-02-18T18:04:37+00:00","article_modified_time":"2022-08-12T11:18:57+00:00","og_image":[{"url":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2013\/01\/InputBox.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":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/vmlogger.com\/excel\/2013\/02\/input-box-and-smart-input-box\/#article","isPartOf":{"@id":"https:\/\/vmlogger.com\/excel\/2013\/02\/input-box-and-smart-input-box\/"},"author":{"name":"Vishwamitra Mishra","@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"headline":"Input Box and “Smart” Input Box","datePublished":"2013-02-18T18:04:37+00:00","dateModified":"2022-08-12T11:18:57+00:00","mainEntityOfPage":{"@id":"https:\/\/vmlogger.com\/excel\/2013\/02\/input-box-and-smart-input-box\/"},"wordCount":901,"commentCount":3,"publisher":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"image":{"@id":"https:\/\/vmlogger.com\/excel\/2013\/02\/input-box-and-smart-input-box\/#primaryimage"},"thumbnailUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2013\/01\/InputBox.png","articleSection":["Excel Functions","Interesting VBA Functions","VBA Programming"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/vmlogger.com\/excel\/2013\/02\/input-box-and-smart-input-box\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/vmlogger.com\/excel\/2013\/02\/input-box-and-smart-input-box\/","url":"https:\/\/vmlogger.com\/excel\/2013\/02\/input-box-and-smart-input-box\/","name":"Input Box and \"Smart\" Input Box - Let's excel in Excel","isPartOf":{"@id":"https:\/\/vmlogger.com\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/vmlogger.com\/excel\/2013\/02\/input-box-and-smart-input-box\/#primaryimage"},"image":{"@id":"https:\/\/vmlogger.com\/excel\/2013\/02\/input-box-and-smart-input-box\/#primaryimage"},"thumbnailUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2013\/01\/InputBox.png","datePublished":"2013-02-18T18:04:37+00:00","dateModified":"2022-08-12T11:18:57+00:00","breadcrumb":{"@id":"https:\/\/vmlogger.com\/excel\/2013\/02\/input-box-and-smart-input-box\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/vmlogger.com\/excel\/2013\/02\/input-box-and-smart-input-box\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/vmlogger.com\/excel\/2013\/02\/input-box-and-smart-input-box\/#primaryimage","url":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2013\/01\/InputBox.png","contentUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2013\/01\/InputBox.png"},{"@type":"BreadcrumbList","@id":"https:\/\/vmlogger.com\/excel\/2013\/02\/input-box-and-smart-input-box\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/vmlogger.com\/excel\/"},{"@type":"ListItem","position":2,"name":"Excel Functions","item":"https:\/\/vmlogger.com\/excel\/excel-functions\/"},{"@type":"ListItem","position":3,"name":"Input Box and “Smart” Input Box"}]},{"@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\/12172"}],"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=12172"}],"version-history":[{"count":0,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts\/12172\/revisions"}],"wp:attachment":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/media?parent=12172"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/categories?post=12172"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/tags?post=12172"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}