userform search

[Phil C]

I have a spreadsheet that contains dimensions and prices for steel. I want to create a userform that the user enters values into three text boxes (Length, Width and Height) and then when a command button is clicked the price, code number, class and quantity available are returned into text boxes on the same userform. Is there a way to set up a search via a userform command button?

Thanks in advance

 

[Juan Pablo González]

Well, yes, you can use the .Find method of a range to look for things in there. Or, you can use formulas like VLOOKUP or DGET to search a database (In an Excel worksheet) to get a value based on some conditions. You can use all this in VBA without any problems...