listbox / userform

I am using the code below to try and export my userform listbox contents to a new workbook. However, I am getting the error as I commented in the code. I dont know where I am going wrong with this code. Need help please! <code style="margin: 0px; padding: 0px; border: 0px; font-style: inherit...

Hi, i have a database prepared where you can find added values from Column C onwards per Column A, Column A = project numbers Column B= project description Column C = date Column D = phase number Column E = Member Column F = Update Column G = date Column H= phase number Column I =Member...

Hi, i am trying to figure out why the following code doesnt show only filtered data on the listbox. Can someone help me please? Dim rData As Range With Blad1 Set rData = .Range(.Cells(1, 1), .Cells(.Rows.Count, 5).End(xlUp)) If Not .AutoFilterMode Then .Cells(1, 1).AutoFilter...

Hi, i am trying to look for a code to describe the following situation, i have a sheet where all updates are added from Column C; Column A has the reference numbers, Column B description of the reference number Column C has the date of update Column D has phase number of each reference Column...

Hello, I'm sorry if my Title question is not clear as I don't know how to properly put it in English. Here is what I mean : Suppose that I have a range named ITEM which content : Fish Snapper Red Fish Baramundi Fish Snapper Fillet Fish Snapper White Fillet Fish Snapper Red Fillet Fish Salmon...

When a user clicks the submit button all information from the form is transferred to tab in my workbook. The part of this I am having trouble with is the count of selected items from a 3 listboxes. Each listbox needs a separate count going to a different cell. Start of the transfer: Private...

Hi all, I want a macro which can give single name to all similar data in a column. Sample data provided below: ABC.com ABC.com ABC.com Xyz.llb Xyz,tz Gisp inc Gisp tpo After running the macro, the excel data in selection to be displayed like: ABC ABC ABC Xyz Xyz Gisp Gisp For this purpose...

Hi everyone, I'm new with VBA excel and trying to create a dynamic search userform using a textbox and list box. 2 parts to this: 1) When user enters text in userform textbox, it should search the database ( rows and 5 columns), and return the values in list box (with 5 columns in this case)...

Hi there - my first post - hope I'm doing it right I have a MultiPage Userform with 5 pages. On page 1 (Index=0), everything works fine. When I'm on the second page (Index = 1) the ListBox click event creates a MultiPage_Change event - not a Listbox_Click event or a Listbox_MouseUp event. That...

Dear All, I'm struggling to do something that should be quite simple. I have a large worksheet with header line and a userform to perform operations on it. One of these tasks is to open another userform with a listbox. I've been able to populate the listbox, resize the columns etc. but I'm not...

Hi All, ListBox1.ColumnCount = 4 ListBox1.ColumnWidths = "25;120;60;80" Me.ListBox1.list = Sheets("Sheet1").Range("A2:AF100").Value My data range is ("A2:BB100") Here in this list box, I want only 2 columns (Column A and Column AF) Can anybody help me to solve this, 1. I want to use variables...

Hello - I am new to posting on here but have found these forums very helpful so hopefully you can help! I am using a userform with a listbox. The listbox is pre populated. When the user selects an item from the listbox, I would like to search previous outputs (in column C) in the worksheet...

Hi, This is first post and i am a very newbie in vba. The purpose is to see and edit the data from the pivot table in the userform listbox. I have a pivot table with four columns: Code (number) | Name (text) | Card Number (number) | SDCard (number). Is sorted by Code column. In my userform...

I've created a listbox in a userform and linked it to the raw data source. 1. Some of the entries are to long for the column although I have a 600pt with, is it possible to wrap the data in the list box. 2. In addition, I don't want every row from the raw data to show in the list, is there a...

Thanks for taking the time to try and figure this one out! At my work we keep a log of companies that do work for us (particularly create drawings/schematics). We take their name and assign them a number. We call this an F#, which stands for Foreign Number (eg. F-125100-001 thru -999). What...

Hello guys first post here, So, I have a list of automotive parts, their start of production, and the capacity of the line like this: Current Part W Part X Part Y Part Z July, 2016 August, 2016...

I have a button that when clicked populates a listbox from a sheet ("Data") based on a filter set by a value in a textbox (TextBox1) on the userform. The code seems to bomb out at the line below regardless of what column I enter. It appears that maybe it doesn't want to go above 9 for some...

I am trying to build a userform that contains a listbox in it. I want to populate this listbox with data from a sheet called "DataSheet". Columns 1 through 7 are Farm Name, Crop, Date, Bushels, Price, Revenue, and Contract Number. Right now I also have two comboboxes, that when updated, post...

Hi Guys, I downloaded sample code but I dont have the writers name to thank him, sorry about that. Anyway I have a userform with a Combobox "D1" for searching suppliers and a Listbox2 to display all information pertaining to the supplier selected when I press on CommandButton1. Everything is...

Attempting to get all these posted to specific cells in excel tab but for some reason everything is showing up except list boxes. If someone could look over and reply with a solution please? Private Sub cmdAdd_Click() Dim lRow As Long Dim lPart As Long Dim ws As Worksheet Set...