Searchable archive
 

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?

Searchable archive
 

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

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?

Searchable archive
 

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.


--
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