Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating/Adding Combobox
I have a userform that is used to enter item number (textbox1) and quantity
(textbox2). The listing of all existing item numbers and item descriptions are in worksheet "Items" (A:A & B:B respectfully). How do I create/add a combobox for textbox1 pulling from the list in the Items worksheet? Thanks, Les |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating/Adding Combobox
Dim cell As Range
Dim iLastRow As Long With Me.ComboBox1 .Clear iLastRow = Worksheets("Sheet1").Cells(Rows.Count, "A").End(xlDown).Row For Each cell In Worksheets("Sheet1").Range("A1").Resize(iLastRow) If cell.Value = TextBox1.Value Then .AddItem cell.Offset(0, 1).Value End If Next cell End With -- --- HTH Bob (change the xxxx to gmail if mailing direct) "WLMPilot" wrote in message ... I have a userform that is used to enter item number (textbox1) and quantity (textbox2). The listing of all existing item numbers and item descriptions are in worksheet "Items" (A:A & B:B respectfully). How do I create/add a combobox for textbox1 pulling from the list in the Items worksheet? Thanks, Les |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding Combobox Values | Excel Programming | |||
creating a combobox dynamically on an excel sheet | New Users to Excel | |||
Dynamically adding data to a Combobox? | Excel Programming | |||
Having problems with adding input from combobox | Excel Programming | |||
3 possible methods for adding value to a combobox | Excel Programming |