Member Avatar for djbhoco

I am creating a form on Excel where the user can use tabs to go through the fields that have been unlocked and type in numbers in that field, then hit tab to go to the next field. I have created the tab array in the VBE, but the problem is that Excel wants to stop at one column that is not on the array. So the user has to always hit the tab key one additional time before going to the next field and entering a number there. This is happening on each line. I don't know how to get it to just go to the next field that requires a number.

Can anyone help me with this?

Thank you,
Debora

  • 2 Contributors
  • 1 Reply
  • 97 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by Pilgrim-Last
Member Avatar for Pilgrim-Last

If I understand what you want, try setting the TabStop property to false on the column you want to skip

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.