Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Radio Button Values
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Radio Button Values
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) "Pasty" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Radio Button Values
Hi,
I am hiding it, unless I'm 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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Radio Button Values
Ignore that - you were right it was set as unload on the userform.
"Pasty" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
radio button | Excel Discussion (Misc queries) | |||
Help with radio button | Excel Discussion (Misc queries) | |||
How do I lock a radio button group if a N/A button is selected | Excel Discussion (Misc queries) | |||
VBA: Disable Frame and Radio Buttons based on Another Radio Button Being True | Excel Worksheet Functions | |||
Radio Button | Excel Programming |