HOW TO MAKE BACK BUTTOM IN MS EXCEL
MICROSOFT EXCEL IMPORTANT TRIICKS Hello Friends You Can See and Watching video for Microsoft Excel Best Most Two Important Tech. Lets Get Start:- Please Follow This Site And Subscription This Website. 👇👇👇👇👇👇 Can you See Excel Video
To create a "Back" button in MS Excel, you can follow these steps:
1. Insert a shape: Go to the "Insert" tab in the Excel ribbon and click on the "Shapes" button. Select a shape that you would like to use as your back button. Typically, a rectangle or rounded rectangle shape works well for this purpose.
2. Customize the shape: After inserting the shape, you can customize it to resemble a button. Right-click on the shape and choose "Edit Text" to add a label such as "Back" or an arrow symbol. You can also adjust the size, color, and formatting of the shape to make it more visually appealing.
3. Assign a macro: Right-click on the shape and select "Assign Macro" from the context menu. In the "Assign Macro" dialog box, click on "New" to create a new macro for the back button.
4. Write the macro code: The Visual Basic Editor will open, showing an empty code module for the new macro. Write the desired VBA code that specifies the action to be performed when the back button is clicked. For example, you can use the VBA code `Application. Go to Reference:="Previous Sheet"` to go to the previous sheet or any custom code to go back to a specific location, depending on your needs.
5. Save and close the VBA Editor: After writing the macro code, save the code module and close the VBA Editor.
6. Test the back button: Return to the Excel worksheet and click on the back button you created. The macro code will be executed, performing the action specified in the code.
By following these steps, you can create a back button in Excel using VBA macros to navigate within your workbook or perform custom actions when the button is clicked.
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjO4-RllGpiXY2ftKnfdC2dgbx2LHUGIEAhlLGcV1NVu0mYrvfi6BaZxhocIBw9lRwnK7L_QCAghNmva009Mxa6fwg3TrZJDT_r2B-5wAvnNa2UdxiOUap8eGbaE89ttpnPM1P_Jj4PWthMyOFBz6vd0b43DzemnW-RMhLaLJ6-yHee_L9er_rBlmFnMA/s320/01f---.jpg)
Dear Friends Look at This (Note)
We
Have Brought You A New Tutorial Online Site Where You Will Get New Videos
Daily. If You Like Watching Our Videos Or Like For Education Then You Can Stay
With Us And Join The Site As A Member. There Is A Contact System Above, If You
Want You Can Contact Via Call/Mail. We Have A YouTube Channel And A Facebook
Page. If You Want, You Can Join
Thanks
For Visit Our Website