Hello,

I've been going around in circles and can't seem to figure this out. Let me start at the beginning.

I have a UserForm with two frames and several text boxes in each frame. The frames are enabled/disabled by an option button. All that works great.

I want some of the text boxes to populate with percent symbol (%) I can use the AfterUpdate event to add it (.Text & "%") or format it (format... .Text, "0%"), which works. However that causes issues if I re-enter/change the text box so I added an Enter/Moue event to clear the text box so the user can enter a new number and have the % symbol added, that also works.

However (and here's my issue) if I click in a text box in one frame then click a text box in the other frame the last text box updated in the current frame updates even if that's not the text box i clicked in.

Does this have to do with tab orders/index? Should I ungroup the text boxes? Any suggestions are greatly appreciated.