Search results for query: *

Thanks for showing interest in my problem. I've decided to re-design my program to make it more user friendly. The coding that I have is much too difficult to modify in the future when other programmers update this optimizer. I will be back shortly with my new coding. Thanks SO Much!!! AmyJade

Sorry for being so vague..... This is what I want to happen: I'm creating a portfolio optimizer that allows the user to select from a list of funds which funds they wish to optimize. Each time they select a fund from the drop down list their historical returns (which are copied from another...

Hi, The problem is that the listbox has 40 items that can be selected in any order. How do I find the first non blank column (I have headings for the columns to be filled), starting from say Range: A3 and have excel automatically fill each column to the right of each selected item? For example...

Hi, I don't know where to begin!!! I'm trying to have the user be able to do the following: When the user makes a selection from a drop down list box, the specified column (range of cells) will automatically be filled with the selection. I have 40 items to choose from in the listbox, but the...

My code is written is a general module as follows: Sub FundModelSelection() Sheets("Returns").Select Range("M4").Select If Range("M4") = 1 Then Call Fund1 End If If Range("M4") = 2 Then Call Fund2 End If If Range("M4") = 3 Then Call Fund3 End If If...

Hi There, I have a very strange problem. Whenever I select an item from a drop down listbox in Excel, the selection disappears on the list but it does fill in the predefined range of cells. It seems to delete the item's name from the listbox. Any thoughts? AmyJade

Thanks again for the help. I think the main problem I have is not the selection, but having the items selected in the listbox appear in the correct range of cells in the worksheet with the additional info also copied to the cells.Since the additional info does not appear in the listbox but are...

Thanks for the tip, but it's the coding that I'm having difficulty writing. I don't really know where to begin. I'm sorry, I'm new to VBA! *The additional info is on a separate hidden worksheet.

Another problem with this: Is there any way that the items that appears in the multiSelectListbox can hold separate information attached to each of the items selected? For example, if I selected two items (i.e. candy bars and soft drinks), a command button could open up a worksheet and bring...

My listbox is not a multi select listbox. Is that my problem? I have my userform set up so that you can pick the selected items from one listbox and "Add" or "Remove" the item to the second listbox.

Hi, I'm in need of your help!!! I'm trying to find a way so that I can identify listbox items on a userform so that when the user clicks on a command button to transfer these items in the listbox into another worksheet and fills the cells in let's say, range A1 (fill down), that each...

Hi, I'm wondering if anyone can help me with the coding for this scenario: I need to be able to open existing multiple Excel workbooks with a click of a command button on a userform in VBA. This click of a command button must also hide the active userform. Also, I'm only trying to extract data...