I am using the code below, and trying to change the shape color,, on the excel sheet, I added a combobox with items "vbBlack, vbRed,vbYellow"
everytime the code runs, it gives me an Error 13 Type mismatch. how can I fix this, so the error doesn;t reproduce and accept the string/value.
Please Login or Register to view this content.
Bookmarks