|I don't use CheckBoxes for anything, but I played around a bit. Maybe someone else will come up with a more efficient way to do this...|
I created 2 Named Ranges on Sheet2, "Apparel" and "Shoes", and put some values in them.
I placed 2 CheckBoxes on Sheet1. I did not link them to a cell.
I placed the following code into the Sheet1 module.
When I click CheckBox1, the Apparel table is copied to Sheet1 starting in A1 and CheckBox2 is cleared.
When I click CheckBox2, the Shoe table is copied to Sheet1 starting in A1 and CheckBox1 is cleared.
Hope this helps...
Private Sub CheckBox1_Click()
If CheckBox1.Value = True Then
CheckBox2.Value = False
Private Sub CheckBox2_Click()
If CheckBox2.Value = True Then
CheckBox1.Value = False