Auto-Populating Calendar

Mar 24, 2009

I am looking for an excel calendar that will auto-populate content into it based on a spreadsheet that I fill in.

Maybe I would just need the formula that would be inserted into each calendar day? I'm not sure how you would set this up, but I'm open to suggestions!

I have attached the .xls file for your reference.

For example: The comment "Client 1 - KOM" would populate in a blank calendar in excel on the date 3/23/2009.

ADVERTISEMENT

Excel 2010 :: Auto-populating Calendar Based On Conditions From Data Table On Another Sheet?

Apr 26, 2014

I'm trying to auto populate a calender style sheet in Excel 2010 based on data from a Work Schedule sheet. The work schedule sheet contains a list of jobs, with each row representing a different job. There is a column for the start date (e.g. 25/04/14) and a column for the end date (e.g. 26/04/14). There are other columns which select resources such as people and vehicles. Each resource may appear on any one of several columns for each row, e.g. Site Operative 1, Site Operative 2 etc.

On the calendar sheet, in which one cell represents one day (e.g. 25/04/14), all the dates are shown along the top going right and all the resources are shown on the left going down.

On the calender sheet, in every cell I want a formula that will look at the Work Schedule sheet and see if that particular resource is being used on that particular date. If it does, the cell can display information from another cell such as the job number or job name to which the resource is assigned; if it doesn't, the resource isn't being used so it can display "Free" or "Available".

View 2 Replies View Related

Auto Populate Calendar Days Based On Month / Year And Auto Insert Work Based On Dates / Name

Jul 31, 2013

I am trying to auto generate a calendar based on two drop down menus - Month and Year.

Once the month and year is selected I want to import all work orders onto the calendar based first on the "Labor Name" found in the list of work tab, then assign each work order for that labor name to the respective date on the calendar for the month.

August PM Schedule Demo.xlsx

View 2 Replies View Related

Cell Auto Populating

Oct 10, 2008

I need column B to self populate cells with "1" if a specific range of room numbers are entered in column A. Is this possible?

Column A, room numbers from all over hospital.

Column B auto populate "1" if rooms ranging from M570 to M590 in Column A

View 9 Replies View Related

Auto Populating A Text Box

Mar 2, 2010

i have a form that in excel using the Active X Controls thanks from the help on this board the form is working a great and praised by peers for the simplicity and design.

Anyway i would now like to add some code that will auto populate certain text boxes with information held on the PC?

The information is held on the PC so info like Environ$("USERNAME") etc.... what i would like is when the user opens the form these fields are populated with this information..

I have had a go but still cannot get it to work... Here is my attempt

Private Sub staffno_Change()
staffno.Text = Environ$("USERNAME") 'Users Staff ID
End Sub

View 9 Replies View Related

Populating A Cell With A Calendar Month Based On The Previous Date In Another Cell.

Jan 9, 2010

Trying to word this right. I have one cell with a date of 01/01/2010. I have other cells that I want to be equal to this cell plus 1 or more months.

For example A1=01/01/2010

I want A2 to = 02/01/2010 based on one calendar month entered into A1. So if A1 changes 03/01/2010, A2 will = 04/01/2010.

View 3 Replies View Related

Auto-Populating Excel Scheduler?

Jul 11, 2014

I have been using a great spreadsheet [URL] .... that allows the auto population of dates/events onto a calendar.

The spreadsheet only allows the input of 7 events per day, yet I am finding that I often have more than 7 events to schedule. How to modify spreadsheet to allow for more than 7 events to be populated in one day?

View 2 Replies View Related

Auto Populating Text Boxes?

May 1, 2013

I have a workbook that has multiple sheets. And on lets say as an example the first and third pages I have text boxes "reason for text boxes is for sizing issues" that are on both pages that are identical and have the same info that needs to be entered into them. What I would like to accomplish is when info is placed in those text boxes on the first sheet their values auto populate onto the third sheet and so and so forth. Being multiple text boxes on multiple sheets, going through all 5 would be daunting and time consuming.

View 6 Replies View Related

Auto Populating A Field In A Spreadsheet

Aug 25, 2007

I have a spreadsheet where I keep track of sales that I make in ebay. The spreadsheet has the following columns: Name, Product, Prod Cost, Shipping Cost, Payment Received, Total. I have made a list way off the the right of the spreadsheet with all the products that I sell, so in the "Product" column I can use a pulldown menu and choose the item from the list. However, I was wondering if I could create it in such a way that when I chose the item from the list, it would automatically put the cost in the "Product Cost" field. Is this possible?

View 9 Replies View Related

Auto Populating Excel From Data In Another Sheet

Aug 28, 2013

I am trying to auto-populate a table with data looked up from another sheet. The functions I have used are: Data Validation, vlookup, ISerror and if functions.

Cell B4 in sheet2 uses Data Validation to pick data from sheet1 (in this case "tax") and auto populate the table with the information- Job type, Name, employee type and Job title. If i change from Tax to HR, the table should get auto-populated with the correct information.

I have setup vlookups but I am unable to get it working. I am a novice at using vlookups (I learn it just 2 days ago) and am struggling to get it work. I am not even sure if vlookup is the right tool to get this job done.

View 12 Replies View Related

Auto-Populating Based On Dropdown Selection

Dec 4, 2013

I am trying to create a sheet for identifying work hazards based on the job assigned. So what I have set up is a drop down list to select the job type. Once this job type is selected I want the pre written hazards to autopopulate in the hazard box. I would also like the required PPE to appear in the PPE box for the job selected.

I have 6 different choices in the drop down list. For each choice I have the hazards and PPE in a separate sheets in the worksheet.

Is there a way to get this information to autopopulate?

View 1 Replies View Related

Auto Populating Based On Specific Data

Jan 7, 2014

I have a unique task i am trying to achieve (when i say unique i mean i am out of my depth). I am trying to take specific data from a couple of different sheets to populate other sheets whether it be copying the text of fill cell (color)

Excel Automation Test.pdf

I have Attached a PDF detailing.

View 2 Replies View Related

Auto Populating A List Of Times From One Workbook To Another

May 9, 2013

I have two coworkers who input a list of times spent throughout the week into a basic 5x5 grid (daysof the week x 5 employees) into their own seperate workbooks. I then take those workbooks and copy and paste them on to my own master work book. Is there any way to get their data to auto populate on to my spreadsheet?

View 3 Replies View Related

Auto-populating Cells On Separate Sheets?

Jan 9, 2014

I have two spreadsheets, one is a Log Sheet for invoices that we have been printing out and filling in my hand throughout the day as our field technicians complete their work. The second spreadsheet has a sheet for each technician where we manually input the technician's invoice numbers and payroll for each job completed on that day.

What I'd like is a way to combine these spreadsheets so that instead of printing and filling in the first sheet by hand, I could input the invoice data and have it automatically populate the cells for the appropriate technician.

This is the running log we keep throughout the day:

2rp76ky.png

Then at the end of the day, we painstakingly transcribe the data for invoice number and payroll onto this sheet for each technician:

4vg6dk.png

What I want is for Excel to automatically fill in each technician's payroll log with invoice number and payroll time as we fill in the running log throughout the day, is this a doable thing?

View 1 Replies View Related

Auto Populating Dates But Skipping Weekend?

Jan 17, 2014

I need to make a schedule for testing where I check the samples every 3 days but if that date hits on a weekend I want it to role over to the monday if it hits on a Sunday and Friday if it hits on a Saturday. In other words wait an extra day if it hits on a Sunday and check the sample a day early if it would normally be on a Saturday.

I have been playing around with the WORKDAY command and some of the other date functions but I can't figure this one out.

View 3 Replies View Related

Auto Populating Cells From A Date Range

Nov 17, 2006

Basically i am trying to auto populate cells using two dates as the parameters, set up is

A1 - Start Date
B1 - Finish Date
C1 - Jan 07
D1 - Feb 07
E1 - Mar 07....and this carries on across till the end of the year.

What i am wanting excel to do is to be able to put in a start date and finish date in to the relevant cells.....this then populates a fixed figure across in to the correct month.

Eg
start date 05/07/07
finish date 17/10/07

This then puts in the figure 0.2 in to each cell that correspond with each month....July 07/Aug 07/Sep 07/Oct 07.

So in effect it is giving a gantt chart but with data in it.

One more thing....the start and finish dates could well be out of the range.....

eg
so start could be 07/08/06 and end could be 18/04/07 which would mean that all of the fields would need populating.

View 9 Replies View Related

Auto Populating Columns In One Sheet From Another Based On Criteria

Jul 28, 2009

I've been trying for some time now to figure out how to have one sheet automatically fill in another based on a larger data sheet. I'm trying to find a way to take a monthly calendar which contains a row for each employee and column for each day and use that to create smaller lists on another sheet. Basically if someone puts in for a day off, or has a medical appointment etc, that person has a coded single letter for that day for tracking and planning purposes. I want to have a second sheet that references those codes and makes individual lists (the following people are on vacation, these people have a medical appointment etc.)

View 3 Replies View Related

Auto-populating A Table Based On Ranked Values?

Jan 21, 2014

I am looking to create a table with ranked projects from a different tab that is able to pull data from the same tab and change based on value updates. It is difficult to explain, so I have attached the file below.

What I am looking to do is pull the ranked projects from tab #7 - Scoring to tab #5 - Final list. Each project has a unique ID#, but a lot of the columns I need populated are not unique. I tried using a combination of arrays, but it always returned a #value into the cells.

P.s: In tab #5 - Data sheet, the formulas in I5 and P5 work, but are pretty ridiculous, and I'm pretty sure there must be an easier way. I was looking up values from the 8-budget tab to try and determine which group column H values were from. The only complication I was having was that a project can be allocated to either a functional unit, or group so I need to have the "group" total as independent, not just as a sum of the functional unit totals. Like I said, these formulas work,

View 4 Replies View Related

Auto-Populating Empty Cells With Specific Text?

Dec 13, 2011

Is there a way to auto-populate all of the empty cells with the word "Need to Review" in a cell range (A1:A250)? Once any of the cells in this range is populated, whatever is inputted should house the cell.

View 9 Replies View Related

Auto-populating Starting Times From 1 Format To The Other -VBA Required

Jun 9, 2006

If you look at schedule.jpg you will see a how our work schedules are formatted.

Then if you look at schedule2.jpg, you will see what I wish to convert it to.

Now I'm looking for a way to search by the name of our employee (2 seperate sheets) and then by the time which corresponds to the first "1" in the chart under that name and the last "1" in the chart under that name.

So once I fill out our schedule.jpg, it will auto-populate the times on schedule2.jpg.

Is this even possible?

If necessary, I will be able to put both schedule and schedule 2 on one sheet.

On schedule.jpg time starts at 7:00 - Column C
and ends at 8:00 - Column AC

View 9 Replies View Related

Auto Update Calendar With Spreadsheet?

Sep 17, 2013

I am trying to do exactly what the calendar from this thread does with the Waste Log: [URL]....

But the years only go to 2012, can someone update this for 2013? And include Saturday and Sunday on the calendar too?

View 2 Replies View Related

Auto Updating Calendar For Plant Growth?

Jul 3, 2014

So, I work in a large indoor grow facility, and as such, we need to keep an active, updated calendar of all activities that will need to happen in the grow. If something happens to a set of plants, we need to change to date of transplant into the next pot size and every transplant after that, as well as moves into the flowering room from the vegetative room.

I have tried to manually make a calendar (I'm not worried about auto-generating a calendar or auto-filling dates, only things that happen on those days.) and tie in this information, but I'm having issues automatically searching a column and finding the date, and then pulling more information from that row automatically. (i.e. If anything in Column E has the date 7/3/14, then fill the data from Column C and Column B on the same row.)

I'm attaching a copy of the spreadsheet that I am trying to pull the Data from, and a copy of the Calendar I mocked up.

FYI, the spreadsheet I am pulling from Automatically fills once you put in the Clone Date, and then if you add in an adjusted date, it will adjust all later dates from that same section.

I tried to find something other than Excel as well to do this for me, but AFAIK nothing exists to make the calendar update Live, only to reproduce a new calendar with the current spreadsheet. This is not an option, I need it to stay up to date.

View 7 Replies View Related

Auto Filling Annual Leave Calendar

Feb 28, 2013

I've put together an annual leave tracker for the department and am trying to make it as automated as possible. It currently consists of two sheets, 'Leave Applications' and 'Leave Tracker 13'.

If you look at the 'Leave Applications' sheet, I wish to be able to take this data to fill the calendar on 'Leave Tracker 13' with either AL or HL to demonstrate whether the day is annual leave or half day leave. This only wants to happen if the leave has been accepted, represented by an 'A' on the 'Leave Applications' sheet. The calendar obviously doesn't have any dates in the cells but I've got around this when it comes to shading in weekends by concatenating the date above and to the left of the cells and assume I must be able to do the same for populating it.

It's also complicated by the 'Leave Applications' consisting of multiple members of staff, though this may be ordered by date.

View 11 Replies View Related

Auto Creating A Calendar Based On A Date In A Cell.

Dec 30, 2009

I am playing around with creating a calendar based on a date (month) I enter into a cell. I am doing this with a simple =date+1.

I have a sample attached. Only problem I am having is that for months with 30 days I don't want the last day to show the first of the next month. But I can't simply remove that as if I entered a month with 31 days I would need it to show the 31st.

View 4 Replies View Related

How To Get Data Entered In Form To Auto Populate Into Calendar

Jun 26, 2014

I am trying to build a Calendar that pulls all of it's entries from data submitted via user form. To be more clear, I built a basic user form in VBA where I can submit this data: name, brief description, Time/duration, and date. Instead of the data I enter into the form populating in specific cells in my Excel workbook, I would like for the information to be populated into a calendar based on the date.

View 1 Replies View Related

Auto Populate Excel Calendar Based On Date Ranges

Dec 4, 2013

I am trying to have the calendar in the second tab of the attached excel file to auto populate based on info in the first tab.

In the first tab, there is the start and end dates of certain projects. The calendar will need to only show the project name of every project being worked on that specific day.

Some days will have more than one project being worked on, the Calendar will just need to list them all under that day. The Start and End dates count as days the project being worked on as well. We will also need the calendar to auto update whenever we modify the dates in the first tab or add/remove projects (rows).

View 5 Replies View Related

Create Calendar In Excel And Auto-populate Content With Specific Fields?

Aug 23, 2013

Looking to create a calendar in excel and auto-populate the content with specific fields I enter. I know how to create an excel gantt chart but I'm really looking for a calendar view instead of a series of columns with dates. I reviewed the original post on Auto-Populating Excel Calendar but was confused by the instructions. (1) create a calendar in excel and (2) show me how to populate the calendar with fields like (dept and project name) into the dates on the calendar? I have two dates that are important (a due date for the project and when that project will be published). Is there a way to have both dates show info otherwise the most important date will be the publish date?

View 1 Replies View Related

Auto-Populating Multiple Values Based On Two Criteria Based In Comboboxes

Aug 7, 2013

I'm starting a dashboard, where on the front page I have two combo boxes on the left, and three empty fields to the right. I'd like the three fields to the right to auto-populate table-based values depending on the chosen criteria from BOTH fields (by store and month/date). I've attached a sample of what I've got so far. I've only provided three tables for this example, and I have a table with the same column/row titles for each metric and I have three different metrics I'd like to auto populate: COGs, Sales, and GM% or in the example, metric 1, metric 2, metric 3. No pattern in the table values, just wanted to populate the fields quickly. All fields are organized by store/month-date and I've set up a link to my combo boxes on a calculations tab.

View 2 Replies View Related

Auto-Populating Values From One Sheet To Another Sheet

Jul 28, 2013

I have a master list. I want to create an excel sheet that will follows when I key in the code number according to the master list all the rest of the value in the master list will automatically populate accordingly into their respective sequence into the created excel sheet.

Eg.

Master list

A B C D

0001 Lucy 8 Walton primary
0002 Rachel 9 Dermouth primary

The created excel sheet

Code 0001
Name Lucy
Age 8
School Walton Primary

I want to key in the code 0001 and the rest of the value will auto populate from the master list into the created excel sheet. The master list data go in accordance row by row. That means the master list is listed in a sequence where all the related value for the particular code into one row only.

View 14 Replies View Related

Auto-Populating Table From Another Table

Jul 5, 2014

Attached example.

I trying to populate table on sheet "1" from the training log sheet. Based on person name. Eg on sheet 1 i select Chris Williams and it will populate the table with courses he done from table on training sheet.

I tried and failed using vlookup and index match, but think that's what i need to be using.

example.xlsx

View 2 Replies View Related

Calendar Control 11: Selected On The Calendar Is Greater Than 12 The Date Is Entered Correctly Onto The Sheet

Jan 8, 2010

I have a program where I can update the calibration due date of an item. I have attached a cut down version of my program showing the relevant areas. There is usually password protection on the worksheet so it can only be edited via the form (the vba coding removes the password protection before editing, then re-enables the password protection after editing). The "Update Calibration" button is usually on a "Menu" sheet.

Once the form is opened a serial number is typed in the textbox. The calendar button is then clicked, which brings up another form with the calendar on. The due date is selected on the calendar. When "OK" is clicked, the date label caption is then changed to the selected calendar date. When "Submit" is clicked, the spreadsheet will search for the Serial Number, once found, the label caption (being the date selected) will be entered into the cell to the right of the serial.

If the day selected on the calendar is greater than 12 the date is entered correctly onto the sheet. example: calendar date selected = 15/01/2010. shown on sheet as 15/01/2010. However, if the day selected on the calendar is 12 or less, the date is for some reason entered incorrectly onto the sheet. example: calendar date selected = 08/12/2010. shown on sheet as 12/08/2010???? What is going on here? how come the day and month are swapped around if the day is less than 12????

View 4 Replies View Related

Excel 2007 Calendar Control - Select Date From Calendar In A Field

Dec 24, 2009

Using Excel 2007 Calendar Control:

I want to select a date of choice from a calendar in a field within an Excel spreadsheet.

I do not know how to do userforms and so that is why I wonder if I can add this in just a spreadsheet.

This is how far I have gotten so far: After doing the following, I have a static calendar setting in my spreadsheet like a text box showing the current date.

Developer
Insert
More Controls
Calendar Control 12.0

View 9 Replies View Related

Phil Johnson's Calendar - Pop Up Calendar Without ActiveX

Mar 7, 2009

I am using a great pop up calendar without ActiveX made by a guy called Phil Johnson. When you click a specified cell the calendar appears. The only problem is that the calendar doesn't default to today's date when it opens.

I have the original file Calendar source code if anyone needs it.

View 4 Replies View Related

Populate Calendar If Date In Associated Cell Show Date On Calendar

Apr 4, 2013

I currently have a worksheet that when a user clicks on the cell, a calendar form opens. From here they can select a date, click ok, and the date gets placed in the corresponding cell they clicked on.

Now if the user needs to change that date, i want them to be able to click on the cell again, and when the calendar opens, the date in the cell would be selected on the calendar. I was able to do this in a userform, but im not sure how to edit it to work on the worksheet. I am using the below to populate the calendar.

Code:
private sub worksheet_selectionchange(byval target as range)
if not intersect(target,range("aa16:aa24")) is nothing then .show calendar
When the user clicks the date, the below code places it in the cell.

Code:
private sub ok_click()
with active cell
.value=calendar1.value
end with
unload me
end sub

Now the below code was used when I was using a userform, but im not sure how to edit this to pull the date from the active cell.

Code:
privatesub userform_activate()
me.calendar1=date
if not tb is nothing then
if isdate(tb.value)then me.calendar1.value = tb.value
end if
end sub

View 1 Replies View Related

Auto Size Cells On Visible Columns Not Auto-sizing Correctly?

May 27, 2014

I have the following code:

[Code] ....

When I run the macro, some columns are already hidden. The macro doesn't seem to autosize cells correctly. For instance, one cell in a row appears to have some contents hidden (or below the reading area of the cell). In other instances, the rows are auto-size to huge heights and widths.

View 7 Replies View Related

Get (tabs) Of Action Log To Auto-populate And Auto-delete In Master Log

Jul 29, 2014

I need the tabs of a project action log to auto-populate and auto-delete in a master log. (So when something is added or deleted in a tab it is added or deleted on the master) I use excel a little bit for work and personal finance purposes but I have zero experience with macros or VBA.

View 1 Replies View Related

Air Force Mission Tracker-Auto Counting & Auto Copying

Jun 19, 2009

Making a mission tracker that requires less upkeep than my units previous methods. I am using Excel 2007 and have some things in mind that I would like it to do.
On the down side, I have only basic experience with excel and have never used macros or VBA.
Even if what I am after could be solved with functions (which I prefer), I simply do not quite know how to make what I want without assistance. Ok, now on to the description.

The mission tracker aside from showing a list of the missions we have done during our program, it needs to also generate metrics automatically. In my worksheet, I am using columns A-G and rows 1-501.

The mission scheduling type in Column E are listed below. The letters on the left are what I am using in the sheet, the part to the right is what it really means:

Column D has the day of the week listed as: Mon, Tues, Wed, Thurs, Fri, Sat, Sun.

now the metrics I need to be generated are the number of different types of each mission compared, how many of each type of mission was flown per day of the week, how many of each type of mission was flown per month.

Basically what I need is a way to automatically count the number of rows that meet a specific criteria throughout the range. This would require being able to check the value/text of multiple cells at a time and count the number of rows that meet that criteria.

[SOLVED] 1. The first part would be to have the worksheet be able to count the number of each type of the 9 mission scheduling codes throughout the range. I would be storing the count in new cells that would then be connected to pie charts.

[SOLVED] 2. The second part would be to count the number of each type of mission that was flown per day of the week. That would require searching both mission type and day of the week. All I would need is a working formula for 1 set, then I could switch mission codes and weekdays to match all the 63 possible outcomes.

3. Knowing the number of each type of mission flown per month. This would be checking the date and the mission type. The trickier part that comes up in my mind is that our programs span multiple calendar years, so it would have to track it by month and year, that way there is a difference between Jan 2009 and Jan 2010. The counted numbers would be used to make histograms. It would be nice if the chart titles could be automatic based on the dates inputed in the mission tracker. If I needed to choose a maximum time length for it to cover, I would pick 3 years.

4. I would like to figure out how to make an inputted line of data on the main tracker sheet to create a copy in the corresponding worksheets based on schedule type, that way a person could look at/print a specific type without having to sort the main list.

The actual goal is to make it where a person can enter the 1 line of data per mission (cells A-G) and the mission metrics update automatically after each mission is inputed allowing upper level supervision to have current information quickly whenever it is needed. Currently we need about a weeks lead time to get the information asked for on our current progress.

View 10 Replies View Related

Auto Complete And Auto Delete With Data Validation

Jan 7, 2008

Within a data validation selection, are you able to do both Auto Complete and Auto Delete? I have this posted at another forum [url]but have not been able to find a solution (a copy of the file, test. zip is there as well). I am not sure it is possible, or, at least I have been unable to get it working. I can do each, but not both.

I have also been utilizing:

[url]

[url]

View 5 Replies View Related

Populating Lists

Feb 8, 2007

I have 16 seperate titles and a different figure for each title.

However, these 16 titles are repeated hundreds of times, in different orders, down a column. I need to populate the list with the numbers that belong to each title.

I don't have v look up on my computer. I am useless at excel.

View 11 Replies View Related

Populating A Listbox

Dec 4, 2006

I have a spreadsheet that continuously is having data input in columns A-F. I want to have a listbox automatically populate each time the worksheet is opened. I would like to have a macro that will search for all rows that have data in columns A-F that DO NOT have data in column L. I would like the macro to populate a listbox when the worksheet is opened with the data from columns A-F of all rows that meet the previously stated criteria.

View 9 Replies View Related

ComboBox Not Populating

Jun 1, 2007

I have a combobox that is not populating correctly. The design of it uses an existing list (which changes every month) to populate the contents of the combobox. I want the user to be able to select a location from the list if it is already on the worksheet, rather than having to key in the location name for every single record. This Sub worked just fine and dandy for me until I deployed the workbook to the end user. Then this particular combobox decided not to work.

I have been over this code many, many times and I am almost positive that it's just a matter of my not being able to see the obvious. Perhaps another set of eyes looking at the code will be able to see what I can not.

Sub get_Locations()
Dim allCells As Range, Cell As Range
Dim noDupes As New Collection

Sheets("Main").Select
' get the first from last row #--the last row is a row of record counts and sums.
endRange = ActiveSheet.UsedRange.Rows.Count - 1

ComboBox1.Clear ' This will clear the combobox.
If endRange 65536 Then ' If the row number is not the end of the worksheet, _
there must be something already on the worksheet, so build the list.
On Error Resume Next
' Get unique values in range by checking each cell in range.
For Each Cell In Range("D12:D" & endRange)
noDupes.Add Cell.Value, CStr(Cell.Value)
Next Cell
On Error GoTo 0

' Sort the collection alphabetically within the combobox
For i = 1 To noDupes.Count - 1
For j = i + 1 To noDupes.Count
If noDupes(i) > noDupes(j) Then
Swap1 = noDupes(i)
Swap2 = noDupes(j)
noDupes.Add Swap1, before:=j
noDupes.Add Swap2, before:=i
noDupes.Remove i + 1
noDupes.Remove j + 1
End If
Next j
Next i

' Add items to combobox in their new alphabetical order.
itemIndex = 0
For Each Item In noDupes
UserForm2.ComboBox1.AddItem Item, itemIndex
itemIndex = itemIndex + 1
Next Item
Else ' otherwise there's no list to populate and the default row is 12
endRange = 12
Range("A12").Select
End If
End Sub

And just for the record, all object references (cell ranges, comboBox, etc.) are valid and correctly named, so I know it's not there. I also recognize that I have overspecified things by using "UserForm2", but I have done that in the hopes of finding the problem. And the code does execute at the proper times, populating "noDupes" correctly. The problem seems to occur near the end, in the block where noDupes is added to ComboBox1.

View 9 Replies View Related

ADVERTISEMENT