Update Cell Value when ComboBox value is changed

[frostii]

Hi all,

This should be a nice easy one for you gurus, as long as I can hopefully explain what I'm after.....

I have a Userform with 2 x checkboxes on the left and 2 x comboboxes on the right. By default, the checkboxes are unticked and the comboboxes have "Not Applicable" written in them.

Now, I want the user to tick the box if it is applicable, then choose the combobox value which will update the cell accordingly. Unfortunately, once you have ticked the checkbox, it displays "Not Applicable" but won't update the cell if I make a different choice in the combobox.

Unticking, then re-ticking the box updates the value in the cell, but I can't expect the user to know this.

In other words, how can I get the combobox to update the cell whenever a different choice is made? (dynamic choice, per se?)

Here is my very basic code:

Please Login or Register  to view this content.

Please be gentle, I'm very new to this!

Thanks.

[kasan]

Hi,
You probably need some event of combobox.

Please Login or Register  to view this content.

[frostii]

Hi,
Sorry for my incompetence, but what do you mean?
I was thinking of a recalculation of sorts when I hit an OK button, something like that. Is that what you mean? Any code would be appreciated......

[kasan]

As I understood your need - when value in combobox is chosen - this value should be represented in a cell.
Here is small example.

Please Login or Register  to view this content.

[frostii]

Thanks for the reply.
I have decided against using both checkboxes and comboboxes. Only the comboboxes are really required.
I have adjusted your code above to suit, thanks very much.
Marked as SOLVED.