Mhelp4Ucom‎ > ‎Office 2007 ▼‎ > ‎Excel 2007 ▼‎ > ‎

How to create an input box using macros in Excel

                                                        Contact us for Site Advertising Rates & Metrics    

                                                                           

                                                                                                                                                 Report Errors & Bugs

 


                                          How to create an input box using macros in Excel

                                                                          This Mhelp clip will show you how to create an input box using macros in Excel.

                                                                                    This Mhelp clip has twelve steps.
                                                                                    1 - Click the View tab.
                                                                                    2 - Under Macros, click Macros. A menu will appear.
                                                                                    3 - Click View Macros. A dialog box will appear.
                                                                                    4 - Under Macro name, type a name for the macro.
                                                                                    5 - Click Create. A window will appear.
                                                                                    6 - Type the code for your macro. 
                                                                                    7 - Close the window when finished.
                                                                                    8 - Click the View tab.
                                                                                    9 - Under Macros, click Macros. A menu will appear.
                                                                                   10 - Click View Macros. A dialog box will appear.
                                                                                   11 - Click the macro that was created.
                                                                                   12 - Click Run.

                Note: When this macro is used a prompt will appear asking for the user's name. It will then display a dialog box saying hello to the user.

                                                                                This concludes the Mhelp clip.