The right punctuation, spelling and spacing is the following:
The new inductee proclaimed, "It (my membership) is my greatest honor!"
The phrase "my membership" should be within parentheses for the sentence to make sense. Besides, in American English, exclamation marks which are part of the quote, go within quotation marks.