Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Greetings everyone. I'm not sure if I can do this, but on a user form I have
a combo box that populates from a range on sheet 'DATA', with items. There is also a text box that I want to find the price of that item. Thoretically, assuming my data is such that item is in column A of 'DATA', starting at row 18, and price is in column B of 'DATA', how can I get the price of the item selected from the combo box. I found a post by Dave Peterson to populate the list of the combo, but I am at a loss as to how to populate the text box for price. Any ideas? Below is the code to populate the list(thanks Dave). Private Sub UserForm_Initialize() With Worksheets("Data") Me.cboFuel1.List = .Range("A18", .Cells(.Rows.Count, "A").End(xlUp)).Value End With Greg |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro to populate web form | Excel Programming | |||
Populate form from row data | Excel Programming | |||
how do i use the text in a cell as a named range in a vlookup form | Excel Discussion (Misc queries) | |||
Populate a form | Excel Worksheet Functions | |||
Populate Userform text boxes in VBA with VLookup data from #2 worksheet | Excel Programming |