0

I have a userform with comboboxes, text boxes, and checkboxes. Each of them holds a value that eventually be added to the worksheet.

When I start interacting with one of these controls, I would like a related row on the worksheet (visible behind the userform) to be highlighted. Preferably, it would happen as soon as the control has been clicked, so the user can see which cells he's about to modify.

For the comboboxes and checkboxes, I think I can use the Click event, but there isn't one for the text boxes. There is a double-click, but that's not good enough; if Row 1 is highlighted, and single-clicking in Box 2 doesn't change the highlight to Row 2, then it's the wrong row that's highlighted, which is worse than useless.

How can I get the textbox to react to being selected or clicked in?

Also: the controls are arranged in groups. Clicking any control in a group should highlight the same row. Rather than separately coding all seven items in each group, I'd really like it if clicking anything-in-group-1 would highlight the correct row, and the same for Group 2 or 3, etc.

This part may be similar to Click Event for buttons inside Frames for VBA in Excel, but I don't have time to learn how to write classes.

Shawn V. Wilson
  • 905
  • 2
  • 12
  • 37
  • Have a look at the doco for [Events (MS Forms)](https://docs.microsoft.com/en-us/office/vba/language/reference/user-interface-help/events-microsoft-forms), specifically [Click](https://docs.microsoft.com/en-us/office/vba/language/reference/user-interface-help/click-event), [Enter, Exit](https://docs.microsoft.com/en-us/office/vba/language/reference/user-interface-help/enter-exit-events) and [DropButtonClick](https://docs.microsoft.com/en-us/office/vba/language/reference/user-interface-help/dropbuttonclick-event). That should cover the majority if not all controls. – Samuel Everson Nov 17 '21 at 03:40

0 Answers0