| Home |
| Search |
| Today's Posts |
|
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
Simple Checkbox Message Code
Sorry I couldn't help.
nemadrias wrote: I think I'm just going to use option boxes. I wanted check boxes because I wanted to be able to select more than one in a group, but I can do without. Thanks so much for all of your help, though - have a great week. Steve Dave Peterson Wrote: I guess I don't have any other suggestions except to take that first suggestion and modify it to include all the checkboxes you need. I guess I still don't understand what controls what and how the checkboxes are "grouped". nemadrias wrote: The user *will *click on the checkbox they are going to change to, but I want to ask for confirmation before they change to it because there are many checkboxes grouped closely that if changed incorrectly could cause some confusion, and it's fairly easy to select the wrong one by accident. The checkboxes are signifying a level of risk involved with each phase of a project, and if the risk level is changed by accident the reports will be off, so I just want to have this added security built in. Any further questions please let me know. Thanks again - Steve Dave Peterson Wrote: I'm not sure I understand, but as a user, I think I would rather click on the checkboxes themselves to change them--rather than answering several prompts that ask me a question about each checkbox. Are you trying to have a "master" checkbox that turns all the other checkboxes on or off? And if you are, how many checkboxes does that master checkbox control and how many groups are there? nemadrias wrote: Hey - Thanks so much for your help so far. That does execute, but I think I explained what I'm trying to do badly. If any certain checkboxes out of (N number of) checkboxes are checked, I want to be able to ask if the user really wants to change TO THAT checkbox and then uncheck the others of the group. So, for instance, in a group of 3 checkboxes, if the first is checked and the user checks the 3rd, it will ask for confirmation, uncheck the first, then check the third. Can you give me some assistance with that? Thanks again, and sorry for the lack of clarity. Steve -- nemadrias ------------------------------------------------------------------------ nemadrias's Profile: http://www.excelforum.com/member.php...o&userid=24613 View this thread: http://www.excelforum.com/showthread...hreadid=552736 -- Dave Peterson -- nemadrias ------------------------------------------------------------------------ nemadrias's Profile: http://www.excelforum.com/member.php...o&userid=24613 View this thread: http://www.excelforum.com/showthread...hreadid=552736 -- Dave Peterson -- nemadrias ------------------------------------------------------------------------ nemadrias's Profile: http://www.excelforum.com/member.php...o&userid=24613 View this thread: http://www.excelforum.com/showthread...hreadid=552736 -- Dave Peterson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Message box if cell is greater than less than 0 [Zero] | Excel Discussion (Misc queries) | |||
| code break message box | Excel Discussion (Misc queries) | |||
| Mocro code for sending a worksheet in a mail message | Excel Discussion (Misc queries) | |||
| What is the VBA code to delete a sheet without warning message? | Excel Discussion (Misc queries) | |||
| Opening a file with code without a set file name | Excel Discussion (Misc queries) | |||
Threaded Mode
