backspace

Hello all. I have this annoying issue on VBE for Excel where it lags when I use the backspace key to edit any properties of any object in VBE. For example, a Userform Caption. I believe it is not due to my keyboard settings because everywhere else the backspace key works with no delay at all...

I thought this was going to be easy as Private Sub Workbook_Activate() Application.OnKey "{BACKSPACE}" Application.OnKey "{DELETE}" End Sub Private Sub Workbook_Deactivate() Application.OnKey "{BACKSPACE}" Application.OnKey "{DELETE}"End Sub Apparently its not working when...

All, [Using Win10 and Office 365 Business (Excel 2016?). I don't have any other versions of Office/Excel installed.] When I'm editing a form's property, like Caption, when I use the backspace key (to delete values), there is a very noticeable lag/delay for each key stroke. If I use the Delete...

Hi, Please can someone help me? I have found the following code that disables the delete and backspace keys to all my sheets apart from the last sheet. I was wondering if anyone knows how to modify it so it only works on sheet3 or better still limiting it to the range of D40:BM40 on sheet3...

Hi I want to use Backspace key to delete last letter typed on combobox2, but it show error "type mismatch" This is code for userform: Private Sub UserForm_Initialize() Me.ComboBox2.List = Worksheets("Sheet2").Range("B2:B600").Value Dim ws As Worksheet, rCell As Range, Key Dim Dic As...

I think the solution is rather simple, I just can't find it. I have textboxes 102, 103, 104, 105, 106 I want the values in 103-106 to be autofilled based on values in 102. I wrote the following code. Private Sub TextBox102_change() TextBox103.Value = TextBox102.Value * 3.125...