Good day all. Hoping there's a good samaritan out there that can help me for a minute. The reason I joined this forum today was to research whether anyone else was having delayed responses when using active x comboboxes in 2013.
What I have is very basic, the combobox is linked to a dynamic named range (using offset formula), with about 20 items only.
User can type extra data into the selected item.
The code behind it is just a keydown to prevent arrow keys from flipping the users data by accident and a gotfocus to populate the listfillrange and dropdown, so user doesn't have to click the drop down arrow..
The combobox is linked to a cell in a separate sheet.
The unresponsive aspect is, all of sudden, when user types into combobox, you can't see what you're typing until user exits the combobox.
It's so annoying it makes me want to bang my head.
Also, it feels like the cursor hides as you type, which I hate. The mouse control isn't set to hide while typing for sure.
Also, my file is being slow and unresponsive too it is about 1,000 KB. I recently got rid of a sheet that really wasn't needed which trimmed the size down to 700 kb, but still didn't do any good.
Any thoughts?
It would be appreciated.
*revised:
I thought it was due to file size which is about 1,000 KB. I recently got rid of a sheet that really wasn't needed which trimmed the size down to 700 kb, but still didn't do any good.
*In addition, all comboboxes are doing this I have less than 20.
What I have is very basic, the combobox is linked to a dynamic named range (using offset formula), with about 20 items only.
User can type extra data into the selected item.
The code behind it is just a keydown to prevent arrow keys from flipping the users data by accident and a gotfocus to populate the listfillrange and dropdown, so user doesn't have to click the drop down arrow..
The combobox is linked to a cell in a separate sheet.
The unresponsive aspect is, all of sudden, when user types into combobox, you can't see what you're typing until user exits the combobox.
It's so annoying it makes me want to bang my head.
Also, it feels like the cursor hides as you type, which I hate. The mouse control isn't set to hide while typing for sure.
Also, my file is being slow and unresponsive too it is about 1,000 KB. I recently got rid of a sheet that really wasn't needed which trimmed the size down to 700 kb, but still didn't do any good.
Any thoughts?
It would be appreciated.
*revised:
I thought it was due to file size which is about 1,000 KB. I recently got rid of a sheet that really wasn't needed which trimmed the size down to 700 kb, but still didn't do any good.
*In addition, all comboboxes are doing this I have less than 20.
Last edited by a moderator: