ActiveX focus issues when Freeze pane is used

[ssharkwsk]

Dear Colleagues,

I am facing a weird problem and would like to know if you have faced similar problems

1. I am using Microsoft® Excel® for Microsoft 365 MSO (Version 2202 Build 16.0.14931.20652) 64-bit
2. I have a macro enabled sheet with VBA code. One of the sheet includes input fields via Cells, ActiveX ComboBox and then a CommandButton to submit data
3. I would like to jump between the Cell, ComboBox & CommandButton using tab key for quick data entry
4. My VBA code is working as expected to jump between controls/cells

However, I have seen an issue, where if I freeze the pane above where my ActiveX controls are positioned, the first focus does not work properly towards ActiveX controls. If you open the attached sheet, enable contents and then select Cell C7 and then press "TAB" key, it the cursor should show up inside the combobox, however it does not. If you press TAB few times to circle back to the ComboBox second time, the focus cursor shows up. This "first time focus issue" does not happen if I remove the freeze pane.

Let me know if you see anything that I should be doing. I am using ActiveX controls because I feel they have more control/program-ability

Thank You

//SharkWsk

 

[ssharkwsk]

 

[lotsofexcel]

Hi #ssharkwsk. I'm not having the same issue as you, but I wonder if they're somehow related? Basically, when I freeze panes in Excel and then try to use "PAGE DOWN" on the keyboard to move the selected cell down the spreadsheet, the selected cell doesn't move down the spreadsheet, rather it jumps up to the frozen rows (the spreadsheet view scrolls down but the selected cell jumps to the top of sheet). Seems like there's some bug related to Freeze Panes that can cause Excel to redirect the selected cell/object. The only solution I've seen people mention sounds like a full reinstall of everything on the computer

In your example, when you first press "TAB" after selecting Cell C7, where does the cursor/active cell go?

Here are some related threads:

Freeze pane bug when using Alt pg dn /up

I'm using Office 365, and recently I've been having this issue that when I try to scroll horizontally with Alt Pg up/dn the view changes to the correct screen but my cursor goes back to column A. I've tried the following: Uninstalled all add-ins - didn't work Safe mode - didn't work Unfreeze...

www.mrexcel.com

Problem with freeze panes

Hi, I am using Office 365 and am looking for a solution or what's the cause for the following: On a new spreadsheet, let's say I freeze panes in cell C3. Normally Ctrl+Home should get you to cell A1 or, in case freeze panes is activated, the the first cell of the unfrozen area, here C3...

www.mrexcel.com

Redirecting