Gents is there anybody that could look and see if they can helpplease.<o></o>
I have created a Pricingworkbook for construction works. However, I am having problems completing.<o></o>
The Plan is, in each sheet named 1 to 20 if you double click oneach coloured cell titled: Materials, Labour, Plant and Test Equipment adifferent form appears for each title. <o></o>
If you then push the drop down on the Combo Box a selection ofheadings are shown, you then click on the heading, which then brings up aselection in the list box.<o></o>
If you then highlight 1 or more of the selections and push theCommand button it will add a line or lines with the selection or selections andits adjacent cost/costs from the lookup table and place it under the colouredcell that initiated the user form<o></o>
<o> </o>
Problem 1: I have managed toget the first two user forms to appear (Materials and Labour) but I cannot getthe other two to work.<o></o>
<o> </o>
Problem 2: Because I have used the first user form as a template, I cannotchange the headings that are used in the COMBO BOX 1. It works fine in the original user form 1,which takes the data for the headings from the LV-Look-up table but the userform 2, 3, 4 will only work with the original headings which are of no use.<o></o>
<o> </o>
The user forms should be looking for the data for the differentheadings in the other sheets labelled (SL)(PLT) (TE) look up tables. <o></o>
However, as soon as I change the names of the headings in theother look up sheets the code fails.<o></o>
Problem 3:<o></o>
The Combo Box will only show 6 headings, can this bee increased, Ithought by increasing to 9 alongside (list Rows) in the properties table forthe combo box, but this does not work.<o></o>
<o> </o>
I’m not VBA fluent and I have spent over 8 hours trying variousways but to no avail I’m sure for a competent VBA user it would only a shorttime to complete to correct.<o></o>
If there is anybody that could complete for me I would be preparedto pay for the work if required.<o></o>
I have created a Pricingworkbook for construction works. However, I am having problems completing.<o></o>
The Plan is, in each sheet named 1 to 20 if you double click oneach coloured cell titled: Materials, Labour, Plant and Test Equipment adifferent form appears for each title. <o></o>
If you then push the drop down on the Combo Box a selection ofheadings are shown, you then click on the heading, which then brings up aselection in the list box.<o></o>
If you then highlight 1 or more of the selections and push theCommand button it will add a line or lines with the selection or selections andits adjacent cost/costs from the lookup table and place it under the colouredcell that initiated the user form<o></o>
<o> </o>
Problem 1: I have managed toget the first two user forms to appear (Materials and Labour) but I cannot getthe other two to work.<o></o>
<o> </o>
Problem 2: Because I have used the first user form as a template, I cannotchange the headings that are used in the COMBO BOX 1. It works fine in the original user form 1,which takes the data for the headings from the LV-Look-up table but the userform 2, 3, 4 will only work with the original headings which are of no use.<o></o>
<o> </o>
The user forms should be looking for the data for the differentheadings in the other sheets labelled (SL)(PLT) (TE) look up tables. <o></o>
However, as soon as I change the names of the headings in theother look up sheets the code fails.<o></o>
Problem 3:<o></o>
The Combo Box will only show 6 headings, can this bee increased, Ithought by increasing to 9 alongside (list Rows) in the properties table forthe combo box, but this does not work.<o></o>
<o> </o>
I’m not VBA fluent and I have spent over 8 hours trying variousways but to no avail I’m sure for a competent VBA user it would only a shorttime to complete to correct.<o></o>
If there is anybody that could complete for me I would be preparedto pay for the work if required.<o></o>