Results 1 to 7 of 7

Need Help Coding ComboBoxes

Threaded View

Beast_OnThe_Keys Need Help Coding ComboBoxes 02-18-2019, 06:47 PM
kev_ Re: Need Help Coding... 02-19-2019, 03:56 AM
Beast_OnThe_Keys Re: Need Help Coding... 02-19-2019, 11:26 AM
Beast_OnThe_Keys Re: Need Help Coding... 02-19-2019, 11:58 AM
kev_ Re: Need Help Coding... 02-19-2019, 12:21 PM
Beast_OnThe_Keys Re: Need Help Coding... 02-19-2019, 01:02 PM
torachan Re: Need Help Coding... 02-19-2019, 02:34 PM
  1. #2
    Forum Expert
    Join Date
    11-22-2016
    Location
    Cornwall,UK
    MS-Off Ver
    office 365
    Posts
    4,240

    Re: Need Help Coding ComboBoxes

    Welcome to the forum

    Tabbing to pre-specified combobox can be set in combobox's properties when on UserForm but not when placed directly on a worksheet

    It would have been helpful to tell us what you had tried and had not worked with your existing setup
    Are you using Form Control or active-x combo-boxes?
    If suggestion below does not work for you, please provide a bit more information - thanks

    Note - this suggestion applies to active-x combo boxes

    ComboBox2.Activate is the line of code to activate ComboBox2

    1. Clicking on any cell after making selection in ComboBox1, takes user to ComboBox2
    Private Sub ComboBox1_LostFocus()
        ComboBox2.Activate
    End Sub
    2. Or try the same line of code as the LAST line in ComboBox1_Change
    Last edited by kev_; 02-19-2019 at 03:58 AM.
    Click *Add Reputation to thank those who helped you. Ask if anything is not clear

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] In need of help regarding combo box coding and button coding (Access form project)
    By mailblade in forum Access Tables & Databases
    Replies: 2
    Last Post: 01-09-2016, 01:34 AM
  2. Coding comboboxes to limit to list
    By fenfool in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-12-2015, 11:33 AM
  3. Replies: 3
    Last Post: 02-18-2015, 02:02 PM
  4. Help! Entire Row Hidden - w/Two ComboBoxes - Doesn't Hide the ComboBoxes
    By ocnmel in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-06-2015, 09:27 AM
  5. filtering comboboxes depend on value of other comboboxes
    By hassan khansa in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-18-2014, 09:18 AM
  6. [SOLVED] Vb macro coding for transpose - complete coding?
    By Dharani Suresh in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-02-2013, 05:04 AM
  7. [SOLVED] Calculating Time in Userform Textbox and Filtering Comboboxes Coding Help
    By hiddenupnorth in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-01-2012, 01:12 PM

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