Hi,
I am working on a Windows 8.1 tablet invoicing spreadsheet using Excel 2013. Rather than use the Windows 8 keyboard I have created my own custom keyboard using a userform and a qwerty key layout. The text typed appears in a textbox which controls a listbox of customer names. It works very well until I repeat click the same letter. E.g. Goodwood. The command button is slow to react with a second press (or click). This slows data entry for the user. I presume this is due to the click v double click event code.
Example code used:
Sub CommandButton9_Click()
Dim tmp As String
tmp = TextBox1.Value
TextBox1.Value = tmp & "o"
End Sub
Could anyone offer some ideas on how I can overcome this problem please?
Thanks.
Regards, Greg
I am working on a Windows 8.1 tablet invoicing spreadsheet using Excel 2013. Rather than use the Windows 8 keyboard I have created my own custom keyboard using a userform and a qwerty key layout. The text typed appears in a textbox which controls a listbox of customer names. It works very well until I repeat click the same letter. E.g. Goodwood. The command button is slow to react with a second press (or click). This slows data entry for the user. I presume this is due to the click v double click event code.
Example code used:
Sub CommandButton9_Click()
Dim tmp As String
tmp = TextBox1.Value
TextBox1.Value = tmp & "o"
End Sub
Could anyone offer some ideas on how I can overcome this problem please?
Thanks.
Regards, Greg
