Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
OLEControls Optionbuttons
Hi all,
In an Excel workbook I created a multiplechoice test. On the first sheet they select the test. On the second sheet they make the questions. The questions are in cells The possible answers are in Optionbuttons (OLEControls). The problem is: After selecting the text the right questions show up, but the anwers in the captions of the optionsbuttons only show up after clicking in the worksheet and after a delay of a few secons. There are 300 optionsbuttons (100 questions with 3 possible answers). The code for filling the controls is (part of a larger procedure): Do Until rs.EOF For Each oleObj In wsVragen.OLEObjects If TypeOf oleObj.Object Is MSForms.OptionButton Then Set optObj = oleObj.Object VraagNo = Mid(optObj.Name, 5, Len(optObj.Name) - 5) AntwoordTeken = Right(optObj.Name, 1) If rs!Vraagnummer = VraagNo And rs!Antwoordletter = AntwoordTeken Then oleObj.Visible = True optObj.Caption = rs!Antwoord & "" End If End If Next oleObj rs.MoveNext Loop rs.MoveFirst Vraag = Dutch for Question Antwoord = Dutch for Answer The question is: Why are the captions of the optionbuttons refreshed after running the code with delay? How Can I solve this problem? TIA, Jan Vente |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
OLEControls Optionbuttons
Perhaps the delay is in the record set.
Try commenting out the code that works with the OLEObjects and just steps through the record set. Does that take close to the same time. If so, perhaps you can put the recordset into an array and work from that. -- Regards, Tom Ogilvy "Jan Vente" wrote: Hi all, In an Excel workbook I created a multiplechoice test. On the first sheet they select the test. On the second sheet they make the questions. The questions are in cells The possible answers are in Optionbuttons (OLEControls). The problem is: After selecting the text the right questions show up, but the anwers in the captions of the optionsbuttons only show up after clicking in the worksheet and after a delay of a few secons. There are 300 optionsbuttons (100 questions with 3 possible answers). The code for filling the controls is (part of a larger procedure): Do Until rs.EOF For Each oleObj In wsVragen.OLEObjects If TypeOf oleObj.Object Is MSForms.OptionButton Then Set optObj = oleObj.Object VraagNo = Mid(optObj.Name, 5, Len(optObj.Name) - 5) AntwoordTeken = Right(optObj.Name, 1) If rs!Vraagnummer = VraagNo And rs!Antwoordletter = AntwoordTeken Then oleObj.Visible = True optObj.Caption = rs!Antwoord & "" End If End If Next oleObj rs.MoveNext Loop rs.MoveFirst Vraag = Dutch for Question Antwoord = Dutch for Answer The question is: Why are the captions of the optionbuttons refreshed after running the code with delay? How Can I solve this problem? TIA, Jan Vente |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Moving OptionButtons | Excel Discussion (Misc queries) | |||
Choosing Only One Of Three OptionButtons | Excel Programming | |||
Selecting OptionButtons | Excel Programming | |||
OptionButtons | Excel Programming | |||
optionbuttons | Excel Programming |