Changing Userform content size automatically

[Phili]

Hi

I want to set up a general general RFQ compiler using Excel.

I would start with a table and manually input part numbers. Then I would use a macro to input suppliers and prices.

There could be 20 parts in total but some suppliers might only be quoting for 1 or 2.

I am thinking of using two Userforms for this.

The first Userform would be for entering the supplier info and identifying how many parts this company will be quoting.
The second Userform is for selecting these products and entering the prices.

I want to select the parts, in the second Userform, using a listbox but the amount of list boxes available in the second form should correspond to the amount of parts being quoted. So if in the first Userform I say that the company is quoting for 5 of the 20 parts then only 5 list boxes should be available in the second Userform.

Is there a way to do this?

 

[dmt32]

Hi,
welcome to forum

What you are asking should be doable but suggest that if you are new to userforms then have a look here:https://www.contextures.com/

This is just one of a number of sites that offers free guidance & sample files you can down load.

Here is one example file that may be of interest:https://www.contextures.com/ExcelTemplates/PartLocDBComboAdd.zip

This is just an example file but should give you some idea what will be involved in developing your project

Hope Helpful.

Dave

 

[Phili]

Thanks Dave. I'll have a look through that and see how it goes.