Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Lydia Hughes   on Oct 03 In MS Office Category.

  
Question Answered By: Joel Brown   on Oct 03

I guess I was not clear enough.
Of course you can call your controls whatever you like and naming convention
are not a must. The problem is that Chuck was using the name property in order
to check the control type (i.e. if it's a label, a frame  or an optionBox,
etc...).
Chuck uses the following
If InStr(1, ctl.Name, "Frame", vbTextCompare) Then

In this case, his code  will work only if he calls his controls Frame1, Frame2
or FrameX, TextBox1or myTextBox, etc...

I suggested that he uses the typename function instead.

Share: 

 

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

 
Didn't find what you were looking for? Find more on All Frames and Optionbuttons in a UserForm Or get search suggestion and latest updates.


Tagged: