VBA Match function-using activeworksheet instead of worksheet name

Good aftrnoon and thank you in advance for any help.

I have created a code that I am using in a combobox to pull information into my userform from a worksheet. I am using the match function for a specific worksheet. What I would like to do, is be able to use the match function to pull the information into my userform based on the the current active worksheet, instead of having to specify the worksheet and creating a userform for each month (which right now is the only way I can think of because I can't seem to figure that part out My workbook is set up by month. Here is the code I created. Any help would be much apprecitated. TY...Sandy

Please Login or Register  to view this content.