ComboBox choice overlaps content of a specific cell

[bobby.bobby]

Dear all,

I'm having some trouble with the development of my excel/VBA tool.

To be specific. I am looking for a way to replace a specific cell with the use of a ComboBox. By this is I mean that, if i choose USA as a country in my Userform ComboBox I would like a specific cell from one of the sheets on my document to be replaced with the selection made in the comboBox. Therefore, USA would replace Cell B3 on Sheet3 (Synthesis Tab). In the example below I have used a data validation list to choose the country which is what i would like to get rid of.

This would need to be done a number of times and for a number of questions which are present in my comboBox so that the database that the synthesis tab that I have created would be automatically updated and the formula within my synthesis table would calculate the ratios accordingly.

Note that the choices from the ComboBox would not only replace cells from the same Sheet so if could provide me with the coding that would specify the sheet and cell we are trying to change.

Does anyone know how to do this?

[Leith Ross]

Hello bobby.bobby,

Replace your UserForm code with what is below.

Please Login or Register  to view this content.