Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Getting values from a dynamic userform

  Asked By: Oscar    Date: Dec 21    Category: MS Office    Views: 751
  

I have a dynamic userform created using:

Workbooks(NameofWorkbook).VBProject.VBComponents.Add (vbext_ct_MSForm)

I added x number of checkboxes to this form (the number of checkboxes
will change depending upon the data from a spreadsheet)

How do I find out which check box(es) have been selected given that the
number of checkboxes is a variable?

Share: 

 

2 Answers Found

 
Answer #1    Answered By: Aalia Arain     Answered On: Dec 21

I assume you have an upper bound to x.

Can't you just put on more than you need and then hide the ones you
don't need ".visible=FALSE" at form  launch/activation?

 
Answer #2    Answered By: Terence Mitchell     Answered On: Dec 21

I assume you have an upper bound to x.

Can't you just put on more than you need and then hide the ones you
don't need ".visible=FALSE" at form  launch/activation?

 
Didn't find what you were looking for? Find more on Getting values from a dynamic userform Or get search suggestion and latest updates.




Tagged: