Using command buttons to enter data

[Guest]

Hi,
I notice on the tool bar in Excel there are options to put command buttons
etc into an excel spreadsheet. I have done this, however would appreciate
any info on how to program the command buttons. I notice that this has to be
done through visual basic which is fine, but the code required is obviousley
very different to that used in microsoft Access(?) Microsoft access has the
option of using a wizard to creat the commands, but this doesnt seem to be
the case for excel(?)
Can command buttons actually be used to input data into cells when clicked?

Any suggestions or examples of code required would be a great help.

Many thanks

Nick

 

[Dave O]

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.