Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #4  
Old 11-19-2014, 01:55 AM
gmayor's Avatar
gmayor gmayor is offline form control Field - Drop down auto text Windows 7 64bit form control Field - Drop down auto text Office 2010 32bit
Expert
 
Join Date: Aug 2014
Posts: 4,137
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

The 'code' I posted is not part of a macro. You cannot achieve exactly what you have attempted with a macro. You could use it to write to the cell directly, though that would need the form to be unlocked. In fact there is no need for a macro to do this. You can use a conditional field (or fields) and that is what I have posted. I have inserted it into your form so you can see how it works. Select a meal and tab out of the field. (I think I have the meals right but please check).

It also entailed setting the default tabs at a new value, which affects the whole form. You may need to check your tabs and apply paragraph format tabs as required.
Attached Files
File Type: docx RTC-ADRR-112014-test.docx (164.9 KB, 20 views)
__________________
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
form control Field - Drop down auto text Adding auto text to end of content control field ksigcajun Word VBA 4 10-13-2014 05:37 AM
form control Field - Drop down auto text MS WORD 2007 - Content Control versus Text Form Field question chamdan Word VBA 2 11-12-2013 09:51 PM
form control Field - Drop down auto text Form Field Drop Down List James Ayers Word 3 07-14-2013 07:53 PM
Word Form/ActiveX drop down menu/value in a different field AMackenzieFFCU Word VBA 1 01-14-2013 07:48 AM
form control Field - Drop down auto text Form Field - Drop down selection causing auto text chesspupil Word VBA 7 05-09-2010 05:43 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:05 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