Copying text from form into cell.

Hello Everyone,

I am a noobie in VBA and I am currently trying to copy the text from a form created in excel (not ActiveX) into a message box but all I get is the choice number.

Sub test()
   Dim y As String: y = Sheets("Entry form").Shapes("entry_type").ControlFormat
   Msgbox y
End Sub

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #2 requires code tags. I have added them for you this time because you are a new member. I also fixed a VBA syntax error on the last line. --6StringJazzer

is there anywhere to quote the text in the list form?