Tab sequence from cell to active x button and then to a command button

Basically I have a form and as I tab through the cells, when I get to the last one, it tabs to the very first cell again which would not be a problem, but I would like to cycle through about four buttons before going back to the original cell. The first button is an active x button (to save) and then the next two are optional print buttons and then the last is a start new report (clear contents) and these last three are command buttons. I don't have to have everything spelled out for me but just need to know where to start and how to chose which one is first.

Thanks

You need to modify the property 'TabIndex' for each control of your form:
for example, choose the first control to tab and put 0 in TabIndex, then choose the second control and put 1 in TabIndex and so on.
Regards,
Antonio

Originally Posted by 2funny4words

Basically I have a form and as I tab through the cells, when I get to the last one, it tabs to the very first cell again which would not be a problem, but I would like to cycle through about four buttons before going back to the original cell. The first button is an active x button (to save) and then the next two are optional print buttons and then the last is a start new report (clear contents) and these last three are command buttons. I don't have to have everything spelled out for me but just need to know where to start and how to chose which one is first.

Thanks

Sorry, I meant that I have a worksheet not a form and only the cells for data input are unlocked. When I get to the end of the unlocked cells, I would like to then go to 4 different command buttons using tab and with spacebar activating the button. Will I have to write code?