Refer .font.name, .font.size, line.dashstyle to a cell instead of hard coding.

So, this may be an easy question, but I'm new at this and trying to learn. I'm creating a basic macro template, where the user can setup a custom text box, and just create as many as they need and have them formatted the same way. My code that works, looks like this:

Please Login or Register  to view this content.

Now, what I want to do is, allow them to select the font, the font size, and the outline of the box from a drop down list on the worksheet, so when I try to programmatically refer to a cell for any of these options, it does not work:

Please Login or Register  to view this content.

So those values of Font name, font size, and dashstyle, I want the user to be able to select from a dropdown I can put in a worksheet cell. I'm sure this is just syntax, and I'm a noob trying to learn, so if there is anyone out there who can help me with this and take a few seconds to reply, I'd be most grateful.

well, i figured it out, I don't know why it didn't read directly the font name from the cell, but I had to name the font sell as a string. posting the code that work. thank you for your help.

Please Login or Register  to view this content.