LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Control Array Help...

Here is what my objective is (trying to do it in VBA/Excel):

Based on a user's selection, a variable number of options show up.
These options are drawn from a biger list comprising hundreds of
options. For example

Selection: A
Options: 1, 7 and 32

Selection: B
Options 7, 96

This part of the code is simple.

Now the user should have the ability to select (checkbox or some other
control) one/all of the options being displayed. Once the user has
made her selection, some operation is performed at the backend only
for the options selected (e.g. timeVerified for the selected option
is updated in another spreadsheet etc)

I am struggling with the functionality to set up a variable number of
checkboxes that show up based on the initial selection by the user.
Additionally, how can the VALUE in of the selected option be passed
(e.g. 7, 96 etc) so that the underlying program knows what to
change.

Any help/sample code will be appreciated.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
2007 Form Control/ActiveX Control font difference Nikko963 Excel Discussion (Misc queries) 0 April 15th 09 04:21 PM
Help with Control Array Sum Formula Jim May Excel Discussion (Misc queries) 12 October 26th 06 11:03 AM
Creating a Control Array imrylin Excel Programming 4 March 3rd 05 04:35 AM
Dump 2D array into Control ExcelMonkey[_190_] Excel Programming 3 February 23rd 05 06:12 PM
Control array - does it exist in VBA as in VB? Örjan Leringe Excel Programming 2 August 9th 04 06:30 PM


All times are GMT +1. The time now is 07:15 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"