Dear Experts,
I am trying to make a drop down menu in Microsoft Excel 2003 using VBA as the following sample:
I create a drop down menu in B3...and has the following value: "01", "02" and "03"......what should I put the code in order to do like this:
If I select "02" it will appear automatically "pencil" on the C3....???
I attached my file for your review...if you need it...![]()
Thanks a lot for your kind helps..
Jennifer![]()




Reply With Quote