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.