combobox vba

Is there a way to collect unique values from several columns (eg E4 to H1500) and put those values into a userform Combobox with no duplicates. like: E4 F4 G4 H4 row1 Byan PDIV RSI2 Row2 E5 F5 G5 H5 RSI Byan T8 RS and so on ...

im kinda still new to VBA and need some help with the coding 0 i need to make a combo box that lists all items in column A where the user can add to the list (on excel sheet) and have it auto update. once the user selects an item, i want to have a text box show the data in the cell to the right...

Hello I'm trying to add a range of elements to a comboBox but every time I try to do it i get the message "Run-Time Error '1004' Application-defined or object-defined Error'. Can any of you explain me what I'm I thinking wrongly, my code is: Private Sub ComboBox1_Change() With...

Hi all and thanks in advance for your help. What I am trying to do is create a userform to fill a sheet with data. I have a collection of Survey plats and drawings that I nee to be able to find and associate with current projects. What I have is a user form w/ several comboboxs. Some are...

Hi - I am incredibly new to using macros, so I am having difficult doing the following: I have a combobox with 20 different choices, all of which relate to a new row on a worksheet. I want to make it so when one of the 20 options is chosen, the spreadsheet jumps down to the row in which it...

Hi all, newbie here with excel 2010 macro: created a combobox (from under 'form controls'), the purpose of which is that the user makes a selection which then populates the active cell (ie the cell the user highlighted before making the selection from the combobox). The population should happen...

I am using a Form which has a drop-down style Combobox. The Combobox's list is loaded via VBA, with 20+ items. I am using the code below to highlight the default value for the list, which works fine: (for some reason, the method header is turned to asterisks, so use the Rem'd line to finish...

I have a combobox with listfillrange of three columns of data (sheet2!A1:C20). ColumnA ColumnB ColumnC -------- -------- -------- Data1 Data2 Data3 ... I know if I do ComboBox1.Value --> this will get me Data1. How can I get the value in ColumnB, Data2?

I'm at my wits' end with this - I've searched multiple places on the web and gotten exactly 0 working suggestions, though it seems other people have run into this problem as well. I'm using Excel 2007 SP2 on Windows XP. The problem is that when I open my spreadsheet on computers with...

Hi! I'm trying to do something that I thought would be easy but I cannot get the hang of it even so. I have placed a form combobox on my sheet and I would like to fill it from VBA code. But, I cannot even figure out how to refer to the combobox object from VBA. I'm using Excel 2007. Any help...