form control list box

I am trying to create a drop-down list for every cell in column "S", using data from cells in column "X". I have successfully created one for the first cell (S2), but how do I duplicate this menu for every cell in that column without having to laboriously create a new individual menu for each...

Hi I have a list of dates in E5 to E7, in long date format. I have a form control with an input range of E5 to E7. The cell M5 also has long date format and is the cell link for the format control. Cell M5 does not display the correct dates from the dropdown list and instead displays 1,2 or...

Hi, Due to compatibility issues, I am having to use a form control listbox (vs. ActiveX) control on my spreadsheet. I am trying to populate it with three fields from an ADO recordset, but I am having problems as it has been sometime since I have used Form Controls. Here is the code I...

Hello! I'm trying to improve a workbook that uses VBA macros and I have no experience with VBA. I've studdied the current excel workbook and vba code to help me. I've been learning about vba and I've been able to sort out some problems but now I have no idea what's causing my error. Btw, the...

Hello, I've been searching the web for hours and it seems I just can not locate exactly what I need. I'm hoping someone can assist. I've created a userform that has a listbox which users can add items. I have set the RowSource to the named range in the Excel spreadsheet that will also hold...

Hi Everyone I have used/changed activex control listbox to form control list box but I can't able to perform some vba operations. Such as clear, list and add item and below is my code for activex listbox and I need to change it to form control list box. Name of the list box :List Box 45"...