Free Microsoft Excel 2013
Quick Reference
Free Microsoft 2013 Quick Reference Guide

Free Microsoft Excel 2013 Quick Reference

Assign commands to function keys

The AA where I works swears up-and-down that she is able, using Excel
2000, to assign Excel function to the function keys (F1-F12). I would
like to move her to Excel 2003, but I cannot find this capability.

Two questions:
1) Is she correct? That is, does this functionality exist with earlier
versions of Excel?
2) Is it possible to assign Excel functions to Function keys in Excel
2003?

Thank you.

Gerry


Post your answer or comment

comments powered by Disqus
Is there a way to assign a function key (ie. F1) to run a excell 2000 macro? Looked through forum but couldn't find anything.

Hi I want to assign a CTRL + (any key) to the Edit -> Paste Special command.
Any suggestions.. and how do I make sure that the combination hasn't already
been assigned?

note : if I use &S shortcut I have to open the edit menu first, so it takes
two key presses..

Thanks!!

HI,

In a file that I use vrey regularly I am probably doing a certain function 100 or more times a day and am too clueless to make a macro for it and assign a hotkey. I would LOVE some help with this.

Here's what I am doing. I hit "Alt-E" then "D" then "U" then enter.... this basically just deletes the current cell and shifts the cells below it UP...

please, my hands will thank you, can we make it so all I have to do is hit a function key and it will do this?

THANKS!

I have a addin that contains user defined functions. I am using the MacroOptions command to assign the functions to categories. The addin loads without any problem in Excel 2003. In Excel 2002 and Excel 2007 Beta, if I open Excel and load the addin using the menu the addin loads OK. But when I try to open Excel with the addin already installed I get the following error message:

Run-time error '1004':
Method 'MacroOptions' of object'_Application' failed

Any suggestions on how to aviod this error message in Excel 2002 and Excel 2007 Beta?

I use a lot of symbols in Excel using the alt-0-1-6-2 type keystrokes. After doing this for the 5 millionth time, I thought... there must be an easier way! I didn't find an answer in my searching.

Is there a way to assign a symbol (such as Ø (keystrokes alt2106)) to an F key at the top of the keyboard? Something easy so I could just hit the key just like any other letter, I don't necessarily want to have to execute a macro.

Thanks
Scott

I usually create a command button and right click to select "assign marco" to assign to command button. But this time, i can not find this "assign macro" selection when I right click commandbutton I just created. where can I find this option other than from right click commandbutton?

Kindly let me know the following:-

I would like to copy all the Excel shortcuts and functions keys from the Microsoft Excel help and paste to a new MS Word document.

The problem is after I pasted to the MS Word document, I see lots of lines or border line in the MS Word document.

Kindly let me know the way to delete those lines. Maybe I should just paste those shortcuts and functions in a new Excel worksheet?

Thank you

Susan

I got a new computer at work. The insert function key on my previous excel
software on my previous computer had been changed so that it permanently
showed an equal sign, instead of the fx characters. Thereby eliminating the
need to select the "sum" option in the function box. I used this = sign
feature all the time as I edited numbers in a cell. I would need to add an
additional figure to an existing figure in a cell. And to do so, I would go
to the cell, click on the = sign (just in front of the formula bar) and it
would automatically allow me to just hit + and the additional number without
having to go select "Sum" first. When I got the equal sign was no longer
there, just the fx. I need to know how to change the fx to the equal sign.
Hopefully this makes sense. (version Exel 2003)

Please inform me how to assign a single desired key, when pressed to input
long data.

For eg:
Assign key "A" to input 377.88998774, instead of typing in the cells several
times

I use SmartTerm as a terminal emulator. It uses a function key F17 (alt F7)
frequently. I often store frequently used prompts in Excel, then copy and
paste to the emulator. Does anyone know of a way to store the F17 in Excel,
such that I can copy & paste it to my emulator?

I'm trying to assign a shortcut key like this:

but it's not working....  the % is the symbol for Alt key, and the 1 is a symbol for 1 at the top fot the key board (not the
number pad 1).  Is there a special symbol for 1 I need to be using?  Also, would like to assign shortcuts to the 2 and 3
keys: Alt+2, Alt+3, are there special symbols for 2 and 3?

Thank you

marco recorder allows you to record an onkey macro suck as on key CTRL+t execute procedure however i have a workbook with 80+ worksheets and only want the onkey command to work on certain sheets, can this command be assigned into the code i any particular worksheet if so how?
i know that the command is application.onkey "^{t}" for the above onkey command but this does not seem to work when i enter it into vba cose for a particular worksheet please advise thanks

Hello everyone,

I am using VBA code to create a command button on a sheet:

ActiveSheet.OLEObjects.Add(ClassType:="Forms.CommandButton.1", Link:=False, _
DisplayAsIcon:=False, Left:=190.5, Top:=38.25, Width:=97.5, Height:=20.25).Select
Does anybody know how to assign code to OnClick event to the button using VBA?

Any help appreciated.
surotkin

I would like to assign a function key on my kaypad to convert a number into a
time number - ie; enter 2330 on key pad and have it converted to 23:30 in
excel

Basically, I want to stay on the keypad without having to enter the ":" key

I got a new computer at work. The insert function key on my previous excel
software on my previous computer had been changed so that it permanently
showed an equal sign, instead of the fx characters. Thereby eliminating the
need to select the "sum" option in the function box. I used this = sign
feature all the time as I edited numbers in a cell. I would need to add an
additional figure to an existing figure in a cell. And to do so, I would go
to the cell, click on the = sign (just in front of the formula bar) and it
would automatically allow me to just hit + and the additional number without
having to go select "Sum" first. When I got the equal sign was no longer
there, just the fx. I need to know how to change the fx to the equal sign.
Hopefully this makes sense. (version Exel 2003)

Hi, I have 18 ComboBoxes on UserForm2, all with the same "Change Event" code below (the only thing that changes between each one is the ComboBox #). This code is currently working, but I would like to reduce the duplication of identical commands in each ComboBox_Change event.


	VB:
	
 ComboBox1_Change() 
    Dim wsName As String 
    Dim cbLinkedCell As String 
     
    cbLinkedCell = ComboBox1.ControlSource 
     
    Range(cbLinkedCell).Value = ComboBox1.Value 
    Unload Me 
    Range(cbLinkedCell).Select 
    wsName = ActiveCell.Offset(0, 1).Value 
    If ActiveCell.Value > 0 Then 
        Sheets(wsName).Visible = True 
        Worksheets(wsName).Move Before:=Sheets(ActiveCell.Value) 
        aQuery0.Select 
    Else 
        Sheets(wsName).Visible = False 
        aQuery0.Select 
    End If 
     
    UserForm2.Show 
End Sub 

If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines
I am trying to change all 18 ComboBox "Change Events" to the following and have each one of them call the generic cbChange sub. When I run this code I get an error Run-time error '91': Object variable or With block variable not set on line CurBox = UserForm2.ComboBox1. How can I assign ComboBox1 to a variable so it can be passed to the cbChange sub?


	VB:
	
 
 
Private Sub ComboBox1_Change() 
     
    curBox = UserForm2.ComboBox1 
     
    Call cbChange 
     
End Sub 
 
 
 
Private Sub cbChange() 
     
    Dim wsName As String 
    Dim cbLinkedCell As String 
     
    cbLinkedCell = curBox.ControlSource 
     
    Range(cbLinkedCell).Value = curBox.Value 
    Unload Me 
    Range(cbLinkedCell).Select 
    wsName = ActiveCell.Offset(0, 1).Value 
    If ActiveCell.Value > 0 Then 
        Sheets(wsName).Visible = True 
        Worksheets(wsName).Move Before:=Sheets(ActiveCell.Value) 
        aQuery0.Select 
    Else 
        Sheets(wsName).Visible = False 
        aQuery0.Select 
    End If 
     
    UserForm2.Show 
End Sub 

If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines
Any help would be greatly appreciated!

Thanks,
Brad

I am trying to assign a list of players onto teams but I need to distribute "skill" evenly to ensure teams are equally matched.

A statistician in the league suggested the best way to do this might be to sort the player list (descending) by the measure of "skill", then start assigning teams in blocks. If I have 40 players in the league / 4 teams = 10 players per team. I would randomize the numbers 1-4 (e.g. 3 1 4 2) and assign them to the first four players, randomize another set of 1-4, assign them to the next, and so on...

I could then sort the player list by “team assignment” column and have hypothetically equal skill on every team.

Couple of complications... number of players and teams might vary season to season. I will have to enter in number of teams and number of players at the beginning of each season along with a new list of their stats. Also, although I have a limited knowledge of Excel and VBA, none of the other coaches do so I want to make this as idiot proof as possible.

Using various macros (or functions) I found here I was able to randomize the first "block" of players but I cannot complete the randomizations for the remainder of the list. The only solution I have found would be to manually create an array using the “RandUnique” function over X (depending on number of teams) cells and then copy and paste this randomized subset down the rest of the player list.

See attached for sample data.

From the Control Toolbox I click on the command button icon. I positon the mouse where I'd like to place the command button and draw the command button. Then right click to open the drop down menu. A few days ago in the drop down menu I had an option Assign Macro but now I don't have it anymore. How is it possible to assign macros to the command button and even better how can I get the Assign Macro option back in the drop down menu?

Thank you

Kenneth Bartolo

My situation is this, I am using the address function. The address function ask for the spread sheet in which the cell that you are interested is located. The spread sheet needs to have quotes around it for the address function to work correctly. So if the spreadsheet is called October then the address fucntion would look like this


	VB:
	
Address(1,2,1,1,"October") 
 
 'I am trying to assign quotes to a string variable.
 'The code that I am trying to do is the following
 
 
mysheet2 = ""October"" 
ActiveCell.FormulaR1C1 = "=Indirect(Address(" & Newrow2 & ",6,1,1," & mysheet2 & "),1)" 

If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines

Any help that I anyone offers will be greatly appreciate. I know this is probably a very easy, but for some reason I am just not seeing the answer. Again thank you for your help.
Sincerely,

Jay

I have various function keys defined. If I click on a cell and do not start typing any characters in the cell the function keys I have defined work as defined. If I start typing in the cell and then hit a function key that I have defined, I get the Excel defined function (like help) instead of my function key. Is there a way to force Excel to use my function key routines instead of the Excel functions? Can I then set them back to the Excel definitions? Thanks.

Say I click on a cell and want a function key available to run a specific routine. I can do this with ONKEY and it works OK. However, if I type something in the cell and then kit F1 I get the excel routine for HELP instead of the routine I have designated for F1. Is there any way to force excel to use my ONKEY routine instead of its own routine for that function key.

Hello,
I would like to, for example, be able to make a list of items in all lower case and then use the function key PROPER to capitolize the first letter of the entire list. Is there a way to do this without inserting a column for the result?
Thanks!
Michelle

Hello

I have gotten a little bit further with my problem...found out how to get SQL commands to work on an Excel database. The following works:

SELECT *
FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',
'Data Source="c:ExternalMyExcel.xls";
User ID=Admin;Password=;Extended properties=Excel 8.0')...Book1$

However, if I change the SELECT command to an UPDATE, query analyser reports a success - however, when I try to open the Excel document in question, I get an MS error report and after a repair the document is still corrupted.

Does anyone have any experience of performing such functions who could help me out?

Thanks in advance...

I have a Compaq nc8430 business laptop and installed the drivers for an
ergonomic Microsoft keyboard. Since last week, I no longer able to use any of
the Function keys. I tried several applications and it's the same on all of
them. The porblem is experienced in both, the internal and external keyboard.

I removed the Microsoft keyboard based on a knowledge based articled that
referenced a possible conflict. In addition, I uninstalled the external
keyboard drivers from my computer. However, I'm still not able to get the
function keys to work.

Technical Info: Windows XP Pro with Service Pack 2

I really depend on the F4 Function Key for many of my tasks within MS Excel.
Any ideas?


No luck finding an answer? You could always try Google.