scottmcclean
New Member
- Joined
- Jul 2, 2014
- Messages
- 33
- Office Version
- 365
- Platform
- Windows
Hi there,
I have a VBA userform that has two drop down lists and a text box. I currently have the first drop down list populated with Low, Medium, High and the sceond drop down list with Likely and Unlikely.I have the drop downs linked to a 2 column dynamic range - the second column has numeric values against the text values.
I would like the two numerical values multiplied and the answer to populate the text box.
I am not sure how to do this?
I have a VBA userform that has two drop down lists and a text box. I currently have the first drop down list populated with Low, Medium, High and the sceond drop down list with Likely and Unlikely.I have the drop downs linked to a 2 column dynamic range - the second column has numeric values against the text values.
I would like the two numerical values multiplied and the answer to populate the text box.
I am not sure how to do this?