Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Good Morning Chaps and Chapesses,
I have never used Dialog boxes before, I usuually use UserForms. Are they more temperamental than userforms? This morning i have used the code from j-walk.com to generate a dialog box on the fly but ever since then I randomly get the blue screen of death that automatically reboots your machine for you (isn't it thoughtful!). It doesn't always happen when the macro is run but happens at a later date when using any program. I am using a dialog box to avoid writing too many event procedures unless anybody can tell be a nifty way of doing it. I have a varing number of checkboxes named CheckBox1, CheckBox2....etc If the checkbox is ticked I want a 1 in an array or a 0 if not ticked. Can I write an event attached to the OK button that will loop through all CheckBoxes and the condition of them and assign a value into an array? If so, can somebody give me a bit of sample code as I still get a little confused when writing action codes. Thank you all. Donna |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
When I open a spreadsheet it loads, but my screen is blue | Excel Discussion (Misc queries) | |||
Excel file opens into a blue screen with no infomation | Excel Discussion (Misc queries) | |||
Why do I get a blue screen at the opening of a workbook? | Excel Discussion (Misc queries) | |||
Blue screen | New Users to Excel | |||
Excel 2002 SP3: In Open Dialog, Some File Names Appear in Blue | Excel Discussion (Misc queries) |