why the file size is so large without any reason?

[msand]

I created two user forms in a new workbook. Althought i havent put any data in the workbook, it is now 2.78mb. I am very confused about this. Will userform and VBA code cost a lot of space? Please help. I would really appreciate.

 

[SydneyGeek]

For some reason, VBA code can inflate file sizes quite dramatically. Excel doesn't reclaim wasted space when you edit code. One solution is to compile the entire project, export all code modules and forms, delete them from the workbook, save, close, open, re-import all modules and code, save.
Messy but it often reduces the size...

Denis