Hello Everyone, I have an excel file with a bunch of lables and textfields where I need user input. when the user enters data into the textfields and presses the enter key or tab key, i need it to go to the next assigned cell. i tried presetting the cells in the macro after proecting it and locking the lables. But, if a users makes an error in one of the cells he cant simply click the cell to edit the value. he has to go through the all the cells and come back up again. i also tried selecting the cells in the order i need and giving the range a name. but in this case if the user goes back to a cell after clicking enter or tab, the range name disappears. now the users need to select the range again, to complete the form. are there anyways: for the tab to move in an pre-assigned way where if the user can go back and edit the cell as he pleases? Please let me know if you need more information. Thank you in advance. I appreciate any help.