Thread: selection all textboxes in userform at once
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Marthijn Beusekom via OfficeKB.com Marthijn Beusekom via OfficeKB.com is offline
external usenet poster
  
Posts: 2
Default selection all textboxes in userform at once
I made a userform with over 20 textboxes (TBX). All boxes have a 'easy to
understand' name. At some moment I need all testboxes to be 'opened' or
'blocked' or to be 'emptied'. Is there a way to select all TBX at once?

My current solution looks like this:

MultiPage1.Value = 0 'Gegevens
GegKl.Enabled = True
GegNm.Enabled = True
GegRubr1.Enabled = True
GegRubr2.Enabled = True
GegStnr.Enabled = True
GegWplts.Enabled = True
MultiPage1.Value = 1 'Dressuur
DrPnt.Enabled = True
DrPntOv.Enabled = True
DrStnr.Enabled = True

Thank you so much for your help!!

--
Message posted via http://www.officekb.com
Reply With QuoteReply With Quote