Inserting text from checkboxes

		Microsoft Office Forums > Microsoft Word > Word VBA
Inserting text from checkboxes

08-08-2023, 03:40 PM

Guessed

Windows 10 Inserting text from checkboxes

Office 2016

Expert

Join Date: Mar 2010

Location: Canberra/Melbourne Australia

Posts: 4,177

The Checkboxes can only be True or False so lines like this

Code:

Case Chbx2 = True And Chbx3 = True And Chbx4 = True And Chbx5 = True And Chbx6 = True

can be made much shorter

Code:

Case Chbx2 And Chbx3 And Chbx4 And Chbx5 And Chbx6

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia

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
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 and rearranging text by inspecting existing text	rok123	Word VBA	9	02-05-2016 07:31 PM
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:29 AM.