{"product_id":"138282","title":"Excel Macro \u0026amp; VBA Bible ","description":"\u003ccenter\u003e\u003cdiv style=\"text-align:center\"\u003e\u003cimg src=\"https:\/\/tmgdisk01.cafe24.com\/images\/vs\/4172\/sv\/3jXPB8vYvqwQKzF84GEQiZr24Ke5PH.png?v=1765061834\" style=\"max-width:100%;max-height:10px\"\u003e\u003c\/div\u003e\u003c\/center\u003e\n\u003ccenter\u003e\u003ctable\u003e\u003ctr\u003e\u003ctd style=\"height:10px\"\u003e\u003c\/td\u003e\u003c\/tr\u003e\u003c\/table\u003e\u003c\/center\u003e\n\u003ccenter\u003e\u003ctable\u003e\u003ctr\u003e\u003ctd style=\"height:10px\"\u003e\u003c\/td\u003e\u003c\/tr\u003e\u003c\/table\u003e\u003c\/center\u003e\n\u003ccenter\u003e\n\n\u003cdiv style=\"width:95%\"\u003e\n\n\u003cdiv style=\"text-align:center;font-size:30px;font-weight:bolder;line-height:1.6em\"\u003e Excel Macro \u0026amp; VBA Bible \u003c\/div\u003e\n\n\u003ccenter\u003e\u003ctable\u003e\u003ctr\u003e\u003ctd style=\"height:10px\"\u003e\u003c\/td\u003e\u003c\/tr\u003e\u003c\/table\u003e\u003c\/center\u003e\n\n\u003ccenter\u003e\u003ctable\u003e\u003ctr\u003e\u003ctd style=\"height:10px\"\u003e\u003c\/td\u003e\u003c\/tr\u003e\u003c\/table\u003e\u003c\/center\u003e\n\n\u003ccenter\u003e\u003ctable\u003e\u003ctr\u003e\u003ctd style=\"height:10px\"\u003e\u003c\/td\u003e\u003c\/tr\u003e\u003c\/table\u003e\u003c\/center\u003e\n\n\u003ccenter\u003e\u003ctable\u003e\u003ctr\u003e\u003ctd style=\"height:10px\"\u003e\u003c\/td\u003e\u003c\/tr\u003e\u003c\/table\u003e\u003c\/center\u003e\n\n\u003cdiv style=\"border-bottom:1px;border-bottom-style:dotted;border-color:;padding-bottom:20px\"\u003e\u003ccenter\u003e\u003ctable align=\"center\" width=\"100%\"\u003e\u003ctbody style=\"border:0px\"\u003e\n\n\u003ctr\u003e\u003ctd align=\"center\" style=\"line-height:1.2em;text-align:center;font-size:18px;color:black;font-weight:bold;padding-bottom:20px;\"\u003e\u003c\/td\u003e\u003c\/tr\u003e\n\n\u003ctr\u003e\u003ctd style=\"text-align:center\"\u003e\u003cimg src=\"https:\/\/image.yes24.com\/goods\/119149301\/XL\" style=\"max-width:100%;height:auto\"\u003e\u003c\/td\u003e\u003c\/tr\u003e\n\n\n\u003c\/tbody\u003e\u003c\/table\u003e\u003c\/center\u003e\u003c\/div\u003e\n\n\u003ccenter\u003e\u003ctable\u003e\u003ctr\u003e\u003ctd style=\"height:10px\"\u003e\u003c\/td\u003e\u003c\/tr\u003e\u003c\/table\u003e\u003c\/center\u003e\n\n\u003ccenter\u003e\u003ctable\u003e\u003ctr\u003e\u003ctd style=\"height:10px\"\u003e\u003c\/td\u003e\u003c\/tr\u003e\u003c\/table\u003e\u003c\/center\u003e\n\n\u003cdiv style=\"width:95%;{split_style6}padding-top:20px;padding-bottom:20px\"\u003e\n\n\u003cdiv style=\"text-align:left;font-size:16px;font-weight:bold;padding-bottom:20px\"\u003e Description \u003c\/div\u003e\n\n\u003cdiv style=\"text-align:left;word-break:break-all;font-size:14px;line-height:1.6em;\"\u003e\n\n\u003cdiv\u003e\u003ch5\u003e \u003cb\u003eBook Introduction\u003c\/b\u003e\n\u003c\/h5\u003e\u003c\/div\u003e\n\u003cdiv\u003e\n\u003cdiv\u003e\u003cdiv\u003e \u003cb\u003eAutomate your work with macro codes tailored to your needs, from the basics of Excel macros and VBA to practical application!\u003cbr\u003e Almost everything about Excel macros and VBA suggested by Choi Jun-seon of Naver Excel's representative cafe 'Excel...One a Day'!\u003c\/b\u003e\u003cbr\u003e\u003cbr\u003e You can systematically learn everything from the basic functions of Excel macros and VBA to key features and code that can be used in actual work, across all versions, including Excel 2010, 2013, 2016, 2019, 2021, and Microsoft 365. \u003cbr\u003eContents that differ by version are displayed along with detailed usage tips to ensure that you can practice macros and VBA examples without any difficulties regardless of which version you use.\u003cbr\u003e The table of contents is carefully organized with content applicable to work, such as basic macro grammar, major Excel objects, and frequently used function controls, and practical functions are displayed for easy finding.\u003cbr\u003e In addition, formula and function help are placed throughout, so you can understand unfamiliar functions and terms at once.\u003cbr\u003e\u003cbr\u003e\u003cbr\u003e Once you master the macro and VBA learning methods that utilize AI such as ChatGPT, you will be able to learn almost everything about Excel task automation programming.\u003cbr\u003e If you have any difficulties while learning, you can get help from the author by visiting the representative Naver Excel cafe, “Excel...One a Day,” and the YouTube channel, “Excel Master.”\u003cbr\u003e\n\n\u003c\/div\u003e\u003c\/div\u003e\n\u003cdiv\u003e\u003cul\u003e\u003cli\u003e You can preview some of the book's contents. \u003cbr\u003e\u003cspan\u003ePreview\u003c\/span\u003e\n\n\u003c\/li\u003e\u003c\/ul\u003e\u003c\/div\u003e\n\u003c\/div\u003e\n\u003cbr\u003e\u003cdiv\u003e\u003ch5\u003e \u003cb\u003eindex\u003c\/b\u003e\n\u003c\/h5\u003e\u003c\/div\u003e\n\u003cdiv\u003e\n\u003cdiv\u003e \u003cb\u003ePART 01 Macro Basics\u003cbr\u003e\u003c\/b\u003e\u003cbr\u003e CHAPTER 01 Environment Settings and Programming Basics\u003cbr\u003e 01-01 Understanding Macros and VBA\u003cbr\u003e 01-02 Save as a macro-enabled workbook\u003cbr\u003e 01-03 Show [Developer] tab in ribbon\u003cbr\u003e 01-04 Security warning message line and trusted document\u003cbr\u003e 01-05 Registering the main work folder as a trusted location\u003cbr\u003e 01-06 Security Risk Message Line Meaning and How to Resolve Display\u003cbr\u003e\u003cbr\u003e CHAPTER 02 Macro Recorder\u003cbr\u003e 02-01 How to Use the Macro Recorder\u003cbr\u003e 02-02 How to efficiently modify recorded code\u003cbr\u003e 02-03 Running a macro using a shortcut key\u003cbr\u003e 02-04 How to use a macro in multiple files\u003cbr\u003e 02-05 Delete Personal Macro Workbook\u003cbr\u003e Click the 02-06 button to run the macro\u003cbr\u003e 02-07 How to register a macro in the ribbon menu\u003cbr\u003e\u003cbr\u003e CHAPTER 03 Visual Basic Editor\u003cbr\u003e 03-01 How to configure and dock the VB editor window\u003cbr\u003e 03-02 Understanding and Using the Project Explorer Window\u003cbr\u003e 03-03 Exporting and Importing Objects \u003cbr\u003e03-04 Understanding and Using the Properties Window\u003cbr\u003e 03-05 Understanding and Using the Code Window\u003cbr\u003e 03-06 Understanding and Using the Direct Execution Window\u003cbr\u003e 03-07 How to set VB editor options\u003cbr\u003e 03-08 VB editor and fonts for coding\u003cbr\u003e 03-09 Major shortcuts in the VB editor\u003cbr\u003e 03-10 How to use the [Edit] toolbar in the VB editor\u003cbr\u003e 03-11 How to Protect Macro Code with a Password\u003cbr\u003e\u003cbr\u003e \u003cb\u003ePART 02 Learning VBA\u003cbr\u003e\u003c\/b\u003e\u003cbr\u003e CHAPTER 04 Excel's Object Model\u003cbr\u003e 04-01 Understanding Excel's Object Model\u003cbr\u003e 04-02 Objects and Collections\u003cbr\u003e 04-03 How to check which commands are supported by an object\u003cbr\u003e 04-04 What do ThisWorkbook and ActiveSheet mean?\u003cbr\u003e 04-05 How to use With statement\u003cbr\u003e\u003cbr\u003e CHAPTER 05 Sub Procedures\u003cbr\u003e 05-01 What is a Sub Procedure?\u003cbr\u003e 05-02 Understanding and Using Comments\u003cbr\u003e 05-03 Developing procedures by dividing them into work units\u003cbr\u003e 05-04 Understanding and Using Variables\u003cbr\u003e 05-05 Understanding and Using Constants\u003cbr\u003e 05-06 Understanding and Using Object Variables\u003cbr\u003e 05-07 Understanding and Using Array Variables\u003cbr\u003e 05-08 Understanding and Using Dynamic Array Variables\u003cbr\u003e 05-09 Understanding and Using User-Defined Data Types \u003cbr\u003e05-10 How to share variables with multiple macros\u003cbr\u003e 05-11 How to prevent variables from being initialized after running a macro?\u003cbr\u003e\u003cbr\u003e CHAPTER 06 Judgment\u003cbr\u003e 06-01 How to structure and use the If statement\u003cbr\u003e 06-02 How to use And, Or, and Not operators for multiple condition processing\u003cbr\u003e 06-03 How to use the IIf function\u003cbr\u003e 06-04 How to use the ElseIf clause in an If statement\u003cbr\u003e 06-05 How to use the Switch function\u003cbr\u003e 06-06 How to structure and use the Select Case statement\u003cbr\u003e 06-07 How to use the Like comparison operator in an If statement\u003cbr\u003e\u003cbr\u003e CHAPTER 07 Circular Loops\u003cbr\u003e 07-01 For…Next How to structure and use the statement\u003cbr\u003e 07-02 How to Use Step Keywords\u003cbr\u003e 07-03 Example of a loop that loops backwards\u003cbr\u003e 07-04 Example of a loop structure that nests For…Next statements\u003cbr\u003e 07-05 Understanding the syntax and usage of the Do… Loop statement\u003cbr\u003e 07-06 A practical example of escaping nested For…Next loops in one go.\u003cbr\u003e 07-07 How to structure and use the For Each…Next statement\u003cbr\u003e 07-08 Example of Using For…Next Loops to Loop Through an Array \u003cbr\u003e07-09 How to resolve (no response) issue when using loop\u003cbr\u003e\u003cbr\u003e CHAPTER 08 Function Procedure\u003cbr\u003e 08-01 How to create a function not provided in Excel or a higher version of a function\u003cbr\u003e 08-02 How to configure optional arguments when creating a function\u003cbr\u003e 08-03 How to store and use multiple arguments of a function to be created in a single array variable\u003cbr\u003e 08-04 How to set the exact error that the generated function will return\u003cbr\u003e 08-05 Do built-in functions (such as SUM) and user-developed functions behave differently?\u003cbr\u003e 08-06 What role do the ByRef and ByVal keywords play?\u003cbr\u003e 08-07 How to display the created function in the Function Wizard?\u003cbr\u003e 08-08 How to use user-created functions in all files?\u003cbr\u003e 08-09 How to disable and delete additional features\u003cbr\u003e\u003cbr\u003e CHAPTER 09 Error Handling and Speed ​​Improvement\u003cbr\u003e 09-01 Error Occurrence Situation and Response Method\u003cbr\u003e When does error 09-02 occur and how can I fix it?\u003cbr\u003e Essential Tools for Troubleshooting 09-03 Errors \u003cbr\u003e09-04 How to make the macro run only up to a specific line instead of the whole thing?\u003cbr\u003e 09-05 How to use the On Error statement to control situations where errors occur\u003cbr\u003e 09-06 How to optimize code by taking advantage of situations where errors occur\u003cbr\u003e 09-07 To increase the speed of macro execution, use the functions provided by Excel.\u003cbr\u003e 09-08 How to change Excel settings to speed up macro execution\u003cbr\u003e\u003cbr\u003e CHAPTER 10 VBA Built-in Functions\u003cbr\u003e 10-01 How to display the message window you need at the moment you want it\u003cbr\u003e 10-02 How to allow the user to input desired values ​​while running a macro?\u003cbr\u003e 10-03 How to allow selection of work range while running macro?\u003cbr\u003e 10-04 How to resize the MsgBox and InputBox dialog boxes\u003cbr\u003e 10-05 How are the Left, Mid, and Right functions different from Excel's built-in functions?\u003cbr\u003e 10-06 InStr function, which is identical to the Find function, and InStrRev function, which is only provided in VBA.\u003cbr\u003e 10-07 When checking whether a cell is empty, use the IsEmpty or Len function. \u003cbr\u003eReplace function used to modify or delete data stored in variables 10-08\u003cbr\u003e 10-09 How to use character codes with the Asc and Chr functions\u003cbr\u003e How to convert between numeric and text data types\u003cbr\u003e 10-11 Data Type Conversion Functions\u003cbr\u003e Data conversion using the 10-12 Format function\u003cbr\u003e 10-13 Function that returns today's date and current time\u003cbr\u003e 10-14 How to input and calculate dates using the DateSerial and DateValue functions\u003cbr\u003e Calculate date\/time before and after a certain period of time from the 10-15 reference point\u003cbr\u003e 10-16 How to return the upper unit of a date (year, quarter, month, etc.) using the DatePart function\u003cbr\u003e 10-17 How to calculate the difference between two dates (duration of employment)\u003cbr\u003e 10-18 How to calculate the time required using the Timer function\u003cbr\u003e 10-19 How to pass values ​​as an array using the Array function\u003cbr\u003e How to separate 10-20 data by a delimiter and store it in an array\u003cbr\u003e How to return values ​​in an array 10-21 by concatenating them with a delimiter\u003cbr\u003e How to enter a formula in cells 10-22 (or a range) \u003cbr\u003e10-23 How to Use Worksheet Functions in Macros\u003cbr\u003e How to resolve errors that occur when using worksheet functions in macros 10-24\u003cbr\u003e 10-25 Things to keep in mind when using date data in worksheet functions\u003cbr\u003e\u003cbr\u003e \u003cb\u003ePART 03 Main Objects of Excel Program\u003cbr\u003e\u003c\/b\u003e\u003cbr\u003e CHAPTER 11 Cell or Range Objects\u003cbr\u003e 11-01 Understanding the Key Members of a Range Object\u003cbr\u003e 11-02 How to refer to a cell (or range) with a Range object\u003cbr\u003e 11-03 How to reference a contiguous range with Ctrl + A\u003cbr\u003e 11-04 How to reference a dynamic range using Ctrl + arrow keys\u003cbr\u003e 11-05 How to reference a range that matches your desired conditions across the entire range\u003cbr\u003e 11-06 How to adjust the reference range using Offset and Resize\u003cbr\u003e 11-07 Differences between Value, Value2, Text, and Formula properties and how to use them\u003cbr\u003e 11-08 How to enter a formula or array formula in a cell\u003cbr\u003e 11-09 How to change cell display format using number format codes\u003cbr\u003e 11-10 How to use copy, cut, and paste \u003cbr\u003e11-11 How to copy and paste only part of a cell using Paste Selection\u003cbr\u003e 11-12 Transpose function and row\/column swapping\u003cbr\u003e How to copy and paste range 11-13 into a picture\u003cbr\u003e How to save tables 11-14 as image files\u003cbr\u003e 11-15 Difference between Clear Cell and Delete Cell Method\u003cbr\u003e 11-16 How to delete unused blank columns (or rows)\u003cbr\u003e 11-17 How to insert a row (or column) at a desired location\u003cbr\u003e Remove all hyperlinks in sheets 11-18\u003cbr\u003e 11-19 Automatically merge cells by recognizing empty cells in the selection range\u003cbr\u003e 11-20 How to develop VLOOKUP and XLOOKUP functions as macros\u003cbr\u003e 11-21 How to find a location that satisfies multiple conditions when searching for a value using the Find method\u003cbr\u003e 11-22 How to delete ghost texts\u003cbr\u003e 11-23 How to apply font and background formatting to subtotal rows using the Interior property\u003cbr\u003e 11-24 How to set the desired border format using the Border property\u003cbr\u003e 11-25 How to register an Excel table (ListObject)\u003cbr\u003e 11-26 How to reference an Excel table range \u003cbr\u003e11-27 Things to keep in mind when developing a macro that enters new data into an Excel table\u003cbr\u003e\u003cbr\u003e CHAPTER 12 Sheet Objects\u003cbr\u003e 12-01 Understanding the Key Members of the Worksheet Object\u003cbr\u003e 12-02 Understanding the Difference Between the Activate and Select Methods\u003cbr\u003e 12-03 How to change sheet tab names and things to watch out for\u003cbr\u003e 12-04 How to add a blank worksheet\u003cbr\u003e 12-05 How to delete unused sheets\u003cbr\u003e 12-06 How to create a table of contents sheet that can be moved to the entire sheet\u003cbr\u003e 12-07 How to move a sheet tab position or copy (or move) it to another file\u003cbr\u003e 12-08 How to arrange sheet tabs in the desired order\u003cbr\u003e How to hide or cancel a sheet 12-09\u003cbr\u003e How to protect or release sheets 12-10\u003cbr\u003e How to use the UsedRange property to return the entire range in use in sheet 12-11\u003cbr\u003e How to hide formulas entered in sheets 12-12 at once\u003cbr\u003e How to limit the range of selections in sheets 12-13\u003cbr\u003e 12-14 How to print only the sheets you want\u003cbr\u003e Print only specific parts of Table 12-15 by item \u003cbr\u003e12-16 How to print with desired information displayed in the header\/footer\u003cbr\u003e How to fit the width of pages 12-17 and repeat the title row\u003cbr\u003e\u003cbr\u003e CHAPTER 13 File (Workbook) Object\u003cbr\u003e 13-01 Understanding the Key Members of the Workbook Object\u003cbr\u003e 13-02 How to open Excel files and things to watch out for\u003cbr\u003e 13-03 How to select and open a file to work on\u003cbr\u003e 13-04 How to open multiple files at once for work\u003cbr\u003e 13-05 How to set the default folder when opening the [Open] dialog box using the GetOpenFilename method\u003cbr\u003e 13-06 How to merge files within a specific folder into one\u003cbr\u003e 13-07 How to reference data without opening the file\u003cbr\u003e 13-08 How to select a working folder directly\u003cbr\u003e 13-09 How to create a new blank workbook file\u003cbr\u003e 13-10 How to save the file you worked on\u003cbr\u003e How to create a daily backup file 13-11\u003cbr\u003e How to automatically save 13-12 xls format files as Excel 2007 or later file formats (xlsx, xlsm)\u003cbr\u003e 13-13 How to save each sheet as a separate file \u003cbr\u003e13-14 How to save the current sheet as a PDF file\u003cbr\u003e 13-15 How to convert a text file to an Excel file\u003cbr\u003e How to set up automatic deletion of files when their validity period expires\u003cbr\u003e\u003cbr\u003e CHAPTER 14 Excel Program (Application)\u003cbr\u003e 14-01 Key members of the Application object\u003cbr\u003e 14-02 How to Verify Excel Calculation Results Using the Calculator App\u003cbr\u003e 14-03 How to return the result of a calculation string\u003cbr\u003e 14-04 How to find the intersection and union range using the Intersect and Union methods\u003cbr\u003e 14-05 How to determine what object the user has selected using the Selection property\u003cbr\u003e 14-06 How to determine the target object that called the macro\u003cbr\u003e 14-07 How to select cells in a sheet that are not displayed on the screen\u003cbr\u003e 14-08 How to run a macro from another file\u003cbr\u003e 14-09 How to call and use the basic Excel dialog box from a macro\u003cbr\u003e 14-10 How to print by selecting the desired printer\u003cbr\u003e 14-11 How to display macro progress in the status bar \u003cbr\u003e14-12 How to cancel a macro execution midway\u003cbr\u003e 14-13 How to reset Excel settings to default\u003cbr\u003e 14-14 How to display desired tabs on the ribbon menu with a macro\u003cbr\u003e 14-15 How to hide or show the ribbon menu\u003cbr\u003e 14-16 How to control commands on the ribbon menu with macros\u003cbr\u003e 14-17 How to add desired commands to the shortcut menu\u003cbr\u003e How to remove the 14-18 Additional Features tab with a macro\u003cbr\u003e\u003cbr\u003e CHAPTER 15 Event\u003cbr\u003e 15-01 How to create an event\u003cbr\u003e 15-02 Understanding the Key Events of the Worksheet Object\u003cbr\u003e How to check the status of how many times you move to which sheet in the 15-03 file.\u003cbr\u003e 15-04 How to move selected data to a desired location and record it\u003cbr\u003e 15-05 How to limit copying to a range with validation set\u003cbr\u003e 15-06 How to make items already selected in the validation list no longer visible\u003cbr\u003e 15-07 How to initialize sublists when modifying the parent list of validation \u003cbr\u003e15-08 How to prevent data within a specific range from being modified without sheet protection\u003cbr\u003e 15-09 How to accumulate and sum the entered values ​​and record the details of the entered values\u003cbr\u003e 15-10 How to sort the column containing the double-clicked cell\u003cbr\u003e 15-11 Understanding Events of the Workbook Object\u003cbr\u003e 15-12 Differences between the Workbook_Open event and the Auto_Open macro\u003cbr\u003e How to use the Before_Close event that occurs when closing a file 15-13\u003cbr\u003e 15-14 How to prevent a file from being closed until a specific task is processed\u003cbr\u003e How to automatically create a backup file every time you save a file 15-15\u003cbr\u003e 15-16 How to print pages by dividing them by desired conditions\u003cbr\u003e 15-17 How to automatically create a blank form when inserting a new sheet\u003cbr\u003e 15-18 How to synchronize the display positions of two sheets\u003cbr\u003e 15-19 Event Priority\u003cbr\u003e How to use events that apply to all files 15-20\u003cbr\u003e How to use the Application object using the 15-21 class module \u003cbr\u003e15-22 How to schedule a macro to run at a specific time\u003cbr\u003e How to repeat a specific macro at regular intervals of 15-23\u003cbr\u003e 15-24 How to execute a desired macro with a specific keystroke\u003cbr\u003e\u003cbr\u003e CHAPTER 16 Custom Forms\u003cbr\u003e 16-01 Understanding Userforms\u003cbr\u003e 16-02 How to run and close the developed form\u003cbr\u003e 16-03 Understanding Active-X Controls in the Toolbox\u003cbr\u003e 16-04 How to use the Toolbox window\u003cbr\u003e 16-05 Understanding Form Control Properties and Events\u003cbr\u003e 16-06 How to create OK, Close, and Cancel buttons\u003cbr\u003e 16-07 How to set a hyperlink using a label control\u003cbr\u003e 16-08 Using the TextBox Control\u003cbr\u003e 16-09 How to enter numbers in a TextBox control\u003cbr\u003e 16-10 How to set up a TextBox to receive a password\u003cbr\u003e How to add a combo box to form 16-11\u003cbr\u003e 16-12 How to add only unique items from duplicate data to a combo box control\u003cbr\u003e 16-13 How to link two combo box controls\u003cbr\u003e 16-14 How to use the ListBox control \u003cbr\u003e16-15 How to multi-select ListBox items\u003cbr\u003e 16-16 How to find and search for ListBox items\u003cbr\u003e 16-17 How to pass or retrieve items between two ListBoxes\u003cbr\u003e 16-18 How to sort ListBox items\u003cbr\u003e 16-19 How to move ListBox items up\/down\u003cbr\u003e How to use the 16-20 CheckBox control\u003cbr\u003e 16-21 How to use the OptionButton control\u003cbr\u003e How to manage option buttons 16-22 by group\u003cbr\u003e 16-23 How to use the scroll bar and spin button\u003cbr\u003e How to add images to a 16-24 form\u003cbr\u003e RefEdit control used when referencing a range in form 16-25\u003cbr\u003e 16-26 TreeView Control I - Control Registration and Form Configuration\u003cbr\u003e 16-27 TreeView Control II - Control Settings\u003cbr\u003e 16-28 TreeView Control III - Interacting with Other Controls\u003cbr\u003e 16-29 TreeView Control IV - Learning Additional Properties\u003cbr\u003e 16-30 ListView Control I - Registering and Configuring the Form\u003cbr\u003e 16-31 ListView Control II - Setting Up the Control\u003cbr\u003e 16-32 ListView Control III - Sorting\u003cbr\u003e 16-33 ListView Control IV - Searching \u003cbr\u003eHow to change the font of multiple controls inserted into a form at once\u003cbr\u003e 16-35 How to align multiple control positions\u003cbr\u003e How to adjust the order of controls by pressing Tab on a form 16-36\u003cbr\u003e\u003cbr\u003e CHAPTER 17 Practical Application Form\u003cbr\u003e 17-01 Input Form I - Form Configuration\u003cbr\u003e 17-02 Input Form II - Form Initialization and Execution\u003cbr\u003e 17-03 Input Form III - Input Button Function Development\u003cbr\u003e 17-04 Search\/Edit Form I - Search Form Configuration\u003cbr\u003e 17-05 Search\/Edit Form II - Search Form Function Development\u003cbr\u003e 17-06 Search\/Edit Form III - Edit Form Development\u003cbr\u003e 17-07 Progress (Label Control) Display Form I - Form Configuration\u003cbr\u003e 17-08 Progress (Label Control) Display Form II - Macro Development\u003cbr\u003e 17-09 Progress (Label Control) Display Form III - Linking Macros and Forms\u003cbr\u003e 17-10 Progress Control Display Form I - Form Configuration\u003cbr\u003e 17-11 Progress Control Display Form II - Macro Development\u003cbr\u003e 17-12 Progress Control Display Form III - Form Linking\u003cbr\u003e 17-13 Chart Display Form I - Form Configuration\u003cbr\u003e 17-14 Chart Display Form II - Initializing the Form and Creating a Chart \u003cbr\u003e17-15 Chart Display Form III - Completing the Form\u003cbr\u003e 17-16 Wizard Form I - Form Configuration\u003cbr\u003e 17-17 Wizard Form II - Configuring Controls by Page\u003cbr\u003e 17-18 Wizard Form III - Development of step-by-step control functions\u003cbr\u003e 17-19 Wizard Form IV - Form Function Development\u003cbr\u003e\u003cbr\u003e \u003cb\u003ePART 04 Other Useful Development Methods\u003cbr\u003e\u003c\/b\u003e\u003cbr\u003e CHAPTER 18 Charts\u003cbr\u003e 18-01 How to create a chart in the desired location and size\u003cbr\u003e 18-02 Automatically change the chart source range to match the selection\u003cbr\u003e 18-03 How to display desired values ​​in chart data labels\u003cbr\u003e 18-04 How to align multiple charts without overlapping them\u003cbr\u003e How to apply the 18-05 chart event\u003cbr\u003e 18-06 How to highlight a line graph where the mouse pointer is located\u003cbr\u003e\u003cbr\u003e CHAPTER 19 Pivot Tables\u003cbr\u003e 19-01 Creating a PivotTable Report\u003cbr\u003e 19-02 How to create multiple analysis reports with pivots\u003cbr\u003e 19-03 Creating a Pivot Table by Setting Relationships\u003cbr\u003e 19-04 Automating Pivot Table Refresh\u003cbr\u003e 19-05 How to synchronize numbers in the value area with the format of the original table\u003cbr\u003e \u003cbr\u003eCHAPTER 20 How to use frequently used Excel functions\u003cbr\u003e 20-01 How to control automatic filters with macros\u003cbr\u003e 20-02 Copy\/paste into a table with auto-filter set\u003cbr\u003e 20-03 How to reset cell styles\u003cbr\u003e 20-04 Useful macros for users who use notes a lot\u003cbr\u003e 20-05 Modifying calculation results using [Find Target Value]\u003cbr\u003e 20-06 Easily Create a Survey Using Checkbox Controls\u003cbr\u003e\u003cbr\u003e CHAPTER 21 Manipulating the VB Editor\u003cbr\u003e 21-01 How to develop a macro to create (or delete) an event procedure\u003cbr\u003e How to automatically update macros using the 21-02 Module file\u003cbr\u003e 21-03 How to back up files by type of developed VBA code\u003cbr\u003e 21-04 Delete all VBA code in file\u003cbr\u003e\u003cbr\u003e CHAPTER 22 ADO\u003cbr\u003e 22-01 How to connect to another Excel file using ADO\u003cbr\u003e 22-02 How to Import an Access Table (or Query) into Excel\u003cbr\u003e 22-03 How to import data without opening another Excel file\u003cbr\u003e 22-04 Retrieving only the data that meets the desired conditions using SQL \u003cbr\u003e22-05 How to return external data to an Excel table\u003cbr\u003e 22-06 How to import external data by linking it with the desired delimiter\u003cbr\u003e 22-07 How to summarize external data and return results\u003cbr\u003e 22-08 Using Access tables and queries as pivot table sources\u003cbr\u003e 22-09 How to modify data without opening the file\u003cbr\u003e 22-10 How to add new data without opening an Excel file\u003cbr\u003e 22-11 How to add Excel data to an Access table\u003cbr\u003e 22-12 Consolidating data from multiple sheets into an Access table\u003cbr\u003e 22-13 Delete only data that meets specific conditions from an Access table\u003cbr\u003e\u003cbr\u003e CHAPTER 23 Macro Development Using ChatGPT\u003cbr\u003e 23-01 How to use ChatGPT to study macros?\u003cbr\u003e 23-02 How to get the code needed to develop macros using ChatGPT\u003cbr\u003e 23-03 Resolving macro errors using ChatGPT\u003cbr\u003e 23-04 How to Improve Code Efficiency Using ChatGPT\u003cbr\u003e 23-05 How to update macros using ChatGPT \u003cbr\u003e23-06 ChatGPT Use Case - Inserting Excel Charts into PowerPoint\u003cbr\u003e 23-07 ChatGPT Use Case - Converting a Purchase Order Sheet to PDF and Sending It via Outlook\u003cbr\u003e 23-08 ChatGPT Use Case - Web Data Crawling\u003cbr\u003e\u003cbr\u003e INDEX\u003c\/div\u003e\n\u003cdiv\u003e\u003c\/div\u003e\n\u003c\/div\u003e\n\u003cbr\u003e\u003cdiv\u003e\u003ch5\u003e \u003cb\u003eDetailed image\u003c\/b\u003e \u003c\/h5\u003e\u003c\/div\u003e\n\u003cdiv\u003e\u003cdiv\u003e\u003cimg src=\"https:\/\/image.yes24.com\/momo\/TopCate4192\/MidCate001\/419105145.jpg\" border=\"0\" alt=\"Detailed Image 1\"\u003e\u003c\/div\u003e\u003c\/div\u003e\n\u003cbr\u003e\u003cdiv\u003e\u003ch5\u003e \u003cb\u003ePublisher's Review\u003c\/b\u003e\n\u003c\/h5\u003e\u003c\/div\u003e\n\u003cdiv\u003e\n\u003cdiv\u003e \u003cb\u003eWhat kind of readers is this book for?\u003cbr\u003e\u003c\/b\u003e\u003cbr\u003e - Office workers who want to make daily repetitive Excel tasks easier and more convenient by using Excel macros and VBA.\u003cbr\u003e - Office workers who want to modify Excel VBA code to suit their work.\u003cbr\u003e - Office workers who want to learn advanced Excel functions extensively, apply them to their work, and improve work efficiency by automating tasks.\u003cbr\u003e - Office workers who want to learn Excel functions naturally by looking for necessary macro and VBA functions.\u003cbr\u003e - Office workers who want to learn how to utilize artificial intelligence, such as ChatGPT, a recent trend, in Excel macros.\u003cbr\u003e\u003cbr\u003e \u003cb\u003eFeatures of this book\u003cbr\u003e\u003cbr\u003e ㆍUse all versions\u003cbr\u003e\u003c\/b\u003e \u003cbr\u003eIt provides detailed and easy-to-understand basic grammar and code for handling Excel macros and VBA, helping you to use them effectively in your work.\u003cbr\u003e You can learn from all versions of Excel, including Excel 2010, 2013, 2016, 2019, 2021, and Microsoft 365.\u003cbr\u003e\u003cbr\u003e \u003cb\u003eㆍPractical application examples\u003cbr\u003e\u003c\/b\u003e\u003cbr\u003e The high-level examples essential for practical use were selected from the author's lectures, practical experience, and various cases obtained while operating Naver's representative Excel cafe, \"Excel...One a Day.\"\u003cbr\u003e You can experience practical macro \u0026amp; VBA examples optimized for learning.\u003cbr\u003e\u003cbr\u003e\u003cbr\u003e \u003cb\u003eㆍEasy-to-find configuration\u003cbr\u003e\u003c\/b\u003e\u003cbr\u003e It is impossible to memorize all the codes and syntax that make up Excel macros and VBA.\u003cbr\u003e This book is organized so that you can quickly find and use the code and examples you want whenever you need them.\u003cbr\u003e I put it on my desk and use it whenever I need to.\u003cbr\u003e\u003cbr\u003e \u003cb\u003eㆍChatGPT utilization macro \u0026amp; VBA learning method included\u003cbr\u003e\u003c\/b\u003e \u003cbr\u003eWe provide detailed guidance on how to utilize ChatGPT chatbot AI-powered macros and VBA, as well as learning know-how for readers who are not yet familiar with programming, and suggest ways to apply them in actual work. \u003cbr\u003e\n\n\u003c\/div\u003e\n\u003cdiv\u003e\u003c\/div\u003e\n\u003c\/div\u003e\n\u003c\/div\u003e\n\n\n\u003c\/div\u003e\n\n\u003ccenter\u003e\u003ctable\u003e\u003ctr\u003e\u003ctd style=\"height:10px\"\u003e\u003c\/td\u003e\u003c\/tr\u003e\u003c\/table\u003e\u003c\/center\u003e\n\n\u003ccenter\u003e\u003ctable\u003e\u003ctr\u003e\u003ctd style=\"height:10px\"\u003e\u003c\/td\u003e\u003c\/tr\u003e\u003c\/table\u003e\u003c\/center\u003e\n\n\u003cdiv style=\"width:95%;padding-top:20px;padding-bottom:20px\"\u003e\n\n\u003cdiv style=\"text-align:left;font-size:16px;font-weight:bold;padding-bottom:20px\"\u003e GOODS SPECIFICS \u003c\/div\u003e\n\n\u003cdiv style=\"text-align:left;font-size:14px;line-height:1.6em;\"\u003e\n\n\u003cdiv style=\"width:100%;margin-bottom:5px;line-height:1.6em;font-size:14px\"\u003e - \u003cstrong\u003eDate of issue:\u003c\/strong\u003e May 31, 2023\u003c\/div\u003e\n\n\u003cdiv style=\"width:100%;margin-bottom:5px;line-height:1.6em;font-size:14px\"\u003e - \u003cstrong\u003ePage count, weight, size:\u003c\/strong\u003e 1,100 pages | 2,214g | 188*258*45mm\u003c\/div\u003e\n\n\u003cdiv style=\"width:100%;margin-bottom:5px;line-height:1.6em;font-size:14px\"\u003e - \u003cstrong\u003eISBN13:\u003c\/strong\u003e 9791169210997\u003c\/div\u003e\n\n\u003cdiv style=\"width:100%;margin-bottom:5px;line-height:1.6em;font-size:14px\"\u003e - \u003cstrong\u003eISBN10:\u003c\/strong\u003e 1169210996 \u003c\/div\u003e\n\n\n\u003c\/div\u003e\n\n\n\u003c\/div\u003e\n\n\n\u003c\/div\u003e\n\n\u003ccenter\u003e\n\n\u003ccenter\u003e\u003ctable\u003e\u003ctr\u003e\u003ctd style=\"height:10px\"\u003e\u003c\/td\u003e\u003c\/tr\u003e\u003c\/table\u003e\u003c\/center\u003e\n\n\u003ccenter\u003e\u003ctable\u003e\u003ctr\u003e\u003ctd style=\"height:10px\"\u003e\u003c\/td\u003e\u003c\/tr\u003e\u003c\/table\u003e\u003c\/center\u003e\n\n\u003cspan\u003e\u003c\/span\u003e\n\n\u003c\/center\u003e\n\n\n\u003c\/center\u003e","brand":"LIBRAIRIE COREENNE","offers":[{"title":"Default Title","offer_id":43893226405930,"sku":"138282","price":73.0,"currency_code":"EUR","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0683\/2750\/5962\/files\/9bf0dec2bc6c7a58514290c09c7196ac.jpg?v=1765392591","url":"https:\/\/librairie.coreenne.fr\/en\/products\/138282","provider":"LIBRAIRIE COREENNE","version":"1.0","type":"link"}