Dynamic Entries
Perhaps
Private Sub OptionButton1_Click()
ListBox1.RowSource = "A1:A10"
ListBox1.ListIndex = 1
End Sub
Private Sub OptionButton2_Click()
ListBox1.RowSource = "B1:B10"
ListBox1.ListIndex = 1
End Sub
--
HTH
Bob Phillips
"Richard" wrote in message
...
Hello,
I am trying to make a form where there will be a choice between A and B.
Should option A be selected within the form, I need a list to appear - say
options 1-10; should B be selected, I need a different list to appear.
Can
anybody shed some insight please?
Thanks in advance,
Richard
|