So I have a database which catalogs all possible components of a piping line (pipe, elbows, valves, etc.). For each possible piece of equipment, there is an associated pressure drop based on the fluid flowrate, and length of pipe/ number of valves. So what I am trying to do is filter the equipment using comboboxes on a userform(code is done), then I want to copy the cells from the database into textboxes on the userform. That way, the user can alter the inputs, such as flowrate, or pipe length. Then I want the values of the pressure drop to update based on those changes, and then be able to dump that info onto another worksheet. So basically what I am asking is if there is a way to link my userform textboxes to the cells on the spreadsheet, so that not just the text is brought in, but also anyh formulas and cell references. I tried specifying the control source, but since I am using a filter to select the piece of equipment, the source is always changing. I know this is a long post, but hopefully it has enough info that someone can understand what I am trying to do and help me out.
Thanks in advance,
Chris
Thanks in advance,
Chris
