Macro to hide and unhide based on the condition in Checkbox and also Textbox

Hi Guys,

The macro code provided by chatgpt is working but then it only work partially.

anyone know how to correct the code?

In short i want excel to help me unhide column and only show me those that match my tickbox or month that input to the textbox here.

Capture.JPG

it is working halfway now, only tick will work, but when i input month for example 2, all the 2 together with the checkbox ticked will show. what i want is, when i tick actual and input 2, only actual with month 2 to show.

i have already spent the few hour with chatcpt to amend this but seems like it did not get what i want after so many attempt....

Originally Posted by MikeVol

Hello . Here's all the code for your form. Check it out and let me know if it works for you. It works for me without any problems.

bro can you please guide me how you get the code to work?

Hello @holymushroom.

bro can you please guide me how you get the code to work?

So I didn't understand you. I carefully looked at the logic of the code and I can say that in order to get the desired result you need to rewrite the entire code. But I don't have time for this, sorry. Maybe someone else can help you. Good luck.