Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Jodon Brown   on Sep 04 In MS Office Category.

  
Question Answered By: Muriel Dunn   on Sep 04

You're may want to go through the Form Controls:

For Each cntl In MyForm.Controls
If InStr(cntl.Name, "TextBox") Then
Select Case cntl.Value
Case Is < 2

End Select

End If
Next

This assumes that you want to do this with all TextBoxes in the Form,
and that they've got "TextBox" as part of their name.

There is also a TypeName(cntl) = "TextBox" construct, but I've not had
consistent results with it. It could be because I don't know how to
use it.

Share: 

 

This Question has 1 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on Avoid multiple select constructs Or get search suggestion and latest updates.


Tagged: