View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Pasty Pasty is offline
external usenet poster
 
Posts: 95
Default Radio Button Values

Hi,

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

"Pasty" wrote:

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