This can be done, yes. Store the code in an XLA file that the buttons
reference. The actual code will depend on exactly what information you
want to place in exactly which cell(s).

The code is similar to VBA Access because it is VBA and shares a
certain common set of reserved words; VBA Access differs from VBA Excel
to the extent that commands used on a database will not be used on a
spreadsheet or Word document, for instance.