Forum home » Delegate support and help forum » Microsoft Excel Training and help » Toolbox

Toolbox

ResolvedVersion 2003

Fri 14 Nov 2008, 16:32 Delegate Oslak said...

Oslak has attended:
Excel Advanced course

Toolbox

How to use control toolbox in relation with macros? How to use it for create report?

Mon 24 Nov 2008, 09:55 Trainer Simon said...

RE: Toolbox

Hi Oslak,

Thank you for your question.

The first thing you need to do is to record the macro. Open the Forms toolbar and create a Button. After you have drawn the Button, a dialogue box should appear asking you which macro you would like to associate the button with. Select the relevant macro and click ok.

I hope this answers your question.

Regards

Simon

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Customize the toolbar in Excel 2010

You can create your own toolbar which contains your favourite or most used tools. This will make using Excel much more efficient. To do this, you need to click on View, then select Customize Quick access Toolbars and then select Customize. A list of tools will then appear on the screen of which you can add or remove them as you please.

View all Excel hints and tips

Toolbox

Toolbox

RE: Toolbox

Excel articles

Excel tip:

Customize the toolbar in Excel 2010