Label error

[derek davis]

Hello everyone, I would like to alter the way excel operates. by this I mean, I would like to have my data entry start at row 16 then insert a blank row when either return or tab is used. I am unable to get this to work as the VB debugger creeps appearing with an error msg and wondered if I could ask you guys for some help please as VBA is not my skill. I have att: a sample file file showing what my intensions are.
Thank you

 

[vletm]

derek davis
Without open Your file ... where is Your 'missing' Label?
... I cannot see it ... Excel cannot see it.

Check some samples syntax below

On Error statement (VBA)

VBA language reference

docs.microsoft.com

 

[Belleke]

Add enditall: just before End Sub

 

[derek davis]

Belleke thanks for prompting me where the error was occurring. I have corrected my error. When I re-run the code it is error free ( thank you), but for some unknown reason the code does not appear to execute, ie after populating the last cell "G" neither tab or enter doesn't force the page to update. do you have any other suggestions?
Thanks Del.

 

[vletm]

derek davis
You asked only about 'Label' ...
You have set Application.EnableEvents = False
If it stays False ... then some code won't work at all.

 

[Belleke]

I'm guessing that's what you want to accomplish. Enter the data into the green cells and press Ctrl +q.

 

[derek davis]

Thank you very much to vletm and Belleke for you help and support it is very much appreciated. My query has now been answered as all now working as designed..