View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
SupC SupC is offline
external usenet poster
 
Posts: 1
Default Getting values from a dynamic userform


The spreadsheet contains x number of possible data sets to chart. A
userform is dynamically created that contains x number of checkboxes.

How do I find out which check box(es) were selected? The problem is
that the number of data sets/checkboxes can vary depending upon which
spreadsheet is opened.

On a seperate note, why is it different code to show a dynamically
created userform than one created in the VBE?

VBA.UserForms.Add(VBComp.Name).Show

vs.

UserForm1.Show


Thank you.


--
SupC
------------------------------------------------------------------------
SupC's Profile: http://www.excelforum.com/member.php...o&userid=23941
View this thread: http://www.excelforum.com/showthread...hreadid=376054