vba to automatically hit a key on the keyboard

[chungtinhlak]

Is there a way to set the return key (enter) on the keyboard to hit automatically at a certain point in your macro?

I tried

VBA.KeyCodeConstants.vbKeyReturn = true but it gave me an error of invalid used of property, please help.