Thread: Inserting text from checkboxes
View Single Post
 
Old 08-08-2023, 03:40 PM
Guessed's Avatar
Guessed Guessed is offline Windows 10 Office 2016
Expert
  
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 4,159
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default
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
Reply With Quote