+ Reply to Thread
Results 1 to 18 of 18

How to reference Controls in a Userform based on the control's tabindex instead of name?

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    03-21-2013
    Location
    Corvallis, OR
    MS-Off Ver
    Excel 2010
    Posts
    174

    Re: How to reference Controls in a Userform based on the control's tabindex instead of nam

    In the OP, you said that you want the next in tab order control after the active control
    Thanks for all the help. mikerickson, your answer is a perfectly applicable response to my very inapplicable question... What I was trying to do was way off base from what I needed to do. The eventual solution was based in a combination of control change and before_update events, and thus, selecting the next control in the tab index order actually would have failed on some occasions because the next control in line wasn't always visible. It actually needed to be name based, and since I renamed all of the controls with names that could be referred to by each event based on the name of the active control, I could have written a set of macros that could be run each time a change or before_update event happened in each control. Before realizing this potential, I had already written all of the code necessary to make it happen anyway... Thanks for all your help. I have marked this post as solved.
    Last edited by bmxfreedom; 11-05-2013 at 08:20 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 5
    Last Post: 02-27-2013, 12:04 PM
  2. Replies: 1
    Last Post: 10-12-2012, 04:36 AM
  3. 2 Control buttons, 1 UserForm, Reference 2 Columns
    By Jacques Grobler in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 02-15-2012, 05:46 AM
  4. Code to format number input in textbox controls (based on tag) in userform
    By asha3010 in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 07-05-2010, 01:09 PM
  5. Reference Userform Multipage Control
    By kingdt in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-03-2010, 06:31 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1