Userform help needed - matching combox value to worksheet identifiers

My apologies, I was trying to broaden my queries visibility but had forgotten to link the other post. Please feel free to delete this post as it's in violation of the forum rules.

Sorry again.

I've now changed the userform slightly. The Slot combobox is populated by the slot range on the sheet1 (calculator).

All I really need help with is tell the user form to see the value in the combobox, where that value is on the worksheet and then insert the other combobox values, offset slightly so that they're entered into the correct columns (B11, D11 and F11).

If someone would be as kind as to showing/telling me how to do that, I'll do my best to cobble the rest together.

Cheers

FYI - This same new request was asked on the original post on Mr Excel.

http://www.mrexcel.com/forum/showthr...71#post2441371

I am going to keep both updated.

Hi all,

This was answered successfully on the original post on Mr Excel.

Originally Posted by snowblizz

I think you should be able to use the Find method. Something like this which is loosely based on the helpfile's example.

Please Login or Register  to view this content.

I have also added a small query to the original question (below).

Thank you so much Snowblizz! That worked marvelously. I've now altered that slightly so that the Durations "Add" buttons work in the same manner!

There's one thing I've noticed that I would ideally like to amend, and that is preventing the submit button from functioning if any of the Comboboxes are empty - to prevent the user from accidentally adding just the slot assignment or project and no test stage etc.



Would you know what I'd need to add to your code example to get this to function this way?



many thanks again!!

This problem has now been solved.

Originally Posted by snowblizz

Depends a bit on how the form is set up. I do have a idea though.



Disable the Submit button in its properties.



add this sub to the userform, (and adjust to suit your controls)

Please Login or Register  to view this content.

and in each combobox event place a call,

Please Login or Register  to view this content.

at the end of the code



this would then, hopefully, each time the user changes a value run the test and enable the button when all fields have a value.

thanks to all who looked into this for me.

Originally Posted by snb

or

Please Login or Register  to view this content.

This also disables the commandbutton if there'a change in one of the comboboxes.

That also works for me, and is smaller and neater :D