Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #6  
Old 09-14-2020, 04:32 AM
gmayor's Avatar
gmayor gmayor is offline Message box to input a value Windows 10 Message box to input a value 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
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Create Custom Form in Outlook 2016, for the Message setting 'Do not include original message' jsvictor1989@gmail.com Outlook 0 01-30-2019 10:54 PM
trouble with input box gummybear Excel Programming 0 12-04-2018 06:39 AM
Need Help on Input Video into PPT agus PowerPoint 2 07-13-2015 02:25 AM
Message box to input a value Message replys are shown at the bottom of the message, how can I get them to the top Gardy Outlook 3 05-23-2012 01:20 AM
Message box to input a value Input Box ubns Word 2 04-13-2012 06:28 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:13 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft