Pass value of option button

[singeredel]

Can anyone tell me what is wrong with this code? I am trying to pass the
value of the option button as yes (or no) to a userform. The spin button
values pass, but not the option button value.

With Normal.ReportFormQTCTest

optQuadisYes.Value = True

.spnScheduleDateMonth.Value = 3
.spnScheduleDateDay.Value = 8
.spnScheduleDateYear.Value = 2005
.cmbClinicLocation.Value = "010"
.cmbDoctorName.Value = "Bleecker"
.cmbClinicName.Value = "QTC"
.Show

End With

Thanks!

 

[Jean-Guy Marcil]

singeredel was telling us:
singeredel nous racontait que :

Can anyone tell me what is wrong with this code? I am trying to pass
the value of the option button as yes (or no) to a userform. The spin
button values pass, but not the option button value.

You forgot a "." (Period) just before optQuadis.... ?

With Normal.ReportFormQTCTest

optQuadisYes.Value = True

.spnScheduleDateMonth.Value = 3
.spnScheduleDateDay.Value = 8
.spnScheduleDateYear.Value = 2005
.cmbClinicLocation.Value = "010"
.cmbDoctorName.Value = "Bleecker"
.cmbClinicName.Value = "QTC"
.Show

--
Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
(e-mail address removed)
Word MVP site: http://www.word.mvps.org

 

[singeredel]

Thank you! You are so right! Doh!

singeredel was telling us:
singeredel nous racontait que :


You forgot a "." (Period) just before optQuadis.... ?


--
Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
(e-mail address removed)
Word MVP site: http://www.word.mvps.org

 

[Martin Seelhofer]

Hey there

You forgot a "." (Period) just before optQuadis.... ?

[...]
optQuadisYes.Value = True
[...]

Which reminds the careful VBA-programmer once again
to always turn on Option Explicit ;-)


Cheers,
Martin

 

[Jonathan West]

Hey there

You forgot a "." (Period) just before optQuadis.... ?

[...]
optQuadisYes.Value = True
[...]

Which reminds the careful VBA-programmer once again
to always turn on Option Explicit ;-)

Agreed!

The art of defensive programming
http://www.word.mvps.org/FAQs/MacrosVBA/MaintainableCode.htm

Why variables should be declared properly
http://www.word.mvps.org/FAQs/MacrosVBA/DeclareVariables.htm