Dynamic Drop downs

So you want a color selection based on a product listing…

Private Sub Worksheet_Change(ByVal Target As Range)

This sheet has the product selection in column C (3)

'If Target.Address = "$B$2" Then
If Target.Column = 3 Then

Dim sProduct As String, sFilter As String
sProduct = Target.Value

We’re going to check the Color sheet for the product code – there’s not very many rows of products in this example – only rows 2 to 5 hold the product types.

Product Name look up reference column


For iRow = 2 To 6
If Sheets("Color").Range("U" & CStr(iRow)).Value = sProduct Then
sFilter = Sheets("Color").Range("V" & CStr(iRow)).Value
sFilter = "=OFFSET(Color!$" & sFilter & "$2,0,0,COUNTA(Color!$" & sFilter & ":$" & sFilter & ")-1,1)"
End If
Next iRow

Next we delete and recreate the data validation lists based on the filter we just created looking up the products.

Range("F" & Target.Row).Validation.Delete
Range("G" & Target.Row).Validation.Delete
If Len(sFilter) > 0 Then
If sProduct = "Add-On" Then
Range("F" & Target.Row).Validation.Add xlValidateList, , , sFilter
Else
Range("F" & Target.Row).Validation.Add xlValidateList, , , "=Color!$D$2:$D$3"
Range("G" & Target.Row).Validation.Add xlValidateList, , , sFilter
End If
End If

End If

End Sub

Chicken wraps

Instapot 2 chicken breasts, plain. 

Shred into a plastic container and toss with about 2 tbsp BBQ sauce ( we like kraft garlic and more sauce isn’t a bad thing) 

Once cooled place in the centre of your favorite wrap with shredded mozzarella, a squirt of bacon ranch dressing and a handful of spinach. 

Panini press or grill until cheese is melted. 

Cut into pin wheels. 

Lazy man nochos 

Super simple 

Preheat oven to anything over 300

Brown a lb or so of hamburger

Layer nachos of choice, “zebra” cheese, hamburger and rings of onion

Bake until cheese melts 

Serve with sour cream and salsa (maybe even guacamole)

Recycled salad

Take yesterday’s stuffed potatoes and pretend you have left overs. 

On a hamburger bun, place a slice of cooked ham and a slice of turkey then heap on a good scoop of potato salad (filling from stuffed potatoes). 

Enjoy your lunch. 

Toddler omelet 

Simple attempt to get a variety of food in my toddler 

2 eggs beaten with a splash of heavy cream

Handful of shredded lunch meat

Handful of shredded cheese

Pinch of spinach 

Mushrooms fried in butter and seasoning salt