Results 1 to 10 of 12

Thread: One userform and 60 Combo Boxes

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #3
    Member
    Join Date
    Nov 2012
    Posts
    47
    Rep Power
    0
    Hi Charles,
    I try to read what you wrote to me, but again I come to my explanation, but said a little differently.
    Again I will try to explain.
    (1) In my previous post helped me with the code, when I type the name in cell A1 and pressed the button to check all sheets and gave it to the main sheet.
    Here is the same - only have 60 drop down menus for office work more than 40 people, everyone is looking for his name.
    So - we have a dozen sheets 15-20, people's names are in column D on each sheet, if Userform write 5 names> only to find them again if I write 45 to look for them, if I write the same 60 to find them and cause them (put) in sheet (SEARCH) starting at cell A2.
    It is the former which helped me - >>
    http://www.excelfox.com/forum/f2/sea...-purposes-861/ -> (1)
    Please check out this file and macro in it to be able to gain some insight (attached).
    If there's anything else ask me, I will try to explain.
    Attached Files Attached Files

Similar Threads

  1. Error when trying to use COMBO BOXES PADLOCK
    By marreco in forum Excel Help
    Replies: 2
    Last Post: 12-28-2012, 04:15 AM
  2. set ListView on userform
    By Mahesh in forum Excel Help
    Replies: 3
    Last Post: 12-04-2012, 08:50 AM
  3. Replies: 11
    Last Post: 10-07-2012, 12:05 AM
  4. Replies: 2
    Last Post: 09-25-2012, 01:30 AM
  5. Number validation in Text Boxes VBA
    By Admin in forum Excel and VBA Tips and Tricks
    Replies: 2
    Last Post: 05-17-2012, 02:48 PM

Posting Permissions

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