“Enter” event triggers at the wrong time

[Glory]

I’m working with a userform. I’ve got a text box on a multipage object. When I enter the multipage object, the enter event for the text box is triggered. Is there a way to stop this from happening?

 

[Leith Ross]

Hello Glory,

The Enter event on a UserForm can not be disabled like events in Excel. Without seeing your code, I am guessing you need to move the code from the TextBox_Enter event (default event) to some more appropriate event like the TextBox_Click or TextBox_AfterUpdate event. Which event to use would depend on what you want to accomplish.

Sincerely,
Leith Ross

 

[AlphaFrog]

Change the TabStop property of the TextBox to False, or if there is another object on the same page as the TextBox, make the TabIndex property for the TextBox greater than 0

It seems that when the Page is selected, the object on that Page with a TabIndex of zero is also automatically selected.

 

[Glory]

<?xml:namespace prefix = st1 ns = "urn:schemas-microsoft-comffice:smarttags" /><st1lace w:st="on">Leith</st1lace>: The code clears the textbox if it's set to its default value. An exit event resets the default value if the textbox is still empty when the field loses focus.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o> </o>
The enter event is the one I'm going to have to stick with, I think. Part of the idea is that I want to be able to tab into the field (so no click event), and the code would not work with a change event. Thanks for the reply, though.<o></o>
<o></o>
AlphaFrog; Your response, as usual, is highly instructive. <o></o>
<o> </o>
I'm not going to set the tabstop property to false because I want to be able to tab into the field. I'll remember what you said about the tabindex property and its buggy effect on selection, although this time it happens to be greater than zero.<o></o>
<o></o>
I closed without saving by mistake, and when I reopened the workbook the problem vanished. I can now click my multipage without causing the text in the textbox to clear.<o></o>
<o></o>
Mysteries never cease.<o></o>
<o></o>
All that being said, I do have two other questions on my mind tonight (one of which is making it particularly difficult to do my work the way I want to do it). If either of you feel like taking a swing:<o></o>
<o></o>
1) I can't target pivot tables through VBA except on inactive sheets<o></o>
<o></o>
2) I can't create a working tabstrip<o></o>

 

[Leith Ross]

Hello Glory,

Glad to hear you got it working. I am going to pass on the new questions as it is getting late here in California.

Sincerely,
Leith Ross