SetFocus is available only in userforms.

On a worksheet, I believe you need to use activate.

--
Regards,
Tom Ogilvy

"M." wrote in message
...
Hi world,

i'm using Excel 97. I have two TextBox on sheet, first i wont to type
number
in first text box, then with pressing ENTER, i would like to set focus to
other text box. Why do not apper metod setfocus in suggested list of metod
for textbox?

Thank's!

Milos