Recent content by NMeeker

you are very right, those lines have ended up useless... I have come up with a solution to my problem... and though I did it by completely re-writing this at least 3 times... after the last three days of testing, writing, re-writing, and searching the web, the answer became very simple. My...

hmmm I am definitely using excel, and was not expecting to post about the same time as you. I will definitely look into that though my repeating of added items still exists as is..

Okay, Between the two of you, I am definitely getting closer to solving this mess. David, Thank You for all of your help. Though, your last bit of code did not solve my problem yet. However, I am getting closer. I am getting random successes now which are better than before. I do not know what...

Hey, Thanks for the attempt Shred, but I am still having troubles with it. I have tried messing with .Selected before, and though my hopes were up this time again, noting... I think my problem is that I am using an InputBox to get the name of the item I will be adding to the box. I am just...

I am using AddItem.... I am pulling information from ranges on several different worksheets, then taking out duplicates, then sorting a-z then adding the "New Event" to the end of the list. AddItem worked better for my purposes. I could post my code for adding, removing duplicates, and...

Hi, I have a ListBox on a form. The listBox is populated by a range, then an item "New Event" is added to the end of the list. When "New Event" is selected, I would like an input box to be shown to the user. Then the InputBox's information "NewEvent" will be added to the top of the ListBox's...

I got it.. i'm a smart cookie... lol I used, this code in the ThisWorkbook Module Private Sub Workbook_NewSheet(ByVal Sh As Object) Sheets("Master").Copy After:=Sheets(Me.Sheets.Count) Sheets(Me.Sheets.Count).Visible = True Sheets(Me.Sheets.Count).Name = "New Rope" & Format(Now()...

Hi, I have a workbook with a user form, most information in the workbook will be filled in using the form. However, the form references all visible worksheets many times. If the user adds a blank worksheet without specific ranges and headings built in, then the form will not work correctly. I...

I was kind of thinking along that line. But I am fairly new to this type of programming and I barely have any idea how to do that. Would anyone have any idea how to generate a second column of text with leading zeros, based on the first column? and after that... any idea how to show only the...

Thats right!! I think.... here is the only link i can find where someone actually talks about what I want to do, but I can't figure out how to incorporate it. http://www.access-programmers.co.uk/forums/showthread.php?t=120275

I have a Listbox "on a form" populated by several dynamic ranges pulling from several worksheets. I have already figured out how to take out all duplicates from the Listbox. I have also managed to try several different methods of sorting my information. However, I always seem to come up short of...

I am rather sorry to bother you via PM... However, you posted the only relative information to my question. And I was hoping you could help me out. Your post about Sorting Complex Alpha-Numeric Strings is the only one i can find that deals at all with using leading-0's. I have been searching...