Combo Box Question

[LynnEsther]

Hello. I'm brand new to Excel programming (I'm an Access person) and am trying to make something work but am having trouble. I have a user form with a combo box. I would like to be able to filter records on the data tab based on the user's selection from the combo box. I'd be very grateful for any suggestions.

 

[georgedwilkinson]

The cool feature Excel has over Access is it's ability to record macros (which are VBA procedures in Excel). Just record a macro (tools menu), do what you want your form to initiate, stop recording the macro, modify the procedure in question to be a little more automated, and call your new procedure from your form.

Post the code here if you have problems.