Pressing TAB doesn't exit TextBox

[Guest]

Hi,

I have a modal userform in Excel 2003 with a number of textboxes on it.

Sometimes entering data and pressing TAB moves me to the next textbox and
sometimes it just inserts a tab into the current textbox and I have to click
the mouse in the next textbox to get there.

This seems to be random?

Any ideas - anyone seen this before?

Thanks,

Brian

 

[papou]

Hello Brian
Set TabIndex property to your textboxes accordingly, starting from 0 for
textbox #1 and so on.
This should correct your issue.

HTH
Cordially
Pascal

 

[Guest]

BTW, the TabKeyBehaviour Property is correctly set to FALSE.

Thanks.

 

[Guest]

Hi Pascal,

Thanks, but that is not the issue - pressing Tab inserts a Tab into the text
of the texbox instead of moving to the next Box - yet some times with the
same textbox it will function correctly!

Regards,

Brian

 

[papou]

And what is the Multiline property set to?

Cordially
Pascal

 

[Guest]

Multiline = FALSE

Thanks.

And what is the Multiline property set to?

Cordially
Pascal