Thread: Dynamic Entries
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_7_] Bob Phillips[_7_] is offline
external usenet poster
 
Posts: 1,120
Default 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