Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Form controls behaving erratically

0

Hi,

I am using the up/down arrow "form control" in a spread sheet. I have noticed that the buttons work fine for a short while after the file has been opened but then begin to behave erratically as follows:

1) They either become completely unresponsive or

2) Both behave as "up" arrows.

As a "fix", sometimes the error seems to correct itself at random, or when I click away from the current tab, or (mostly) when I save the file and then re-opened it - but there seems to be no rhyme or reason to this! However, even then the issue soon re-emerges. 

I have been using this feature for a long time without encountering this problem. 

Does anyone know how to fix this problem or is this an Excel bug?

Thank you.

P.S. My Excel version is 2207, Build 15427.20210

Answer
Discuss

Discussion

Hi Zico and welcome to the Forum

I've never had that happen exactly but had strange things occur as the battery in my wireless keyboard or mouse was very low voltage and about to fail.

If you EDIT your question and use the Add Files... button to attach your file, I could see if it works okay for me (but I guess you did that with a colleague). 
John_Ru (rep: 4022) Aug 17, '22 at 4:10 pm
Hi John,

Many thanks for taking the time to reply and for your suggestion. However, the mystery persists, albeit in a localised form! Let me explain:

You had guessed that I might have tested this issue on another computer. As logical as this sounds, it had not crossed my mind, I must admit - the obvious often illudes us!

So I did test the spreadsheet on an old computer of mine but was unable to replicate the issue, despite numerous attempts. This is an unsatisfactory outcome as it points to my brand new computer (HP Envy) as the culprit, which I can not explain away! Unfortunately, this also implies that others might experience this problem when using the spreadsheet, depending on their computer...

I appreciate your kind offer to test the spreadsheet, which will be included. 

Regards,

Zico 
Zico (rep: 2) Aug 18, '22 at 9:44 am
Thanks Zico,  I'll l try your spreadsheet when I'm home later but is your new computer running Windows 11 or the same OS as your old machine? 
John_Ru (rep: 4022) Aug 18, '22 at 10:53 am
Thank you, John. Windows 10 on the old computer but the same version of Excel. 

Zico. 
Zico (rep: 2) Aug 18, '22 at 11:34 am
What's the OS on your new machine? 
John_Ru (rep: 4022) Aug 18, '22 at 11:37 am
W11
Zico (rep: 2) Aug 18, '22 at 12:46 pm
Zico

I don't have Windows 11 but your file works well on Excel365 running on Windows 10. I mean the spin button on sheets numbers 1. (e.g. cell G7), 2; and 3. work as expected.

After about 15 minutes, they operate just the same.

Can't really help you but it might be a mouse or touchpad driver issue (not sure)
John_Ru (rep: 4022) Aug 18, '22 at 1:12 pm
Much obliged for your time and assistance, John.

Hope to hear from others on the forum on this. 

Have a good day. 
Zico (rep: 2) Aug 18, '22 at 1:16 pm
Add to Discussion



Answer the Question

You must create an account to use the forum. Create an Account or Login