function shortcuts

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Function shortcuts

Function shortcuts

resolvedResolved · Low Priority · Version 2003

Justine has attended:
Excel Advanced course
Excel VBA Intro Intermediate course
Excel VBA Advanced course

Function shortcuts

Are you able to assign a button to your own functions that you create like you can for a macro?

RE: Function shortcuts


Hi Justine

Hope you are well and sorry for not getting back to you before now

The answer to your question is that you can only assign Macro's and hyperlinks to button on your toolbar, if you need anything else don't hesitate to ask

If this has answered your query then I would request you to please mark the question as Resolved!! If not and you have a specific question related to this then please click Reply or post it as a new question and we should be able to answer that!!

Many Thanks

Mark East
MOUS Master Instructor

Mark@stl-training.co.uk



 

Excel tip:

Generate randon numbers

Some types of analysis require you to use randomly generated numbers. You can also use randomly generated numbers to quickly populate an Excel spreadsheet. There's an easy function you can use to do this automatically. Here are a few of the ways you can use it:

Type =RAND() in a cell to generate a number between 0 and 1.
Type =RAND()*100 to generate a number between 1 and 100.

View all Excel hints and tips


Server loaded in 0.09 secs.