I have created a drop down list in excel. From the list the user select the proper value. Based on the users selection I need VBA to fill in a predefined text in the cell to the right.
The drop down list is in range B2:B10 and could contain values like "ABCD","AB12" etc and the text to be added in Cell C2 should be e.g "remember to fill in additional information by replacing this text"," no further documentation is required". All values from the drop down will have related text that should go to t C column. I have tested lookup/vlookup but cannot use it since the user should be able to replace the predefined text with his/her own words which is not possible if i have a formula in the cell. I hope this make sence and thanks for all help you can provide, best regards Oscar