Results 1 to 3 of 3

Multiple ActiveX ComboBox's w/several items - Is it possible to shorten?

Threaded View

  1. #1
    Registered User
    Join Date
    01-05-2015
    Location
    Wisconsin
    MS-Off Ver
    2013
    Posts
    50

    Multiple ActiveX ComboBox's w/several items - Is it possible to shorten?

    I have multiple ComboBoxes (ie., 2137-2150) with attendance codes and I was wondering if there is anyway to shorten?

    Cross-posted: http://www.mrexcel.com/forum/excel-q...ml#post4037218

    Private Sub ComboBox2137_Click()
     ComboBox2137.Text = Trim(Split(ComboBox2137.List(ComboBox2137.ListIndex), "-")(0))
    End Sub
    With Sheet1.ComboBox2137
    .AddItem " BD - LABOR/MANAGEMENT"
    .AddItem " BK - GRIEVANCE AND APPEALS"
    .AddItem " CB - TRAVEL COMPENSATORY TIME EARNED"
    .AddItem " CC - COMPENSATORY CALLBACK"
    .AddItem " CD - CREDIT HOURS EARNED"
    .AddItem " CE - TRAVEL COMPENSATORY TIME TAKEN"
    .AddItem " CN - CREDIT HOURS TAKEN"
    .AddItem " CT - COMPENSATORY TIME TAKEN"
    .AddItem " DA - BIRTH OF SON/DAUGHTER OR CARE OF NEWBORN"
    .AddItem " DB - ADOPTION OR FOSTER CARE"
    .AddItem " DC - CARE FOR SPOUSE, SON, DAUGHTER, OR PARENT WITH SERIOUS HEALTH CONDITION"
    .AddItem " DD - SERIOUS HEALTH CONDITION OF EMPLOYEE"
    .AddItem " DE - FEFFL FAMILY CARE/BEREAVEMENT"
    .AddItem " DF - ADOPTION RELATED PURPOSES"
    .AddItem " DM - WOUNDED VETERAN"
    .AddItem " HC - HOLIDAY CALLBACK"
    .AddItem " HF - HOLIDAY WORK - FIRST SHIFT (FWS EMPLOYEE)"
    .AddItem " HG - HOLIDAY WORK - (GS EMPLOYEE)"
    .AddItem " HS - HOLIDAY WORK - SECOND SHIFT (FWS EMPLOYEE)"
    .AddItem " HT - HOLIDAY WORK - THIRD SHIFT (FWS EMPLOYEE)"
    .AddItem " KA - LEAVE WITHOUT PAY (LWOP)"
    .AddItem " KB - SUSPENSION"
    .AddItem " KC - ABSENCE WITHOUT PAY (AWOL)"
    .AddItem " KD - OFFICE OF WORKERS COMPENSATION PROGRAMS (OWCP)"
    .AddItem " KE - FURLOUGH"
    .AddItem " KG - MILITARY FURLOUGH(LWOP) - CALLED TO ACTIVE DUTY"
    .AddItem " LA - ANNUAL LEAVE"
    .AddItem " LB - ADVANCED ANNUAL LEAVE"
    .AddItem " LC - COURT LEAVE"
    .AddItem " LG - ADVANCED SICK LEAVE"
    .AddItem " LH - HOLIDAY LEAVE"
    .AddItem " LM - MILITARY LEAVE"
    .AddItem " LN - ADMINISTRATIVE LEAVE"
    .AddItem " LS - SICK LEAVE"
    .AddItem " LT - TRAUMATIC INJURY (CONTINUATION OF PAY (COP))"
    .AddItem " LU - DAY OF INJURY"
    .AddItem " ND - NIGHT DIFFERENTIAL (GS EMPLOYEE)"
    .AddItem " OC - OVERTIME CALLBACK"
    .AddItem " OS - OVERTIME SCHEDULED"
    .AddItem " OU - OVERTIME UNSCHEDULED"
    .AddItem " RG - REGULAR (GS EMPLOYEE)"
    .AddItem " RF - REGULAR - FIRST SHIFT (FWS EMPLOYEE)"
    .AddItem " RS - REGULAR - SECOND SHIFT (FWS EMPLOYEE)"
    .AddItem " RT - REGULAR - THIRD SHIFT (FWS EMPLOYEE)"
    .AddItem " RN - REGULAR - PAID NOT WORKED (FIREFIGHTER)"
    .AddItem " RW - REGULAR - AGENCY TRAINING (FIREFIGHTER)"
     End With
    Last edited by ocnmel; 01-07-2015 at 12:42 PM. Reason: Added Code Tags to Comply with Forum Rules

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. ActiveX combobox datalist dependant on previous combobox selections
    By Mrs Poodle in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-14-2014, 07:07 AM
  2. [SOLVED] fill listbox (ActiveX) based combobox (ActiveX)
    By elsg in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 10-31-2014, 11:25 AM
  3. Userform Combobox - Choose Multiple Items from list and input on seperate lines
    By CRIMEDOG in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-30-2012, 04:09 PM
  4. Populate a activeX combobox from a selection of another combobox
    By ptramel in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-28-2009, 06:50 PM
  5. ActiveX ComboBox selection writes multiple cells
    By darmstrong in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-30-2007, 10:31 PM

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