Radio Button Values

G

Guest

Hi there - this is part of a questionnaire for some reason even if PDA is
selected it gives the answer Laptop would anyone know why this is the case as
I have a different option form later on which works fine. The code is:

frmRadio1.Show
If frmRadio1.rdPDA = True Then
Range("D4") = "Question 1c. Please state whether the information is
held on a PDA or laptop"
Range("E4") = "PDA"
Range("E4").Font.ColorIndex = 5
Columns("E").AutoFit
frmRadio1.Hide
Else
Range("D4") = "Question 1c. Please state whether the information is
held on a PDA or laptop"
Range("E4") = "Laptop"
Range("E4").Font.ColorIndex = 5
Columns("E").AutoFit
frmRadio1.Hide
End If
 
B

Bob Phillips

If you unload the form, it will fail the test. Just hide it instead.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
G

Guest

Hi,

I am hiding the form in the code, unless I am missing something - which
knowing me is very likely!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top