Thread: Message box to input a value
View Single Post
 
Old 09-14-2020, 04:32 AM
gmayor's Avatar
gmayor gmayor is offline Windows 10 Office 2016
Expert
  
Join Date: Aug 2014
Posts: 4,142
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default
Don't use SET as a string variable name. SET is a reserved command name in VBA and will produce an error if used in this way Charge it to sSet of strSet.

Note also that content control titles are case sensitive so if the CC is called "Full time" the VBA needs to address it in the same way.

Personally I don't like the use of hidden text except perhaps in a document the final version of which will be distributed either printed or as PDF. I prefer to fill content controls with the appropriate texts based on the selected value.
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote