list box vb excel

This code works fine in the listbox, But when you try two scenarios, the following happens: 1) when replacing a line (myCols = Array(1, 3,4, 5, 7, 10) with TextBox and let TextBox 2 written inside it (1,3,4,5,7,10) it gives me an error message (application defined or object defined error...

Hello eveyrone, Everytime timw I use the search textbox and don't have caps on, the listbox shows multiple lines with the same data. My code does use the Ucase command but I would like to use upper or lower case with no duplicates How do i stop this from happening? My code...

Hi I am trying to pull data from other sheet based on single cell (Month) reference. Just like a list in one cell. Sheet 1 contains multiple entries segregated with month column. I need it all in a different format which I need to grab with single validated list. Any possibilities?? Sheet...

Hi All, I have a form called frmRemitSpinner with a listbox control called lstInvoices. I want to populate the entire list box based on a dynamic range InvoiceList but based on some conditions that I define in my SQL...

Hello, New here. I want to use a form as a data entry window for an excel sheet, so that the user need not even visit the actual sheets and just work off the form window. I have used tabs tips to label all sheets in the file. and I want to a listbox to display each sheet table depending on...

I have created a document that has a list box where the user selects the items and then adds them to a restricted section of of a Ammo Tab A27 - A71. when the user opens the form up with the list box there is 2 items automatically selected, how do I stop this. I have attached a link below with...

Hello, I'm working with an excel worksheet with macros and there are several Combo Boxes (Form Control) on one worksheet. Most of these Combo Boxes have only 2 items to choose from so I thought it would be nicer to have List Boxes to replace them. I started by trying to replace just one combo...

Hi! I haven't been able to find an answer on this and my issue could be piecing together code I found on multiple forums. This worked fine with the first combo box I tried but I am unable to get this to work on subsequent worksheets. My goal is to have an ActiveX ComboBox drop down...

Hi All VB experts, Need your help, how can I get the selected row and coloumn value when I click the list view ? For example : I have below list view with first coloumn as a header : Pers No Detail name Department 32998001 Alex FG Marketing...