Daniel Cremin
Board Regular
- Joined
- Feb 23, 2002
- Messages
- 64
Hi im designing a worksheet based wizard - one of the features is one where i have to select the solution or solutions that apply to a student in need - they are Revise more thorougly, Attend Lessons, Review the Notes at home, Change Examination Approach, Pay attention in class and ALL of these - sometimes it might involve only selecting one of these other times 3 or 4 - i cant use option buttons, as only one can be picked at a time - VBA will make the equivalent text in an underlying worksheet go Boldened Black if the Control is entered in the affirmative - I need to know if i choose to use tick boxes the code needed to be able to make a cell do something if a specifically named check box is set to true - can i use Case Select for a form using the Sheets("Whatever"). CheckBox("the name of it". Value= True - what is the code and dyou reckon i can get away with a simple series of Case Select statements with End Selects put after each - remember there are more than one check box to be analysed by the macro.
Thanks so much to ne one who can help out
This message was edited by Daniel Cremin on 2002-03-13 15:21
Thanks so much to ne one who can help out
This message was edited by Daniel Cremin on 2002-03-13 15:21