Solved Excel 2024 F8 issue in VBA Now Resolved

[smiler44]

I have a macro created on execl 2007 and have moved the workbook to another laptop running excel 2024

If I use the F8 key to step through the code it takes me to the desk top screen and locks the laptop.

How do I make the F8 key step through the code or is there a different button to use?

thanks

smiler44

 

[Gasman]

I would have though that was to do with the laptop?
What make and model is it?

 

[smiler44]

I would have though that was to do with the laptop?
What make and model is it?

Acer Aspier 5

smiler44

 

[The_Doc_Man]

What version of Windows?

 

[smiler44]

What version of Windows?

11
I am also Googling for an answer but not found it yet

smiler44

 

[The_Doc_Man]

In follow-up, does your laptop have a function (FN) key? (Probably next to the right-side ALT key.) If so it may be that function-lock is engaged.

How do I use the Fn key/F Lock key/Alternate command keys? - Microsoft Support

This article shows you how to use the Fn key and the F lock key.

support.microsoft.com

 

[The_Doc_Man]

FYI, the search string for this problem is "F1-F12 keys not working" which gets me to a pot-load of apparently relevant articles.

 

[smiler44]

I have result. Seems that if I press and hold down the fn key, F8 to tab line by line through the code works .
Can this be automated?

smiler44

 

[smiler44]

In follow-up, does your laptop have a function (FN) key? (Probably next to the right-side ALT key.) If so it may be that function-lock is engaged.

How do I use the Fn key/F Lock key/Alternate command keys? - Microsoft Support

This article shows you how to use the Fn key and the F lock key.

support.microsoft.com

Thanks buddy, I was typing as you posted. Yes pressing FN allows me to use f8, thank you.

smiler44

 

[The_Doc_Man]

One of the articles I found for that search discusses "function lock" (FN ESC) as a way to release ALL of the keys to be captured by Access rather than be intercepted by Windows. Or maybe I said that backwards as to which one does the capturing and which one does the intercepting. But I think you get the idea.

 

[Gasman]

I have result. Seems that if I press and hold down the fn key, F8 to tab line by line through the code works .
Can this be automated?

smiler44

I doubt it. I use an external keyboard at home and standard f5 f8 works. With my laptop here in Mexico I have to use the fn key. That is standard for most laptops?

 

[Isaac]

I have a macro created on execl 2007 and have moved the workbook to another laptop running excel 2024

If I use the F8 key to step through the code it takes me to the desk top screen and locks the laptop.

How do I make the F8 key step through the code or is there a different button to use?

thanks

smiler44

It's a confusion between function keys and f8, you're not really hitting f8

 

[GPGeorge]

As you've learned, laptops require the use of a specific key, often labelled "Fcn" or "Fn" or some similar abbreviation, in conjunction with the F keys (F1 through F12) to invoke the action of the F keys on a regular keyboard. F8 by itself does something quite different.

I am not sure what you mean by "automating" something, though. Are you talking about automating the key combination, or are you talking about automating the line-by-line code step through?

I suppose that some laptop manufacturers could allow you to remap keys on their keyboards. Or you could try something like this: https://www.microsoft.com/en-us/windows/learning-center/how-to-remap-your-keyboard

 

[The_Doc_Man]

There is the equivalent of CAPS LOCK called Function Lock that you can look up, involving the FN key and (usually) the ESC key. One way, the FN keys are mapped for common actions like mail or browser commands. The other way, programs like Excel and Access can use the F1-F12 keys as the programs intended.

 

[Isaac]

That is one of the reasons I hate laptops and never use them. I mean I use them it's all I use actually, but always with a real keyboard and a monitor (s). My current laptop is so stupid it labels certain things for function but then it really wants you to hold down the shift key it makes no sense.
Too many overloaded keys for things nobody needs