Hi there, Would just like to say this forum has been invaluable to me as i am currently working on my first VBA project and hav only been using it for a few days.
My scenario is,
I have a Userform(estimatingtool) which contains 2 radio buttons and 3 Comboboxes. The three Comboboxes contain Selectable items (which are made from items in a database(Which someone from this forum kindl helped with))
is there a code in which the radibox selection and the three combobx selections are used to lookup a databse and find and display the other information which is contained on the same row of the databse.
I have attatched a copy of the workbook
(EDIT)
heres an easier breakdown of what i am trying to do
1) take values from 3 seprate comboboxes and a radio button.
2) Locate the row on the sheet "databse" which contains all of the values from the 3 comboboxes
3) on said row there is information which i would like to be either A) copied into sheet " Estimation tool" or outputted via a user form or msgbox
many thanks
Jay Russ
Dummybook.xlsm
Bookmarks