I am having MS-Excel 2003 at home and office and I am learning VBA. I had a few hesitations with this particular question (whether it is concerned with VBA or not!)
On any worksheet bottom tab when we right click and choose "Insert" option there is an option to insert
1. Macro 4.0
2. Dialog 5.0
Regards,
--------------------------------------------------------------------------------------------------------
Shrivallabha
--------------------------------------------------------------------------------------------------------
Using Excel 2016 in Home / 2010 in Office
--------------------------------------------------------------------------------------------------------
I think these are old macro creation items. You should use the Visual Basic Editor (VBE) to add code modules, Userforms etc. Press Alt+F11 to open it.
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
Posting Permissions
Reply With Quote