Searchable archive

[shadesofsisyphus]

I am trying to create a searchable database with about three different
search options. i.e. choose option A to allow options d,e,f to become
available, Option B allows g,h,i, etc. I wasnt sure how to do this
using excel, and I was hoping someone would be an excel wizard that
could help me. I was thinking of using a userform and try it that way.
Any ideas?


--
shadesofsisyphus

[mrice]

Your suggestion of a user form is a good one. You could set the change event of your option A radio button to enable the radio buttons for options D, E & F.

Something like

Private Sub OptionButton1_Change()
If OptionButton1.Value Then OptionButton2.Enabled = True Else OptionButton2.Enabled = False
End Sub

Remember to put the option buttons in different frames

[shadesofsisyphus]

I suppose a little more depth is required... I need to know how to
reference the spreadsheet data from within a userform. Then have the
search conditions insert the retrieved data from sheet1 and insert it
into sheet 2, kind of... Any ideas?

mrice Wrote:
> Your suggestion of a user form is a good one. You could set the change
> event of your option A radio button to enable the radio buttons for
> options D, E & F.
>
> Something like
>
> Private Sub OptionButton1_Change()
> If OptionButton1.Value Then OptionButton2.Enabled = True Else
> OptionButton2.Enabled = False
> End Sub
>
> Remember to put the option buttons in different frames
>
>
> --
> mrice
>
> Research Scientist with many years of spreadsheet development
> experience
> ------------------------------------------------------------------------
> mrice's Profile:
> http://www.excelforum.com/member.php...o&userid=10931
> View this thread:
> http://www.excelforum.com/showthread...hreadid=540387


--
shadesofsisyphus

[mrice]

If I understand you correctly, I would suggest that you call the user form from within a macro. The form will need an OK button to confirm the selection. The click macro for this button will need to use Me.Hide to make the form disappear. In your main macro you can then test for the values of the various option buttons and move data accordingly.