Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #5  
Old 08-10-2023, 04:49 AM
Formd Formd is offline Inserting text from checkboxes Windows 7 32bit Inserting text from checkboxes Office 2007
Advanced Beginner
Inserting text from checkboxes
 
Join Date: Feb 2015
Location: TX
Posts: 49
Formd is on a distinguished road
Default

Thank you for this. Select Case worked for me however, I got an error with FillBM; not sure if I was supposed to substitute something there. I used the following and it works.

Select Case True
Case Chbx2 = True And Chbx3 = True And Chbx4 = True And Chbx5 = True And Chbx6 = True
Selection.TypeText Text:= "First", "CheckBox2, CheckBox3, CheckBox4, CheckBox5 and CheckBox6"
Case Chbx2 = True And Chbx3 = False And Chbx4 = True And Chbx5 = False And Chbx6 = True
Selection.TypeText Text:= "First", " CheckBox2, CheckBox4 and CheckBox6"
End Select


Content Controls, I am not familiar with but I am going to try it.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
UserForm with checkboxes that hide/show bookmarked text in document dohertym Word VBA 4 05-16-2022 09:48 PM
Inserting text from checkboxes Use VBA to create checkboxes and text boxes in Word rotunda Word VBA 6 06-16-2021 03:13 PM
Macro-inserting text box BLUEPUPIL Word VBA 14 04-16-2018 06:59 AM
Inserting text from checkboxes Inserting and rearranging text by inspecting existing text rok123 Word VBA 9 02-05-2016 07:31 PM
Inserting text from checkboxes Mutually exclusive checkboxes with text jt3writer Word VBA 2 01-21-2015 12:41 PM

Other Forums: Access Forums

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