Dec 1, 2003 #1 sjh Programmer Joined Oct 29, 2001 Messages 263 Location US Does F2 key in Excel have a functionality? When I select a cell in excel sheet and click on the F2 key, does it fire some event? Thank you, SJH
Does F2 key in Excel have a functionality? When I select a cell in excel sheet and click on the F2 key, does it fire some event? Thank you, SJH
Dec 1, 2003 #2 Mikeb1970 Technical User Joined Nov 14, 2003 Messages 101 Location BE It wil open the cell for editing, you can change the contains. That is all it does With regards Mike Upvote 0 Downvote
Dec 1, 2003 #3 S SkipVought Programmer Joined Dec 4, 2001 Messages 47,492 Location US Hi sjh, When you SELECT a range in Excel, it fires the Worksheet_SelectionChange and Workbook_SheetSelectionChange events. There is no event with the F2 key. However, you could use the OnKey Method. Skip, Skip@TheOfficeExperts.com http://www.TheOfficeExperts.com Upvote 0 Downvote
Hi sjh, When you SELECT a range in Excel, it fires the Worksheet_SelectionChange and Workbook_SheetSelectionChange events. There is no event with the F2 key. However, you could use the OnKey Method. Skip, Skip@TheOfficeExperts.com http://www.TheOfficeExperts.com