DaveGib
01-03-2014, 11:58 AM
Hi Everyone,
I have a problem that I have been scratching my head all day on and am asking someone to please help!
I have a user form that has 3 comboboxes on it with lists that the user can select data, then the selections are saved to a datatable. This all works fine, but my problem is that I also need to save some additional information that is dependant on the result of two of the combobox selections, and cant get the lookup to work.
Basically if "Foreman" is selected from ComboBox8, then I need to look up a rate using the Input in ComboBox6 from a Range called "MilestoneRate" from another sheet. I then need to assign the result to a variable called "Rate" and save it with the rest of the form data to a table.
I have attached the code I have used for the lookup, - I also attach the code I have used here.
Any help will be greatly appreciated............
Thanks in advance!
I have a problem that I have been scratching my head all day on and am asking someone to please help!
I have a user form that has 3 comboboxes on it with lists that the user can select data, then the selections are saved to a datatable. This all works fine, but my problem is that I also need to save some additional information that is dependant on the result of two of the combobox selections, and cant get the lookup to work.
Basically if "Foreman" is selected from ComboBox8, then I need to look up a rate using the Input in ComboBox6 from a Range called "MilestoneRate" from another sheet. I then need to assign the result to a variable called "Rate" and save it with the rest of the form data to a table.
I have attached the code I have used for the lookup, - I also attach the code I have used here.
Any help will be greatly appreciated............
Thanks in advance!