Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
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,143
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
  #2  
Old 09-14-2020, 04:35 AM
4Star1957 4Star1957 is offline Message box to input a value Windows 10 Message box to input a value Office 2016
Novice
Message box to input a value
 
Join Date: Sep 2020
Posts: 12
4Star1957 is on a distinguished road
Default

Thank you Graham, but I'm not sure what to use in place of "Set".
I will check your tips out and see if I can find my answer there.
Reply With Quote
Reply

Thread Tools
Display Modes


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 05:35 AM.


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