Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel VBA Form Tab in Textbox

Status
Not open for further replies.

MJPPaba

MIS
May 28, 2003
142
GB
Previously posted in Office Forum but to no avail, maybe here?

I have a VBA Form in Excel 2000.
The form has a series of Text boxes and combo boxes.
When execute the form and press tab to go between each object on the form, then it works fine.
A Colleague uses the same for, but for some unknown reason when she presses the tab button instead of changing the focus from one form object to the next form object based on the Tab Index, it acutally places a tab as text into the textbox.

Please help.

Cheers

Matthew

Sometimes I wonder why I even bother.
 
instead of changing the focus from one form object to the next form object based on the Tab Index, it acutally places a tab as text into the textbox.

and what happens if the focus is a combobox? does it jump to a textbox and place a tab?

Gerry
 
Hi Gerry,

Unfortunately there are no combo's to blur this issue. The form is comprised of about 6 Text boxes.



crazy times call for crazy people


CrazyPabs


sometimes I wonder why I even bova...
 
Hi MJPPaba,

There is no setting I know which can control this. You don't just have a stuck Ctrl key on the failing computer do you?

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.
Excel VBA Training and more Help at VBAExpress[
 
Hi Tony,

Tried that, it didn't work, also tried the same form on other pcs still the problem occurs?

Dazed and confuzed



crazy times call for crazy people


CrazyPabs


sometimes I wonder why I even bova...
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top