A code which is meant to multiply a cell by a combobox but doing other things?!

[rmp123]

Please Login or Register  to view this content.

I have a piece of coding which is meant to multiply the cell in D29 by ComboBox1 to get a result in cell D30, but it will only do this when something is clicked on each time in ComboBox1. I want cell D30 to have a result each time D29 is altered, rather than having to click on the combobox list repeatedly!

Thank you in advance....

[protonLeah]

You don't give much info. What module is the macro in? If you want the code to run when a cell is changed, it should be in that same sheet's Worksheet_SelectionChange( module; and you'll have to add code to ensure that it only runs on changes in D29.

[rmp123]

I am not sure what you mean by what module is the macro in?

It only changes to cell G29 as nothing else is linked to cell G30, if that is what you mean?

[xladept]

Why don't you use a worksheet change event for your D29 value??

Oops, I see that Ben already suggested almost the same thing.

[rmp123]

How would I do that?

[xladept]

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[rmp123]

Please Login or Register  to view this content.

[rmp123]

I have the same problem with G30

[xladept]

Hi rmp,

Try:

Please Login or Register  to view this content.

Under the ComboBox1_Click code in the Sheet1 module.

[rmp123]

Hi that code is not working either

Why did you put D9 in the code? isn't it supposed to be D29?

[protonLeah]

Please Login or Register  to view this content.

[rmp123]

ProtonLeah it says Compile error: Block If without End If

[rmp123]

protonLeah when I type your code then my value in D30 does not change at all!

[xladept]

Yeah, change it to $D$29 but it's the same as ProtonLeah's code.

BTW - Did your code work before??

[rmp123]

it does not work! ProtonLeah's code blocks all my code from doing what its meant to

[rmp123]

I have tried alot of codes but when only when the combobox value changes from the drop down list the value in D30 changes, but I want it to change when D29 changes as well as when the combobox value is changed

[xladept]

Hi rmp,

Try this:

Please Login or Register  to view this content.

[rmp123]

no that does not work either...

I just linked the combobox with another cell and put the IF formula into cell G30 and multiplied G29 by the other cell link, which was my last resort but its working!

Thank you anyway

[xladept]

Hi rmp,

My program does work but I noticed an error in your CLEAR code - this is better:

Please Login or Register  to view this content.