Searchable archive

  • Thread starter shadesofsisyphus
  • Start date
S

shadesofsisyphus

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

mrice

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

Something like

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

Remember to put the option buttons in different frame
 
S

shadesofsisyphus

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

mrice

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